Edge databases — when ready for production
Turso, Cloudflare D1, Neon edge — read replicas in 200+ locations. Beautiful demos, real-world pitfalls.
Edge DB promise: write to one region, read everywhere with low latency. Turso (libSQL), D1 (SQLite-based on Cloudflare), Neon edge proxy.
What works: read-heavy apps. Marketing sites, dashboards, e-commerce browse pages.
What fails: write-heavy apps. Eventual consistency means you read stale data right after writing it. Surprises everyone.
For a SaaS with global users where reads dominate: edge DB is a real win. For a transactional app: stick with single-region Postgres.