Basic overview of parallel / concurrent programming, including comparisons between multiprocessing, multithreading, and asyncio (coroutines) in Python.
A list of common expressions for working with date, time, datetime, and timestamp columns in MySQL 5.7.x and Redshift.
Using Python, a short example on how to delegate specified methods to another object, as compared to composition and inheritance.
How to use enums in your models to enforce value consistency.
A template file for using conditional arguments when running Python scripts from the command line.
I've always struggled to remember between these very similar methods in the SQLALchemy ORM - so I took some time out to research these and write it down.
A few notes on the code review process, and the steps I go through when reviewing.
Some thoughts on what code reviews are and are not.
Building model definitions for many-to-many relationships via a secondary table.