I found the best visual to explain LEFT / RIGHT / INNER / OUTER JOIN in SQL.
May 15, 2020 ·
3 min read
Compare the syntax of setting default values in Postgres and MySQL
May 15, 2020 ·
2 min read
How to run Postgres in Docker without installing local postgres
May 15, 2020 ·
3 min read
My notes about how to send prediction requests to Google Cloud Platform AI models
May 15, 2020 ·
2 min read
Use the shortcut to type emoji anywhere in Mac OS X
May 11, 2020 ·
1 min read
How I solved this problem with Google Data Studio
May 11, 2020 ·
2 min read
If you are building an Excel Importer service, this post covers my experience and lessons learned.
Apr 27, 2020 ·
10 min read
Trying to make sense of the existing product offering from a perspective of a developer / niche blogger.
Apr 25, 2020 ·
5 min read
This answers the question about one-off tasks in Dockerfile
Apr 22, 2020 ·
4 min read
This post talks about my experience of building a small scale ETL with Pandas. It also offers some hands-on tips that may help you build ETLs with Pandas.
Dec 23, 2019 ·
5 min read