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.
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
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
Promotion - Database Replication

Promotion - Database Replication

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

How Databases Survive Being Unplugged: Write-Ahead Logs Explained

Comments
6 min read
Your edge rate limit is not protecting the database

Your edge rate limit is not protecting the database

Comments
4 min read
Postgres Internals in Simple Words: One Example to Understand Tables, Pages, Tuples, and Indexes

Postgres Internals in Simple Words: One Example to Understand Tables, Pages, Tuples, and Indexes

Comments
4 min read
drizzle-kit generated a DROP TABLE for a table that was still in production. drizzle-kit wasn't the problem.

drizzle-kit generated a DROP TABLE for a table that was still in production. drizzle-kit wasn't the problem.

Comments
10 min read
Single-Stage Vector Filtering for AgriTech Mandi Logistics

Single-Stage Vector Filtering for AgriTech Mandi Logistics

Comments
14 min read
Why ALTER TABLE Still Takes Down Production Postgres in 2026

Why ALTER TABLE Still Takes Down Production Postgres in 2026

Comments
4 min read
Optimistic vs Pessimistic Locking: Handling Race Conditions in High-Contention Databases

Optimistic vs Pessimistic Locking: Handling Race Conditions in High-Contention Databases

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