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.
Database Indexing and Query Optimization: A Practical Guide for Production

Database Indexing and Query Optimization: A Practical Guide for Production

Comments
4 min read
Your DDD Context Map Is Already in Your Foreign Keys

Your DDD Context Map Is Already in Your Foreign Keys

Comments
9 min read
Why ERD Tools Draw Your 1:1 Relationship as 1:N

Why ERD Tools Draw Your 1:1 Relationship as 1:N

Comments
6 min read
Exactly-once money movement: surviving retries and duplicate webhooks

Exactly-once money movement: surviving retries and duplicate webhooks

1
Comments
3 min read
I Tried Using an LLM as My Robot's Memory. The Latency Alone Was 3x My Control Loop.

I Tried Using an LLM as My Robot's Memory. The Latency Alone Was 3x My Control Loop.

2
Comments
4 min read
Day 31: Stash Keeps What Status Won't Show, and Private Is a Flag, Not a Subnet

Day 31: Stash Keeps What Status Won't Show, and Private Is a Flag, Not a Subnet

9
Comments 2
5 min read
Optimizing an 18 TB Azure SQL Hyperscale Database — Part 3: The Real Cost of Indexes

Optimizing an 18 TB Azure SQL Hyperscale Database — Part 3: The Real Cost of Indexes

Comments
5 min read
SQL RecycleBin: An Undo Button for SQL Server

SQL RecycleBin: An Undo Button for SQL Server

Comments 1
3 min read
Implementing UUID v7 by hand: time-sortable primary keys (and the same-millisecond trap)

Implementing UUID v7 by hand: time-sortable primary keys (and the same-millisecond trap)

1
Comments 1
4 min read
mtools does not parse MongoDB 4.4+ JSON logs. So I built mdbkit.

mtools does not parse MongoDB 4.4+ JSON logs. So I built mdbkit.

1
Comments
6 min read
Why Your ERD Export Turns Blurry - and How SVG Export Fixes It

Why Your ERD Export Turns Blurry - and How SVG Export Fixes It

Comments
6 min read
When Database Migrations Go Wrong: A Checklist for Safer Schema Changes

When Database Migrations Go Wrong: A Checklist for Safer Schema Changes

1
Comments 1
4 min read
MCPMark v2: InsForge on Sonnet 4.6

MCPMark v2: InsForge on Sonnet 4.6

2
Comments 2
3 min read
Read-only Postgres access can still take down your application

Read-only Postgres access can still take down your application

1
Comments
1 min read
How to Rename a Django Application Safely

How to Rename a Django Application Safely

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