Update Date: 2024-03-06 Multiple Tables Combine Tables by Inner Joins SELECT table1.c1, table2.c2 FROM table1 JOIN table2 ON table1.c3 = table2.c3; This merges two tables according to c3. If...

Update Date: 2024-03-06 Aggregation Statement COUNT select COUNT(column1) from tableName COUNT returns the number of valid rows. (not null) Also, we can use 1 or * to represent all columns to ret...

Update Date: 2024-03-05 Query Statement Select -- select all columns select * from tableName; -- select specific columns select column1, column2, ..., columnN from tableName; As -- rename column ...

Update Date: 2024-02-15 Manipulation Statements Create a new table create table table_name ( column1 datatype, column2 datatype, ); Modify columns alter table table_name -- add a new col...

Update Date: 2024-01-03 1. Introduction This blog is about the reading and we will go through the official documentation. The content might be very similar to the document for sure and add some co...

Update Date: 2024-01-03 1. Introduction In this series, I will try to write developing log about using mapbox to cooperate the location and photo information together into an application. This is a...

Update Date: 2024-01-02 1. Docker Build Images docker build suffixes --no-cached: 避免在build 時被cache 住，而使修改的部分無法build Check Images docker images Run Images docker run {ImageName} suffixes 2...

Update Date: 2023-12-03 Custom Colorbar from_levels_and_colors from matplotlib.colors import from_levels_and_colors def getCmapAndNorm(cmapName, levels, extend="neither"): cmap = plt.get_cma...

Update Date: 2023-12-03 Refresh .gitignore vim .gitignore git rm -r --cached . git add . git commit -m "comments" If there is some files you commited and not push yet, and you want to add this ty...

Introduction The cloud tracking algorithm presented here builds upon the Iterative Rain Cell Tracking (IRT) algorithm developed by Moseley and Haeter in 2020. We have expanded this approach from tr...