---
title: "#database articles | Hashnode"
description: "Explore 1,603 articles tagged #database on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/database"
---

Tag

# #database

1,603 posts · 218 followers

[Anatolii Zhadan](https://hashnode.com/@anatoliizhadan) · [7h ago](https://hashnode.com/posts/reading-postgres-explain-analyze-when-the-planner-expects-300-rows-and-gets-15-000/6afcde9438c911cbefe3ffbe)

### [Reading Postgres EXPLAIN ANALYZE when the planner expects 300 rows and gets 15,000](https://anatoliizhadan.hashnode.dev/reading-postgres-explain-analyze-when-the-planner-expects-300-rows-and-gets-15-000?utm_source=hashnode&utm_medium=feed)

A 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](https://anatoliizhadan.hashnode.dev/reading-postgres-explain-analyze-when-the-planner-expects-300-rows-and-gets-15-000?utm_source=hashnode&utm_medium=feed)

[Payyavula Balanagaraju](https://hashnode.com/@nagaraju2506) · [10h ago](https://hashnode.com/posts/postgres-planner-patch-8-bugs-tom-lane-fix/6afcaea33f8ee370a14b33a0)

### [I patched the Postgres planner, found 8 bugs in my own patch, then proved Tom Lane's fix with one commit](https://depthfirst.hashnode.dev/postgres-planner-patch-8-bugs-tom-lane-fix?utm_source=hashnode&utm_medium=feed)

I 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](https://depthfirst.hashnode.dev/postgres-planner-patch-8-bugs-tom-lane-fix?utm_source=hashnode&utm_medium=feed)

[Jay Patel](https://hashnode.com/@joyy) · [1d ago](https://hashnode.com/posts/inside-cve-2026-6460-how-a-22-year-old-postgresql-type-confusion-bug-turns-alter-table-into-remote-code-execution/6afbd344e0dd8eaaba28f0ba)

### [Inside CVE-2026-6460: How a 22-Year-Old PostgreSQL Type Confusion Bug Turns ALTER TABLE into Remote Code Execution](https://jaypatel2403.hashnode.dev/inside-cve-2026-6460-how-a-22-year-old-postgresql-type-confusion-bug-turns-alter-table-into-remote-code-execution?utm_source=hashnode&utm_medium=feed)

How does the ALTER TABLE and transaction rollback exploit chain lead to RCE?

6 min read · [jaypatel2403.hashnode.dev](https://jaypatel2403.hashnode.dev/inside-cve-2026-6460-how-a-22-year-old-postgresql-type-confusion-bug-turns-alter-table-into-remote-code-execution?utm_source=hashnode&utm_medium=feed)

[Muhammad Ahmad](https://hashnode.com/@muhammadahmadsandhu) · [1d ago](https://hashnode.com/posts/why-sqlite-pragma-integrity-check-misses-broken-foreign-keys/6afbb6b2032c56a0fdd2a591)

### [Two Silent SQLite Production Bugs: Why PRAGMA integrity\_check Passes on Broken Foreign Keys and Slow Joins](https://kivarotools.hashnode.dev/why-sqlite-pragma-integrity-check-misses-broken-foreign-keys?utm_source=hashnode&utm_medium=feed)

Why 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](https://kivarotools.hashnode.dev/why-sqlite-pragma-integrity-check-misses-broken-foreign-keys?utm_source=hashnode&utm_medium=feed)

[Powerduck](https://hashnode.com/@powerduck) · [1d ago](https://hashnode.com/posts/codegen-custom-logging-middleware/6afb20a3d2bdb7937c0c9055)

### [Codegen Custom Logging Middleware](https://blogs.powerduck.com/codegen-custom-logging-middleware?utm_source=hashnode&utm_medium=feed)

How to add structured logging to a generated client.

4 min read · [blogs.powerduck.com](https://blogs.powerduck.com/codegen-custom-logging-middleware?utm_source=hashnode&utm_medium=feed)

[Denys Zaichenko](https://hashnode.com/@madsalttech) · [1d ago](https://hashnode.com/posts/audit-your-supabase-project-from-the-sql-editor/6afb09e64c910ad75080203b)

### [Audit your Supabase project from the SQL editor](https://madsalt.hashnode.dev/audit-your-supabase-project-from-the-sql-editor?utm_source=hashnode&utm_medium=feed)

Five catalog queries that show what your public key can reach, and how to read each result.

5 min read · [madsalt.hashnode.dev](https://madsalt.hashnode.dev/audit-your-supabase-project-from-the-sql-editor?utm_source=hashnode&utm_medium=feed)

[Salma](https://hashnode.com/@salmazz45) · [1d ago](https://hashnode.com/posts/does-a-1tb-database-automatically-mean-big-data/6afafc6e6cc89feaf2e1cda2)

### [Does a 1TB Database Automatically Mean Big Data?](https://salma-mehanny.hashnode.dev/does-a-1tb-database-automatically-mean-big-data?utm_source=hashnode&utm_medium=feed)

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 dist

4 min read · [salma-mehanny.hashnode.dev](https://salma-mehanny.hashnode.dev/does-a-1tb-database-automatically-mean-big-data?utm_source=hashnode&utm_medium=feed)

[Abivarma R S](https://hashnode.com/@abivarma) · [1d ago](https://hashnode.com/posts/replication-lag-is-why-your-ai-agent-looks-like-it-s-hallucinating/6afadf20dcb949ac0aec30b3)

### [Replication Lag Is Why Your AI Agent Looks Like It's Hallucinating](https://ai-decoded.hashnode.dev/replication-lag-is-why-your-ai-agent-looks-like-it-s-hallucinating?utm_source=hashnode&utm_medium=feed)

The 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 transactional

3 min read · [ai-decoded.hashnode.dev](https://ai-decoded.hashnode.dev/replication-lag-is-why-your-ai-agent-looks-like-it-s-hallucinating?utm_source=hashnode&utm_medium=feed)

[Noah Grinstein](https://hashnode.com/@noahcontrolplane) · [1d ago](https://hashnode.com/posts/how-to-fail-over-a-database-backed-application-between-cloud-regions-database-options-compared-and-a-step-by-step-runbook/6afac4890ff28b83f8f55570)

### [How to Fail Over a Database-Backed Application Between Cloud Regions: Database Options Compared and a Step-by-Step Runbook](https://controlplane-eng.hashnode.dev/how-to-fail-over-a-database-backed-application-between-cloud-regions-database-options-compared-and-a-step-by-step-runbook?utm_source=hashnode&utm_medium=feed)

Fence 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](https://controlplane-eng.hashnode.dev/how-to-fail-over-a-database-backed-application-between-cloud-regions-database-options-compared-and-a-step-by-step-runbook?utm_source=hashnode&utm_medium=feed)

[Munish Kumar Sharma](https://hashnode.com/@CodeWithMishu) · [2d ago](https://hashnode.com/posts/stop-defaulting-to-mongodb-a-practical-database-decision-framework-for-full-stack-builders/6af9b19d79631e0fbab14da2)

### [Stop Defaulting to MongoDB: A Practical Database Decision Framework for Full-Stack Builders](https://blogs.codewithmishu.in/stop-defaulting-to-mongodb-a-practical-database-decision-framework-for-full-stack-builders?utm_source=hashnode&utm_medium=feed)

Why 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.in](https://blogs.codewithmishu.in/stop-defaulting-to-mongodb-a-practical-database-decision-framework-for-full-stack-builders?utm_source=hashnode&utm_medium=feed)
