Recent Posts

Shell Notes

5 minute read

Summary: Shell Notes.

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...

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.