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.
ClickHouse "Too many parts": what to check before you run OPTIMIZE FINAL

ClickHouse "Too many parts": what to check before you run OPTIMIZE FINAL

Comments
7 min read
Credit Notes and Refunds in a Multi-Currency Ledger: Which Exchange Rate Actually Applies?

Credit Notes and Refunds in a Multi-Currency Ledger: Which Exchange Rate Actually Applies?

Comments
5 min read
Bloom Filters, Explained Simply

Bloom Filters, Explained Simply

Comments
8 min read
DynamoDB: GSI, LSI, and related design ideas

DynamoDB: GSI, LSI, and related design ideas

Comments
7 min read
Optimizing an 18 TB Azure SQL Hyperscale Database — Part 5: Where AI Actually Helped

Optimizing an 18 TB Azure SQL Hyperscale Database — Part 5: Where AI Actually Helped

Comments
6 min read
Metabase Zero-Day: An Unauthenticated SQLi That Hit CVSS 10.0 and Stole Real Customer Data

Metabase Zero-Day: An Unauthenticated SQLi That Hit CVSS 10.0 and Stole Real Customer Data

Comments
3 min read
FOR UPDATE SKIP LOCKED Was Not Enough: A Stale Failure Write Race in an Inbox Processor

FOR UPDATE SKIP LOCKED Was Not Enough: A Stale Failure Write Race in an Inbox Processor

Comments 2
7 min read
Bypassing Java's Decorator Onion: A 3x Faster Alternative to JDBC Batching

Bypassing Java's Decorator Onion: A 3x Faster Alternative to JDBC Batching

Comments
3 min read
Vector databases: how semantic search scales

Vector databases: how semantic search scales

1
Comments
3 min read
API Rate Limiting: A Complete Guide for Developers

API Rate Limiting: A Complete Guide for Developers

1
Comments
14 min read
Postgresql Simplified

Postgresql Simplified

1
Comments
4 min read
Your ORM is hiding the line that caused the slow query

Your ORM is hiding the line that caused the slow query

Comments 2
5 min read
When Should You Actually Use MongoDB Instead of MySQL?

When Should You Actually Use MongoDB Instead of MySQL?

Comments
2 min read
SQLite FTS5 is faster than Whoosh. So why would you ever use a pure-Python search engine?

SQLite FTS5 is faster than Whoosh. So why would you ever use a pure-Python search engine?

Comments
3 min read
We Ditched MongoDB Atlas for AWS DocumentDB — Here's Exactly How We Did It

We Ditched MongoDB Atlas for AWS DocumentDB — Here's Exactly How We Did It

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