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.
One writer at a time: SQLite and D1 concurrency, busy locks, and schema changes that ship without downtime

One writer at a time: SQLite and D1 concurrency, busy locks, and schema changes that ship without downtime

Comments
19 min read
How I Use Python's sqlite3 Module to Keep Small Script Data Organized

How I Use Python's sqlite3 Module to Keep Small Script Data Organized

Comments
4 min read
Respaldo cifrado y restauraciĂłn verificada para Azure Cosmos DB con GitHub Actions

Respaldo cifrado y restauraciĂłn verificada para Azure Cosmos DB con GitHub Actions

Comments
5 min read
How to Prove an Outdated Document Actually Left Your Vector Database (The Tombstone Canary Pattern)

How to Prove an Outdated Document Actually Left Your Vector Database (The Tombstone Canary Pattern)

3
Comments
9 min read
Next.js Server Actions bodySizeLimit: Raising Isn't Enough

Next.js Server Actions bodySizeLimit: Raising Isn't Enough

Comments
4 min read
From USGS GeoJSON to a Public Earthquake Report with Python and SQLite

From USGS GeoJSON to a Public Earthquake Report with Python and SQLite

Comments
3 min read
Grade once, prove it forever: 46,756 settled calls and the case for an append-only grading ledger

Grade once, prove it forever: 46,756 settled calls and the case for an append-only grading ledger

Comments 1
6 min read
Una copia que nadie restaurĂł no es una copia: backups de Firestore verificados con GitHub Actions

Una copia que nadie restaurĂł no es una copia: backups de Firestore verificados con GitHub Actions

Comments
6 min read
I Wrote a Wasteful JOIN on Purpose. It Ran Faster, Until It Didn't.

I Wrote a Wasteful JOIN on Purpose. It Ran Faster, Until It Didn't.

Comments
6 min read
What it took to write dBASE and FoxPro files that the 90s apps still trust

What it took to write dBASE and FoxPro files that the 90s apps still trust

Comments
4 min read
How MySQL Commits and Recovers

How MySQL Commits and Recovers

Comments
6 min read
One day is not 24 hours: date arithmetic that breaks quietly, measured on SQLite and D1

One day is not 24 hours: date arithmetic that breaks quietly, measured on SQLite and D1

Comments
17 min read
Zookies Without TrueTime: How SpiceDB, OpenFGA and the Rest Order Their Writes

Zookies Without TrueTime: How SpiceDB, OpenFGA and the Rest Order Their Writes

Comments
13 min read
When Normalization Hurts: The 3NF vs BCNF Trade-off

When Normalization Hurts: The 3NF vs BCNF Trade-off

Comments
2 min read
Postgres to ClickHouse CDC Without Kafka: Attach a Polaris Catalog as a Database

Postgres to ClickHouse CDC Without Kafka: Attach a Polaris Catalog as a Database

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