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.
Manticore Search 28.6.6: UUID document IDs, ordered GROUP_CONCAT(), and 16 fixes

Manticore Search 28.6.6: UUID document IDs, ordered GROUP_CONCAT(), and 16 fixes

Comments
3 min read
🚀 Bill2CRM Dev Diary: The Danger of the "Triple-Database" Trap

🚀 Bill2CRM Dev Diary: The Danger of the "Triple-Database" Trap

Comments
2 min read
An AI Agent Deleted a Production Database in 9 Seconds — the Real Bug Was the Token Scope

An AI Agent Deleted a Production Database in 9 Seconds — the Real Bug Was the Token Scope

Comments 1
10 min read
Entity Framework N+1 in a Report Loop: The Pre-Fetch Fix Was Going to Crash Large Tenants

Entity Framework N+1 in a Report Loop: The Pre-Fetch Fix Was Going to Crash Large Tenants

1
Comments 2
5 min read
Postgres Array Column vs Junction Table: What Each One Does to Your ERD

Postgres Array Column vs Junction Table: What Each One Does to Your ERD

Comments 1
10 min read
Why GitHub Cannot Paginate Through Millions of Repositories - Deep Pagination Explained

Why GitHub Cannot Paginate Through Millions of Repositories - Deep Pagination Explained

Comments
5 min read
A Second Check Is a Second Source of Truth

A Second Check Is a Second Source of Truth

Comments
4 min read
Two IDs, One Row: Keeping Public UUIDs and Internal Keys From Leaking Into Each Other

Two IDs, One Row: Keeping Public UUIDs and Internal Keys From Leaking Into Each Other

Comments 1
3 min read
The Blueprint for Robust ETL Development: 10 Enterprise Best Practices

The Blueprint for Robust ETL Development: 10 Enterprise Best Practices

Comments
5 min read
Every pull request gets its own app and its own Postgres branch, for $0

Every pull request gets its own app and its own Postgres branch, for $0

Comments
7 min read
Pg-Java v1.0 Debuts as New PostgreSQL Driver — Plus SQLite Fix & DuckCon #7

Pg-Java v1.0 Debuts as New PostgreSQL Driver — Plus SQLite Fix & DuckCon #7

Comments
4 min read
How to write a cohort retention query in SQL (that actually runs)

How to write a cohort retention query in SQL (that actually runs)

Comments
3 min read
Zero-Disk Streaming Database Backup: 8 GB Dump Processed with Only ~119 MB RAM!

Zero-Disk Streaming Database Backup: 8 GB Dump Processed with Only ~119 MB RAM!

1
Comments 2
1 min read
Installing Couchbase Database on Ubuntu 22.04

Installing Couchbase Database on Ubuntu 22.04

6
Comments
3 min read
How durability works in a storage engine we wrote ourselves

How durability works in a storage engine we wrote ourselves

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