Posts by Year

2024

SCSS Notes

less than 1 minute read

Summary: SCSS Notes.

Back to Top ↑

2023

Shell Notes

5 minute read

Summary: Shell Notes.

Back to Top ↑

2022

Blood_Pressure_Recorder_Mobile_App

6 minute read

Summary: Developed a mobile APP to recognize picture of blood pressure monitor and store the data to sqlite3 database. The use can view, add, edit the record...

Back to Top ↑

2021

Install_and_Use_Intel_oneAPI_Toolkit

less than 1 minute read

Summary: Installing Intel oneAPI, run fortran code with calling Math Kernel Library on Visual Studio 2019.

Deploy PostgreSQL on Heroku

less than 1 minute read

Summary: deploy PostgreSQL on Heroku and ingest Data using Pandas and SQLAlchemy.

Create xyz-axis for PyMol

1 minute read

Summary: When show protein unit cell in PyMol, I want to show xyz axis, but PyMol doesn’t have this option. Here is a solution. Contents: Step 1: Create ...

Data Lakes with Spark

4 minute read

Summary: Data Warehouse with AWS. Building an ETL pipeline that extracts data from S3, stage them in Redshift, and transform data into a set of dimensional t...

Data Warehouse with AWS

7 minute read

Summary: Data Warehouse with AWS. Building an ETL pipeline that extracts data from S3, stage them in Redshift, and transform data into a set of dimensional t...

Data Modeling with Apache Cassandra

4 minute read

Summary: Data modeling with Apache Cassandra. Modeling event data to create a non-relational database and ETL pipeline for a music streaming app.

Data Modeling with PostgreSQL

9 minute read

Summary: Modeling user activity data to create a relational database and ETL pipeline in PostgreSQL for a music streaming app.

Story of Texas Outage in Feb 2021

4 minute read

Summary: Tableau is a popular visualization software. I collected Texas outage data and visualize it in Tableau.

10 Days of Statistics

10 minute read

Summary: solving some problems about statistics in 10 days. The problems are on HackerRank.

Back to Top ↑

2020

Set matlab scheme

less than 1 minute read

Summary: A useful package which can set matlab scheme easily.

SQL on LeetCode

4 minute read

Summary: solving the SQL problems on LeetCode.

SQL on HackerRank

6 minute read

Summary: solving the SQL problems on HackerRank.

Back to Top ↑