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.
Activating Your Data Layer for Production-Ready AI

Activating Your Data Layer for Production-Ready AI

8
Picked as gem Comments
5 min read
DBench86 — A Style Exercise in PHP 8.6

DBench86 — A Style Exercise in PHP 8.6

2
Comments
20 min read
Postgres Let Two Rows Through a Unique Index: The glibc Collation Trap After an OS Upgrade

Postgres Let Two Rows Through a Unique Index: The glibc Collation Trap After an OS Upgrade

Comments
8 min read
MongoDB Internals, Part 1

MongoDB Internals, Part 1

Comments
10 min read
I built a zero-dependency CLI to snapshot the remote job market into CSV/JSON/SQLite

I built a zero-dependency CLI to snapshot the remote job market into CSV/JSON/SQLite

Comments
3 min read
I Asked 4 AI Coding Tools to Design a Multi-Tenant Schema. They All Made the Same Fatal Mistake.

I Asked 4 AI Coding Tools to Design a Multi-Tenant Schema. They All Made the Same Fatal Mistake.

5
Comments 1
4 min read
How long does a Patroni failover take? We measured it

How long does a Patroni failover take? We measured it

Comments
4 min read
My Experience Using SQL: DDL, DML, WHERE and CASE WHEN

My Experience Using SQL: DDL, DML, WHERE and CASE WHEN

Comments
2 min read
Database Transactions & Consistency

Database Transactions & Consistency

Comments
9 min read
Best Collaborative Data Modeling Tools: SQLDBM Team Features & Alternatives Compared

Best Collaborative Data Modeling Tools: SQLDBM Team Features & Alternatives Compared

Comments
10 min read
Design semantic views around business questions, not agents

Design semantic views around business questions, not agents

Comments 1
6 min read
Advanced System Architecture: Designing Multi-Region Read Replicas and Global Data Consistency

Advanced System Architecture: Designing Multi-Region Read Replicas and Global Data Consistency

Comments
3 min read
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint

The ALTER TABLE statement conflicted with the FOREIGN KEY constraint

Comments
4 min read
MSSQL EXTENDED EVENTS Stop Guessing and Start Targeting

MSSQL EXTENDED EVENTS Stop Guessing and Start Targeting

1
Comments
5 min read
The Empty SMALLINT Column That Led Me to Nine More Missing Types

The Empty SMALLINT Column That Led Me to Nine More Missing Types

Comments
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.