DEV Community

Database

Posts on building, using, and learning about databases.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Our Dashboard Looked Fine. The Database Was Out of Connections.

Our Dashboard Looked Fine. The Database Was Out of Connections.

Comments
4 min read
RecallOps: Building Persistent Memory for Engineering Incident Response

RecallOps: Building Persistent Memory for Engineering Incident Response

Comments 1
5 min read
Changing one field in a 100KB document, in Postgres and in MongoDB

Changing one field in a 100KB document, in Postgres and in MongoDB

9
Comments
6 min read
What Building an LLM-Offloaded Query Layer Taught Me

What Building an LLM-Offloaded Query Layer Taught Me

1
Comments 1
16 min read
Window Functions, Joins, CTEs and Subqueries in SQL: A Hospital Dataset Walkthrough.

Window Functions, Joins, CTEs and Subqueries in SQL: A Hospital Dataset Walkthrough.

Comments
9 min read
PostgreSQL vs MongoDB di Era AI: Masihkah Document Store Menjadi Pilihan Utama?

PostgreSQL vs MongoDB di Era AI: Masihkah Document Store Menjadi Pilihan Utama?

Comments 2
2 min read
How to Give Claude & Cursor Safe Database Access Without Crashing Production (Zero-Trust MCP Guard in Python)

How to Give Claude & Cursor Safe Database Access Without Crashing Production (Zero-Trust MCP Guard in Python)

Comments
3 min read
A PostgreSQL deadlock hiding in a foreign key check

A PostgreSQL deadlock hiding in a foreign key check

Comments
12 min read
I Almost Published a Chart Saying the Nifty Fell 51% in 2003. It Fell 16%. Here Is the Bug.

I Almost Published a Chart Saying the Nifty Fell 51% in 2003. It Fell 16%. Here Is the Bug.

1
Comments 1
5 min read
Vector Databases Are Missing a Foreign Key to the Model Version

Vector Databases Are Missing a Foreign Key to the Model Version

Comments 1
4 min read
Three Supabase RLS settings worth checking before launch

Three Supabase RLS settings worth checking before launch

Comments
2 min read
LSM-Trees Explained: The Storage Engine Behind Millions of Writes per Second

LSM-Trees Explained: The Storage Engine Behind Millions of Writes per Second

2
Comments 2
15 min read
SQL for Frontend Engineers: Model the Relationship First

SQL for Frontend Engineers: Model the Relationship First

Comments
6 min read
When ClickHouse merges change your query results

When ClickHouse merges change your query results

1
Comments 6
11 min read
What’s the SQLite equivalent for full-text and vector search?

What’s the SQLite equivalent for full-text and vector search?

Comments
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.