10 min read
The DuckDB Pattern When SQLite Is Not Enough but Postgres Is Overkill
DuckDB scans 10M rows in under a second on a laptop
The Lab · Written in the open · Tagged Database
Lab.
Working notes from the studio. The tools I build, the workflows I keep, the mistakes I paid for.
9 entries · latest 2026-07-03
Latest entry
Why I Stopped Reaching for Redis on Solo Projects
Six Redis use cases replaced with SQLite, Postgres, and Edge KV Rate limiting fits in one SQLite table with 40 lines Postgres LISTEN handles pubsub without a second service One place Redis still wins: high-throughput shared queues I ran Redis...
Read the entry
TLDR
This entry in one minute
- Six Redis use cases replaced with SQLite, Postgres, and Edge KV
- Rate limiting fits in one SQLite table with 40 lines
- Postgres LISTEN handles pubsub without a second service
All entries · Database
9 min read
SQLite is Enough: 5 RAXXO Services I Moved Off Postgres
Moved 5 RAXXO services off Postgres + Neon to SQLite + better-sqlite3 in WAL mode
9 min read
Neon Database Branching Saved Me 200 EUR Every Month
I run 14 Neon database branches per project for the price of one Postgres instance
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.
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.
5 min read
Drizzle ORM with Neon Postgres: A Practical Guide
A practical guide to using Drizzle ORM with Neon serverless Postgres. Schema design, migrations, queries, and deployment patterns…
5 min read
Supabase vs Neon: Choosing a Serverless Database in 2026
Supabase vs Neon compared for serverless Postgres in 2026. Features, pricing, DX, and which one works better for…