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.
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
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
Archiving Analytics with D1 and Workers

Archiving Analytics with D1 and Workers

Comments
4 min read
Cleaning Up Unused Indexes Without Breaking Performance

Cleaning Up Unused Indexes Without Breaking Performance

4
Comments 4
8 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
LioranDB V2 Is in Pre-Alpha. Please Try to Break It.

LioranDB V2 Is in Pre-Alpha. Please Try to Break It.

1
Comments
3 min read
Five results: I spent time proving splines don't help trajectory databases

Five results: I spent time proving splines don't help trajectory databases

Comments
9 min read
Database Isolation: Why Two Committed Transfers Can Create Money

Database Isolation: Why Two Committed Transfers Can Create Money

6
Comments 2
8 min read
Don't give your agent the production database

Don't give your agent the production database

Comments
4 min read
Redis Pipeline Contention Under Write Amplification: Batching Strategy, HOL Blocking, and the Flush Timing Problem

Redis Pipeline Contention Under Write Amplification: Batching Strategy, HOL Blocking, and the Flush Timing Problem

Comments
5 min read
New Redash fork with AI capabilities!

New Redash fork with AI capabilities!

1
Comments
1 min read
Open Source Isn't a Business Model Choice Anymore. It's the Only Option.

Open Source Isn't a Business Model Choice Anymore. It's the Only Option.

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