Field notes on database change management
Honest, practical writing on Postgres schemas, drift, migrations, and shipping AI-generated SQL you can actually trust. No vaporware, no hype.
- ·Supabase comparison Branching
Supabase branching vs LeafSQL: what branching doesn't solve
Supabase branching spins up preview databases and applies migrations. It doesn't catch out-of-band drift, diff arbitrary environments, or push migration PRs. Here's the gap.
Read post - ·AI SQL Guarded writes Postgres
Why we let an LLM write SQL but never execute it unreviewed
An LLM is good at drafting SQL and bad at being trusted with production. Here's the guarded write loop LeafSQL uses — classify, confirm, execute, rollback — and why.
Read post - ·Postgres Schema diff Environments
How to diff a Postgres schema between environments
A postgres schema diff between environments catches dev/staging/prod divergence before a deploy fails. Here's the catalog query to run by hand — and how LeafSQL does it.
Read post - ·Postgres Schema drift Migrations
How to detect schema drift in Postgres
Schema drift is when your Postgres database changes outside your migrations. Here's how to catch it with plain catalog queries — and how LeafSQL alerts you the moment it happens.
Read post