DATABASE
9 items
4 posts, 5 tools
PGSimCity is a 3D city that visualizes PostgreSQL internals - shared buffers, WAL, autovacuum, checkpoints and replication. How it works and what HN said.
SQLite's flexible typing lets you store anything anywhere. STRICT mode fixes that - here's why you should enable it for every new table.
Neon Postgres review and setup for AI app builders - branching, scale-to-zero, the serverless driver, verified pricing, and who should skip it.
PgDog is a Rust proxy for Postgres pooling, replica load balancing and sharding. How it compares to PgBouncer and Citus, and whether your stack needs it.
TypeScript ORM with a schema-first workflow. Prisma Client gives full type safety; Prisma Migrate handles migrations. Prisma ORM 8 covers Postgres, MongoDB, and SQLite; MySQL still needs Prisma ORM 7.
Serverless Postgres with branching. Free tier, instant database branches per PR, autoscaling compute, and scale-to-zero. Acquired by Databricks in 2025.
Database platform for MySQL on Vitess, PlanetScale Postgres, and Neki (sharded Postgres), with branching, non-blocking schema changes, and horizontal sharding. There is no free or hobby tier; PlanetScale Postgres single node starts at $5/month.
Open-source Firebase alternative built on Postgres. Auth, real-time subscriptions, storage, edge functions, and pgvector for AI embeddings. Generous free tier.
Reactive backend - database, server functions, real-time sync, cron jobs, file storage. All TypeScript. This site's backend (courses, videos, user data) runs on Convex.

Get Smarter About AI Dev
New tutorials, open-source projects, and deep dives on coding agents - delivered weekly.