SQLAlchemy 2.0 Textbook Ch. 1 — Introduction, Core vs ORM, and the 2.0 Mental Model
SQLAlchemy 2.0 introduction: Core vs ORM, the unified API, engine + connection, basic select / insert / update / delete.
Database
Database Migrations in 2026 — Zero-Downtime Patterns That Actually Work
Practical DB migrations: expand-contract, blue/green, pg_repack for big tables, schema deploys, and rollback strategies that work.
Zero-Downtime Database Migrations in 2026 — The Expand-and-Contract Playbook
The full expand-and-contract migration playbook. Add a column, rename a column, drop a column, change a type — each as a multi-step deploy that never blocks.
Async Python Database Drivers in 2026 — asyncpg, psycopg, and the Choices
Picking an async database driver in Python 2026. asyncpg vs psycopg 3 async, MySQL aiomysql / asyncmy, SQLite aiosqlite, libsql for Turso, and the performance / feature tradeoffs.
SQLAlchemy 2.0 Deep Patterns in 2026 — Async, Mapped Types, and Production Tricks
Beyond the SQLAlchemy 2.0 basics: mapped types in depth, async sessions, hybrid properties, lazy/eager strategies, batched inserts, dataclass mixin, and the production patterns.
Distributed SQL in 2026 — CockroachDB, Spanner, Yugabyte, and When You Actually Need One
A practical 2026 guide to distributed SQL. The architecture behind CockroachDB / Spanner / Yugabyte / TiDB, when distributed SQL earns its cost, when Postgres + read replicas is enough, and the migration realities.
PostgreSQL MVCC, Isolation, and Locking — A Backend Developer's Guide
How Postgres MVCC actually works, the four isolation levels (and what each gives you), row vs advisory locks, deadlocks, and the transaction patterns every backend developer needs to handle concurrency correctly.
Drizzle ORM Deep Dive — Type-Safe SQL for TypeScript in 2026
Why Drizzle is the right TypeScript ORM in 2026. Schema-first design, end-to-end type safety, drizzle-kit migrations, relations, transactions, JSON columns, and the patterns I reach for in production.
SQLite at the Edge in 2026 — Turso, Litestream, Cloudflare D1, and When It Beats Postgres
Why SQLite has become a serious production database in 2026. Turso/libSQL, Litestream replication, Cloudflare D1, embedded replicas with microsecond reads, the workloads where it beats Postgres, and the ones where it doesn’t.
PostgreSQL 18 — Async I/O, UUIDv7, Virtual Generated Columns, and What Actually Matters
A focused walkthrough of PostgreSQL 18 for application developers — async I/O, native uuidv7(), virtual generated columns, OAuth auth, EXPLAIN buffer reporting by default, logical replication improvements, and what to know before you upgrade.