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 a Retry Loop

How a Retry Loop

Comments
6 min read
Meta's "Combined Reaction Volume" SQL Question, Explained Simply

Meta's "Combined Reaction Volume" SQL Question, Explained Simply

Comments
3 min read
How We Built an In-Database AI Agent in Pure T-SQL (And Fixed Its Hidden Architectural Blindspots)

How We Built an In-Database AI Agent in Pure T-SQL (And Fixed Its Hidden Architectural Blindspots)

Comments
5 min read
Understanding SQL: A Practical Guide to Categories, Data Types, Joins, and Core Concepts

Understanding SQL: A Practical Guide to Categories, Data Types, Joins, and Core Concepts

1
Comments
4 min read
DB Explorer: A Lightweight Database Viewer I Built for Everyday Development Work

DB Explorer: A Lightweight Database Viewer I Built for Everyday Development Work

Comments
2 min read
How to Query Complex JSON and NDJSON Files with SQL (Without Writing Custom Parsers)

How to Query Complex JSON and NDJSON Files with SQL (Without Writing Custom Parsers)

Comments
3 min read
Day 13 - Data Replication - Single-Leader, Multi-Leader, Leaderless

Day 13 - Data Replication - Single-Leader, Multi-Leader, Leaderless

Comments
2 min read
A CSV Can Be Valid and Still Corrupt Your Import

A CSV Can Be Valid and Still Corrupt Your Import

Comments
2 min read
Hash Indexes: What they are and their limitations

Hash Indexes: What they are and their limitations

Comments
3 min read
That doesn’t mean you should use Redis for everything!

That doesn’t mean you should use Redis for everything!

Comments
1 min read
Migration Canary: Continuous Verification for Schemas

Migration Canary: Continuous Verification for Schemas

Comments 2
4 min read
Taped-Up DBs, But It Works

Taped-Up DBs, But It Works

1
Comments
4 min read
Reconciliation doesn't break in the arithmetic

Reconciliation doesn't break in the arithmetic

Comments
10 min read
What if your Python database code didn't care which database you used?

What if your Python database code didn't care which database you used?

Comments
2 min read
Best Open-Source Text-to-SQL Tools in 2025 (Ranked by Privacy & Performance)

Best Open-Source Text-to-SQL Tools in 2025 (Ranked by Privacy & Performance)

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