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.
“Available” Is Not Booked: A Race-Safe Contract for AI Property Viewings

“Available” Is Not Booked: A Race-Safe Contract for AI Property Viewings

Comments
20 min read
Who Replies Faster? Measuring WhatsApp Response Times with Python

Who Replies Faster? Measuring WhatsApp Response Times with Python

Comments
4 min read
Batch Insert In JooqTemplate

Batch Insert In JooqTemplate

Comments
2 min read
SQL Pattern Matching Without the Pain: LIKE, Wildcards, and the Gotchas Nobody Warns You About

SQL Pattern Matching Without the Pain: LIKE, Wildcards, and the Gotchas Nobody Warns You About

Comments
4 min read
How to Learn SQL Joins (and Stop Mixing Up LEFT and INNER)

How to Learn SQL Joins (and Stop Mixing Up LEFT and INNER)

Comments
5 min read
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
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
Storage Engines Explained: B-Tree vs LSM Tree

Storage Engines Explained: B-Tree vs LSM Tree

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