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 Migration Best Practices: How to Achieve Zero Downtime

Database Migration Best Practices: How to Achieve Zero Downtime

Comments
4 min read
SQL: WHERE, ORDER BY, and LIMIT — Why Your Query May Return the Wrong Employees

SQL: WHERE, ORDER BY, and LIMIT — Why Your Query May Return the Wrong Employees

Comments
3 min read
Graph RAG on the database you already run: meet Drivine

Graph RAG on the database you already run: meet Drivine

1
Comments
3 min read
I fact-checked the free tiers of 20 AI tools. Most listings were wrong.

I fact-checked the free tiers of 20 AI tools. Most listings were wrong.

1
Comments
3 min read
Foreign Key Cascade Deletes: Un-Indexed FKs, Slow Cascades, and Lock Contention in PostgreSQL

Foreign Key Cascade Deletes: Un-Indexed FKs, Slow Cascades, and Lock Contention in PostgreSQL

1
Comments
6 min read
MySQL to PostgreSQL Schema Conversion: What Each Column Type Should Become, and What Silently Changes

MySQL to PostgreSQL Schema Conversion: What Each Column Type Should Become, and What Silently Changes

1
Comments
12 min read
UUID v4 vs v7: Choosing Identifiers for Modern Applications

UUID v4 vs v7: Choosing Identifiers for Modern Applications

Comments 2
4 min read
TIL: GBase Database Installation — What the -i Flag Actually Skips

TIL: GBase Database Installation — What the -i Flag Actually Skips

2
Comments
4 min read
GBase Database Single-Node Cluster: 4 Common Initialization Traps and How to Fix Them

GBase Database Single-Node Cluster: 4 Common Initialization Traps and How to Fix Them

2
Comments
4 min read
Why VoiceStudio's Semantic Memory Fails Under Load—and How We Fixed It

Why VoiceStudio's Semantic Memory Fails Under Load—and How We Fixed It

Comments
4 min read
Why Your Inventory Tracking System Needs To Be Reliable - Using Barcodes / RFID

Why Your Inventory Tracking System Needs To Be Reliable - Using Barcodes / RFID

Comments
4 min read
SARGable Queries in SQL Server: Why Functions in WHERE Slow You Down

SARGable Queries in SQL Server: Why Functions in WHERE Slow You Down

Comments
3 min read
I rebuilt warden's console: 16 tabs down to 6 (and found my own DB world-readable)

I rebuilt warden's console: 16 tabs down to 6 (and found my own DB world-readable)

Comments
3 min read
What I Learned About Improving Database Search Performance

What I Learned About Improving Database Search Performance

Comments
4 min read
Running a job board on Cloudflare Workers' free plan: what broke and how I fixed it

Running a job board on Cloudflare Workers' free plan: what broke and how I fixed it

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