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.
PostgreSQL 19's REPACK CONCURRENTLY swaps a five-second table lock for one under a second

PostgreSQL 19's REPACK CONCURRENTLY swaps a five-second table lock for one under a second

9
Comments
6 min read
Best Data Modeling Tools for Git & DevOps Workflows (2026): Version Control and CI/CD Compared

Best Data Modeling Tools for Git & DevOps Workflows (2026): Version Control and CI/CD Compared

Comments
11 min read
Who stabbed Samuel Ratchett 12 times?🔪

Who stabbed Samuel Ratchett 12 times?🔪

Comments
1 min read
One missing index turned a 40ms query into a 12-second one

One missing index turned a 40ms query into a 12-second one

Comments
3 min read
Streaming Cross-Border Liquidity Intelligence with Exactly-Once Controls Across Asia - Hong Kong Databricks FSI Community Day 2026

Streaming Cross-Border Liquidity Intelligence with Exactly-Once Controls Across Asia - Hong Kong Databricks FSI Community Day 2026

Comments
4 min read
Replacing deep OFFSET pagination in D1: rows read and inserts between pages

Replacing deep OFFSET pagination in D1: rows read and inserts between pages

Comments 1
4 min read
MySQL Development Setup – macOS Apple Silicon (ARM)

MySQL Development Setup – macOS Apple Silicon (ARM)

Comments
3 min read
A Row Version Is a Cross-Layer Contract

A Row Version Is a Cross-Layer Contract

1
Comments 1
4 min read
Sepio.dev: I've built a Figma style database designing tool

Sepio.dev: I've built a Figma style database designing tool

1
Comments
1 min read
Vector database showroom. Part 1 pgvector — The Station Wagon Already in Your Garage.

Vector database showroom. Part 1 pgvector — The Station Wagon Already in Your Garage.

Comments
3 min read
Eliminating Cross-Shard Transactions: Patterns and Trade-offs

Eliminating Cross-Shard Transactions: Patterns and Trade-offs

Comments
9 min read
A ~40MB binary that speaks Postgres, MySQL, Redis, Kafka and Elasticsearch

A ~40MB binary that speaks Postgres, MySQL, Redis, Kafka and Elasticsearch

Comments 2
1 min read
Postgres Multi-Tenancy: Row-Level Security, tenant_id Filters, or a Schema per Tenant?

Postgres Multi-Tenancy: Row-Level Security, tenant_id Filters, or a Schema per Tenant?

Comments
7 min read
How Databases Survive Being Unplugged: Write-Ahead Logs Explained

How Databases Survive Being Unplugged: Write-Ahead Logs Explained

Comments
6 min read
Promotion - Database Replication

Promotion - Database Replication

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