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.
The Text-to-SQL Accuracy Cliff: Why Deterministic Compilers Beat LLM Guessing

The Text-to-SQL Accuracy Cliff: Why Deterministic Compilers Beat LLM Guessing

Comments
2 min read
You Cannot Tell Which of Your ERD Files Are Under Version Control

You Cannot Tell Which of Your ERD Files Are Under Version Control

Comments
5 min read
The Ledger Is the Loop: How One Record Carries a House Through Loan Origination, Deconstruction, and Construction

The Ledger Is the Loop: How One Record Carries a House Through Loan Origination, Deconstruction, and Construction

Comments
6 min read
Why Schemity Has No Zoom: Fuzzy Search and a Minimap Instead

Why Schemity Has No Zoom: Fuzzy Search and a Minimap Instead

Comments
7 min read
I benchmarked Dragonfly vs Redis vs Valkey. First, let me show you how I kept it honest.

I benchmarked Dragonfly vs Redis vs Valkey. First, let me show you how I kept it honest.

1
Comments
6 min read
How We Scaled Firewall Logs with ClickHouse at MalCare

How We Scaled Firewall Logs with ClickHouse at MalCare

Comments
5 min read
PostgreSQL INCLUDE indexes: what problem are they trying to solve?

Clarifies pre-v11 covering index capabilities

PostgreSQL INCLUDE indexes: what problem are they trying to solve?

12
Picked as gem Comments 7
10 min read
I Built a Crash-Safe Database From Scratch Because I Wasn't Allowed to pip install Anything

I Built a Crash-Safe Database From Scratch Because I Wasn't Allowed to pip install Anything

5
Comments 3
4 min read
How Should a Low-Code Platform Design Its Data Model?

How Should a Low-Code Platform Design Its Data Model?

Comments 1
9 min read
Xero API Integration Guide (2026): OAuth, Tenants, and Your First Query

Xero API Integration Guide (2026): OAuth, Tenants, and Your First Query

Comments
14 min read
SQL vs. NoSQL — stop asking the wrong question

SQL vs. NoSQL — stop asking the wrong question

2
Comments
4 min read
Building low-latency semantic memory for coding agents with LanceDB

Building low-latency semantic memory for coding agents with LanceDB

Comments 1
9 min read
How I Segmented Millions of Users in Just a Few Milliseconds

How I Segmented Millions of Users in Just a Few Milliseconds

Comments
4 min read
I Built a Database in Rust With Zero Dependencies (and What the Standard Library Quietly Gave Me)

I Built a Database in Rust With Zero Dependencies (and What the Standard Library Quietly Gave Me)

6
Comments 2
7 min read
Streaks Without Race Conditions: What Actually Runs Behind Codervai CP

Streaks Without Race Conditions: What Actually Runs Behind Codervai CP

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