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.
Why don’t my database numbers match? I built a tool to find out.

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

Comments
2 min read
Read Replicas Lie About Consistency. 4 Sync Modes Behind the Lie.

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

Comments
8 min read
Range Scans and Tombstones in Bf-Tree

Range Scans and Tombstones in Bf-Tree

15
Comments 1
2 min read
Building Agentic Commerce Infrastructure: Overcoming SQLite Concurrency for Autonomous Procurement Agents

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

5
Comments 8
4 min read
How to Save Bloated MCP with Code Mode

Collapsing 2,500 endpoints into two tools

How to Save Bloated MCP with Code Mode

73
Comments 31
7 min read
qrrot - database with AI

qrrot - database with AI

1
Comments
6 min read
Migrating from Neon to Supabase (Postgres + Drizzle, in production)

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

Comments
7 min read
Subqueries vs CTEs in SQL: A Complete Guide for Beginners

Subqueries vs CTEs in SQL: A Complete Guide for Beginners

Comments
8 min read
Distributed Uniqueness: Implementing Twitter Snowflake IDs in Rails 8

Distributed Uniqueness: Implementing Twitter Snowflake IDs in Rails 8

Comments
3 min read
Supabase Migration Best Practices — Timestamp Naming, Conflict Prevention, Seed Separation

Supabase Migration Best Practices — Timestamp Naming, Conflict Prevention, Seed Separation

Comments
2 min read
Change tracking and soft delete: audit trails without the boilerplate

Change tracking and soft delete: audit trails without the boilerplate

Comments
4 min read
Emergency Workaround When There’s No ER Diagram

Emergency Workaround When There’s No ER Diagram

Comments
3 min read
Time-Series in Postgres: When TimescaleDB Wins, When Native Partitioning Beats It

Time-Series in Postgres: When TimescaleDB Wins, When Native Partitioning Beats It

1
Comments
9 min read
I keep writing the same Pydantic-asyncpg wrapper. So I published it.

I keep writing the same Pydantic-asyncpg wrapper. So I published it.

2
Comments
6 min read
Connection Pooling 2026: PgBouncer vs RDS Proxy vs Supabase Pooler

Connection Pooling 2026: PgBouncer vs RDS Proxy vs Supabase Pooler

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