Related Posts
ai startup development
PostgreSQL LISTEN/NOTIFY as a lightweight job queue: replacing Redis for your startup's background tasks
Building a zero-dependency job queue using PostgreSQL's LISTEN/NOTIFY channels with SKIP LOCKED advisory locks, comparing throughput benchmarks against Redis-ba
· 1 min read
ai startup development
SQLite WAL Mode, Connection Pooling, and Room's Query Planner: The Mobile Database Performance Patterns That Survive Offline-First at Scale
Deep dive into SQLite's WAL vs DELETE journal modes, how Room's InvalidationTracker triggers unnecessary recomputations, connection pool sizing for concurrent r
· 6 min read
ai startup development
Compose stability: the recomposition model senior devs get wrong
Deep dive into how the Compose compiler assigns stability to types, how strong skipping mode (default since Compose Compiler 2.0) changes the old mental model o
· 5 min read