The Best Visual To Explain SQL JOINs
I found the best visual to explain LEFT / RIGHT / INNER / OUTER JOIN in SQL.
May 15, 2020 ·
3 min read
How To Set Default Value: Postgres vs. MySQL
Compare the syntax of setting default values in Postgres and MySQL
May 15, 2020 ·
2 min read
Run Postgres in Docker with One Command
How to run Postgres in Docker without installing local postgres
May 15, 2020 ·
3 min read
How To Consume GCP AI Model Via API
My notes about how to send prediction requests to Google Cloud Platform AI models
May 15, 2020 ·
2 min read
Quickest Way To Add Emoji In Mac OS X
Use the shortcut to type emoji anywhere in Mac OS X
May 11, 2020 ·
1 min read
Send BigQuery Results to Datadog?
How I solved this problem with Google Data Studio
May 11, 2020 ·
2 min read
Building An API To Import Data From Excel
If you are building an Excel Importer service, this post covers my experience and lessons learned.
Apr 27, 2020 ·
10 min read
From Substack to Ghost to elink: Reasoning About Content Writing Tools
Trying to make sense of the existing product offering from a perspective of a developer / niche blogger.
Apr 25, 2020 ·
5 min read
Should We Run Database Seed and Migrations In Dockerfile?
This answers the question about one-off tasks in Dockerfile
Apr 22, 2020 ·
4 min read
Use Pandas for ETL: Experience and Practical Tips
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