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
Understanding SQL joins.

Understanding SQL joins.

2
Comments 1
5 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
'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
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
Supabase realtime keeps mobile presence honest without polling your database dead

Supabase realtime keeps mobile presence honest without polling your database dead

Comments
6 min read
Where keyword search and vector search each fail

Where keyword search and vector search each fail

Comments
3 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
A Straightforward Guide for MVCC in Postgres

A Straightforward Guide for MVCC in Postgres

9
Comments
14 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
Aurora DSQL now supports foreign keys. What else?

Aurora DSQL now supports foreign keys. What else?

2
Comments
7 min read
Understanding the Replication Queue in ClickHouse

Understanding the Replication Queue in ClickHouse

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