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.
Your Node API isn't slow. It's waiting for a database connection.

Your Node API isn't slow. It's waiting for a database connection.

Comments
5 min read
PostgreSQL 19's pg_stat_lock only counts waits that cross deadlock_timeout

PostgreSQL 19's pg_stat_lock only counts waits that cross deadlock_timeout

8
Comments
7 min read
ClickHouse 26.10's string filter during scan cuts a selective LIKE query's memory 25-fold

Explores fine print caveats and PREWHERE rewrites

ClickHouse 26.10's string filter during scan cuts a selective LIKE query's memory 25-fold

13
Comments 5
7 min read
The timeout that ate the database pool: how Inngest lost every connection twice in one afternoon

The timeout that ate the database pool: how Inngest lost every connection twice in one afternoon

Comments 2
7 min read
Your primary key is a storage decision

Your primary key is a storage decision

Comments
3 min read
CRM ile dış sistemler arasında çift yönlü veri senkronizasyonu: Alan sahipliği, değişiklik imleci, döngü önleme ve çakışma çözümü

CRM ile dış sistemler arasında çift yönlü veri senkronizasyonu: Alan sahipliği, değişiklik imleci, döngü önleme ve çakışma çözümü

Comments
9 min read
Why I reach for a UUID v4 instead of an auto-increment ID

Why I reach for a UUID v4 instead of an auto-increment ID

Comments
2 min read
How to Build a Peptide Research Database Using Python and SQLite

How to Build a Peptide Research Database Using Python and SQLite

Comments
5 min read
How Databases Safely Ignore Obsolete Writes: Thomas Write Rule Explained

How Databases Safely Ignore Obsolete Writes: Thomas Write Rule Explained

Comments
2 min read
Visual Paradigm Alternative: Database Design Software Without the Modeling Suite

Visual Paradigm Alternative: Database Design Software Without the Modeling Suite

Comments
19 min read
How to Deploy Your First Agent to MongoDB Atlas Agent Engine

How to Deploy Your First Agent to MongoDB Atlas Agent Engine

Comments
16 min read
Building Sovereign In-Memory Vector Search & Neural Reranking in Pure Python: HNSW Graphs, SQ8 Quantization & Hybrid BM25 Fusion

Building Sovereign In-Memory Vector Search & Neural Reranking in Pure Python: HNSW Graphs, SQ8 Quantization & Hybrid BM25 Fusion

Comments
4 min read
Speak to your database: Safely read your PG/SQL DB with Query Studio MCP server

Speak to your database: Safely read your PG/SQL DB with Query Studio MCP server

Comments
10 min read
PostgreSQL 14 End of Life on 12 November 2026: How to Upgrade Postgres in Docker

PostgreSQL 14 End of Life on 12 November 2026: How to Upgrade Postgres in Docker

Comments
9 min read
Renaming a column in SQL Server, and what it quietly breaks

Renaming a column in SQL Server, and what it quietly breaks

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