11 min read
The 5 Postgres Extensions Every Shopify Backend Needs
pg_cron, pgvector, pg_partman, pg_stat_statements, postgres_fdw. The five extensions that turn generic Postgres into a Shopify-aware database.
The Lab · Written in the open · Tagged postgres
Lab.
Working notes from the studio. The tools I build, the workflows I keep, the mistakes I paid for.
5 entries · latest 2026-05-02
Latest entry
Neon Database Branching Saved Me 200 EUR Every Month
I run 14 Neon database branches per project for the price of one Postgres instance Neon copy-on-write branching clones a 12 GB database in under 1 second A GitHub Action spins up a fresh branch per pull request and tears...
Read the entry
Latest entry · Development
All entries · postgres
8 min read
The 8 Drizzle ORM Patterns I Use in Every Shopify Backend
Schema-first pgTable definitions and drizzle-kit migrations keep my Shopify backend predictable across 6 projects.
10 min read
The 7 Postgres Indexes That Took My API From 400ms to 40ms
I took one of my APIs from 400ms p95 to 40ms p95 by fixing 7 missing or wrong…
2 min read
Building a Global Leaderboard with Neon Postgres and Zero Infrastructure Cost
Serverless Postgres for side projects. One npm install, one env var, global leaderboard running for free.