AAnatolii Zhadan·7h agoReading Postgres EXPLAIN ANALYZE when the planner expects 300 rows and gets 15,000A bad plan starts at the lowest node where expected and actual rows split, and every node above it is built on that wrong number.15 min read·anatoliizhadan.hashnode.dev
PPayyavula Balanagaraju·10h agoI patched the Postgres planner, found 8 bugs in my own patch, then proved Tom Lane's fix with one commitI patched the Postgres planner: 194,910 ms to 114 ms. Then I found 8 bugs in my patch and proved Tom Lane's better fix with an A/B on one commit.8 min read·depthfirst.hashnode.dev
JJay Patel·1d agoInside CVE-2026-6460: How a 22-Year-Old PostgreSQL Type Confusion Bug Turns ALTER TABLE into Remote Code ExecutionHow does the ALTER TABLE and transaction rollback exploit chain lead to RCE?6 min read·jaypatel2403.hashnode.dev
MMuhammad Ahmad·1d agoTwo Silent SQLite Production Bugs: Why PRAGMA integrity_check Passes on Broken Foreign Keys and Slow JoinsWhy SQLite leaves foreign keys disabled by default, why it never auto-indexes FK columns, and how to audit .sqlite files in browser RAM.4 min read·kivarotools.hashnode.dev
PPowerduck·1d agoCodegen Custom Logging MiddlewareHow to add structured logging to a generated client.4 min read·blogs.powerduck.com
DDenys Zaichenko·1d agoAudit your Supabase project from the SQL editorFive catalog queries that show what your public key can reach, and how to read each result.5 min read·madsalt.hashnode.dev
SSalma·1d agoDoes a 1TB Database Automatically Mean Big Data?Big Data Through a System Design Lens — Part 1 A database grows to 1TB. Does that mean it's time to introduce Apache Spark, Kafka, or a distributed database? Not necessarily. One of the important dist4 min read·salma-mehanny.hashnode.dev
AAbivarma R S·1d agoReplication Lag Is Why Your AI Agent Looks Like It's HallucinatingThe usual assumption: when an agent checks an order's status, sees active, and ships an order the customer cancelled a second earlier, the model hallucinated. Fix the prompt. In a lot of transactional3 min read·ai-decoded.hashnode.dev
NNoah Grinstein·1d agoHow to Fail Over a Database-Backed Application Between Cloud Regions: Database Options Compared and a Step-by-Step RunbookFence the old primary, promote a replica in the healthy region, repoint the app, then move traffic. Database options compared plus a runbook.21 min read·controlplane-eng.hashnode.dev
MMunish Kumar Sharma·2d agoStop Defaulting to MongoDB: A Practical Database Decision Framework for Full-Stack BuildersWhy the one-size-fits-all database mindset causes latency bottlenecks and ballooning cloud bills—plus the exact 4-quadrant decision matrix and ORM benchmarks for modern full-stack architectures.10 min read·blogs.codewithmishu.in1