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.
SQL RecycleBin: An Undo Button for SQL Server

SQL RecycleBin: An Undo Button for SQL Server

Comments 1
3 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
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
From Tables to Insights: A Beginner's Journey into SQL

From Tables to Insights: A Beginner's Journey into SQL

Comments
2 min read
Day 91 of #100DaysOfClickHouse - Partition Pruning in ClickHouse®

Day 91 of #100DaysOfClickHouse - Partition Pruning in ClickHouse®

Comments
4 min read
We nearly published a 2x regression that didn't exist

We nearly published a 2x regression that didn't exist

1
Comments
4 min read
What Spring Data Tests Can Miss: Testing Beyond Hibernate’s Persistence Context (Chapter 7)

What Spring Data Tests Can Miss: Testing Beyond Hibernate’s Persistence Context (Chapter 7)

Comments
11 min read
Row-level security in Symfony: the role that ran your migrations bypasses every policy you wrote

Postgres table owners bypass RLS silently

Row-level security in Symfony: the role that ran your migrations bypasses every policy you wrote

5
Comments 11
7 min read
Distributed Metadata Migration

Distributed Metadata Migration

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