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.
JSONB vs Relational in 2026: 5 Query Shapes, 5 Verdicts
gabrielanhaia profile

JSONB vs Relational in 2026: 5 Query Shapes, 5 Verdicts

#postgres #database #performance #backend
Comments
8 min read
Logical Replication for Migrations: Zero-Downtime Postgres Upgrades in 2026
gabrielanhaia profile

Logical Replication for Migrations: Zero-Downtime Postgres Upgrades in 2026

#postgres #database #devops #replication
Comments
9 min read
Read-Modify-Write: The Optimistic Concurrency Pattern Most ORMs Get Wrong
gabrielanhaia profile

Read-Modify-Write: The Optimistic Concurrency Pattern Most ORMs Get Wrong

#database #orm #concurrency #backend
Comments
8 min read
Postgres VACUUM Tuning: 4 Settings That Decide Whether Autovacuum Keeps Up
gabrielanhaia profile

Postgres VACUUM Tuning: 4 Settings That Decide Whether Autovacuum Keeps Up

#postgres #database #performance #devops
Comments
8 min read
An index made our query faster. It slowly suffocated our database.
diata0210 profile

An index made our query faster. It slowly suffocated our database.

#database #backend #performance #webdev
Comments
5 min read
You might not need… the repository pattern
jayfreestone profile

You might not need… the repository pattern

#architecture #backend #database
1
Comments
9 min read
Single-Node Data Engineering: DuckDB, DataFusion, Polars, and LakeSail
alexmercedcoder profile

Single-Node Data Engineering: DuckDB, DataFusion, Polars, and LakeSail

#architecture #database #dataengineering #performance
1
Comments
18 min read
Level Up Your SQL: Subqueries & CTEs in the Real World
adev3loper profile

Level Up Your SQL: Subqueries & CTEs in the Real World

#sql #dataengineering #database #assignment
Comments
9 min read
Why don’t my database numbers match? I built a tool to find out.
harrywynn profile

Why don’t my database numbers match? I built a tool to find out.

#database #webdev #programming #dataengineering
Comments
2 min read
Read Replicas Lie About Consistency. 4 Sync Modes Behind the Lie.
gabrielanhaia profile

Read Replicas Lie About Consistency. 4 Sync Modes Behind the Lie.

#postgres #database #distributedsystems #backend
Comments
8 min read
Range Scans and Tombstones in Bf-Tree
lovestaco profile

Range Scans and Tombstones in Bf-Tree

#webdev #programming #database #architecture
15
Comments 1
2 min read
Building Agentic Commerce Infrastructure: Overcoming SQLite Concurrency for Autonomous Procurement Agents
anhmtk profile

Building Agentic Commerce Infrastructure: Overcoming SQLite Concurrency for Autonomous Procurement Agents

#ai #database #webdev #mcp
5
Comments 8
4 min read
How to Save Bloated MCP with Code Mode

Collapsing 2,500 endpoints into two tools
jiasheng profile
JS for ZenStack

How to Save Bloated MCP with Code Mode

#ai #webdev #agents #database
73
Comments 31
7 min read
qrrot - database with AI
piterovxyz profile

qrrot - database with AI

#ai #go #sql #database
1
Comments
6 min read
Migrating from Neon to Supabase (Postgres + Drizzle, in production)
blackie360 profile

Migrating from Neon to Supabase (Postgres + Drizzle, in production)

#database #nextjs #postgres #tutorial
Comments
7 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.