Everything I’ve published, in one place. Posts on this site appear in the archives and in the RSS feed; the rest lives on project sites and is indexed here so nothing gets lost between platforms.

On this site

Analysis and essays on data architecture, PostgreSQL, and deployment engineering — browse the archives for the full list.

On the pgmi project blog

Hands-on PostgreSQL deployment engineering, written around pgmi — an open-source PostgreSQL-native deployment tool I build and maintain. Examples in these articles are verified against live PostgreSQL instances.

  • AI agents write PostgreSQL like Python — July 2026. Defensive SQL patterns for code that AI agents write: input materialization, safe casting, and why exception-driven control flow doesn’t translate to the database.
  • Test PostgreSQL migrations before COMMIT — July 2026. Running assertions inside the deployment transaction, so a failed check rolls back the whole deployment instead of leaving it half-applied.

Elsewhere: GitHub · LinkedIn