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.
UUID in Manticore: a single ID for the primary database and Manticore

UUID in Manticore: a single ID for the primary database and Manticore

Comments
6 min read
SQL vs NoSQL for Node.js Applications: A Practical Guide

SQL vs NoSQL for Node.js Applications: A Practical Guide

5
Comments
7 min read
'Column Must Appear in the GROUP BY Clause' — Why SQL Won't Let You Do That

'Column Must Appear in the GROUP BY Clause' — Why SQL Won't Let You Do That

Comments
3 min read
Building a Visitor Data Platform with Digital Membership Cards

Building a Visitor Data Platform with Digital Membership Cards

Comments
2 min read
Apache Polaris 1.7.0 and the Quiet Work of Making a Catalog Trustworthy

Apache Polaris 1.7.0 and the Quiet Work of Making a Catalog Trustworthy

Comments
25 min read
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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.