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.
Can I veto the agent's DDL before it hits main?

Can I veto the agent's DDL before it hits main?

Comments
7 min read
Go SQL Query Builder Without Dependencies: Relica, the ozzo-dbx Successor — What Broke on PostgreSQL and SQLite

Go SQL Query Builder Without Dependencies: Relica, the ozzo-dbx Successor — What Broke on PostgreSQL and SQLite

2
Comments 1
6 min read
ORA-00257: The Database Stopped Accepting Writes. The Archiver Is Stuck.

ORA-00257: The Database Stopped Accepting Writes. The Archiver Is Stuck.

Comments
12 min read
Backups You Have Never Restored Are Just Hope

Backups You Have Never Restored Are Just Hope

Comments
2 min read
Cohort Retention Analysis in SQL, Step by Step

Cohort Retention Analysis in SQL, Step by Step

Comments
14 min read
Funnel Conversion in SQL, and the Step That Shows 100%

Funnel Conversion in SQL, and the Step That Shows 100%

Comments
14 min read
When to Index a Table: A Practical Guide for Analysts

When to Index a Table: A Practical Guide for Analysts

Comments
15 min read
Why Your Database Needs a Taxi Stand: An Intro to Connection Pooling

Why Your Database Needs a Taxi Stand: An Intro to Connection Pooling

Comments
3 min read
Caching Strategies Explained: From Browser to Database, and the Stale Data in Between

Caching Strategies Explained: From Browser to Database, and the Stale Data in Between

Comments
10 min read
I DNA-encode my encrypted database before writing it to disk - here's why (and why it's not "quantum" anything)

I DNA-encode my encrypted database before writing it to disk - here's why (and why it's not "quantum" anything)

Comments 1
2 min read
UUID v4 vs. UUID v7 vs. ULID in 2026: Database Index Performance, B-Tree Fragmentation & When to Migrate

UUID v4 vs. UUID v7 vs. ULID in 2026: Database Index Performance, B-Tree Fragmentation & When to Migrate

2
Comments 1
8 min read
Archiving Analytics with D1 and Workers

Archiving Analytics with D1 and Workers

Comments
4 min read
Add multi-tenancy to an existing ASP.NET Core application

Add multi-tenancy to an existing ASP.NET Core application

1
Comments
5 min read
Add real search to your Python web app — no Elasticsearch, no separate service

Add real search to your Python web app — no Elasticsearch, no separate service

Comments
4 min read
CDC without Kafka: keeping Postgres, OpenSearch, and Redis in sync with one binary

CDC without Kafka: keeping Postgres, OpenSearch, and Redis in sync with one binary

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