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.
Read-Only Postgres Role for AI Agents: 7 Gaps to Close

Read-Only Postgres Role for AI Agents: 7 Gaps to Close

2
Comments 2
10 min read
AWS FinOps Field Notes (2026-11-01): Auditing RDS Extended Support Charges with Python

AWS FinOps Field Notes (2026-11-01): Auditing RDS Extended Support Charges with Python

Comments
2 min read
Reading Complex XML in SQL Server — Shredding a Thousand Attributes Generically Instead of Looping for Hours

Reading Complex XML in SQL Server — Shredding a Thousand Attributes Generically Instead of Looping for Hours

Comments
41 min read
Why Your Redis Values Look Like Garbage in Every GUI (and How to Fix It)

Why Your Redis Values Look Like Garbage in Every GUI (and How to Fix It)

Comments
7 min read
From 1 Minute 56 Seconds to 3 Seconds: Optimizing Database Inserts with Batch Processing

From 1 Minute 56 Seconds to 3 Seconds: Optimizing Database Inserts with Batch Processing

Comments
2 min read
New Package Release

New Package Release

Comments
1 min read
How to Fix SQL Server Deadlocks: Causes, Detection and Real Fixes

How to Fix SQL Server Deadlocks: Causes, Detection and Real Fixes

Comments
4 min read
A support desk on one small server: sizing, backups and the boring parts

A support desk on one small server: sizing, backups and the boring parts

Comments
3 min read
One Customer Request Across Website, CRM and AI Adviser

One Customer Request Across Website, CRM and AI Adviser

Comments
3 min read
Late facts shouldn't overwrite newer ones: handling out-of-order state in a temporal knowledge graph

Late facts shouldn't overwrite newer ones: handling out-of-order state in a temporal knowledge graph

Comments
3 min read
Catching schema drift before it breaks production

Catching schema drift before it breaks production

Comments
6 min read
Stop using ddl-auto=update in production

Stop using ddl-auto=update in production

Comments
8 min read
Migrax vs Flyway: generated vs hand-written migrations

Migrax vs Flyway: generated vs hand-written migrations

Comments
5 min read
Generated SQL migrations for Python, TypeScript and Go projects

Generated SQL migrations for Python, TypeScript and Go projects

Comments
9 min read
I made ER diagrams with the fewest line crossings, and proved it

I made ER diagrams with the fewest line crossings, and proved it

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