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.
How Express Actually Talks to a Database: From HTTP Request to SQL Query

How Express Actually Talks to a Database: From HTTP Request to SQL Query

Comments
12 min read
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
Backups You Have Never Restored Are Just Hope

Backups You Have Never Restored Are Just Hope

Comments
2 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
SQL Date Functions: How to Group by Month Without Losing One

SQL Date Functions: How to Group by Month Without Losing One

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

Cohort Retention Analysis in SQL, Step by Step

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
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
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
Why Your SQL Server Database Is Slow (and How to Fix It)

Why Your SQL Server Database Is Slow (and How to Fix It)

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