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.
I Benchmarked My CSV Engine Against DuckDB on Its Own Dataset. It Found Two Bugs in Mine.

I Benchmarked My CSV Engine Against DuckDB on Its Own Dataset. It Found Two Bugs in Mine.

1
Comments 2
6 min read
Poisoning the Well: Defending Agentic Vector Databases from Diagnostic Key Leaks

Poisoning the Well: Defending Agentic Vector Databases from Diagnostic Key Leaks

Comments
4 min read
Deploying MySQL on RDS and Joining Tables Like It's Production

Deploying MySQL on RDS and Joining Tables Like It's Production

Comments
3 min read
SnapShot 📸🔫

SnapShot 📸🔫

Comments
3 min read
Prompting AI for Complex Multi-Table SQL: A Practical Guide

Prompting AI for Complex Multi-Table SQL: A Practical Guide

1
Comments
5 min read
The Hidden Cost of Event-Driven Systems: When Read Models Fall Behind

The Hidden Cost of Event-Driven Systems: When Read Models Fall Behind

Comments 1
2 min read
Debugging a Redis Connection That Wasn't Actually Broken

Debugging a Redis Connection That Wasn't Actually Broken

6
Comments
4 min read
ClickHouse 26.6 latest update

ClickHouse 26.6 latest update

1
Comments
4 min read
Zero-Downtime Database Migrations in Laravel

Zero-Downtime Database Migrations in Laravel

1
Comments
3 min read
Engineering a High-Performance LSM-Tree Storage Engine: MemTables, SSTables, and Compaction

Engineering a High-Performance LSM-Tree Storage Engine: MemTables, SSTables, and Compaction

1
Comments
5 min read
The Missing Check After Your Database Query

The Missing Check After Your Database Query

Comments
6 min read
Star Schema vs Snowflake Schema: Which to Use and When

Star Schema vs Snowflake Schema: Which to Use and When

Comments
4 min read
Fine-Tuning Local Database Engines: How to Optimize my.ini for High-Performance MySQL Stacks

Fine-Tuning Local Database Engines: How to Optimize my.ini for High-Performance MySQL Stacks

Comments
2 min read
Your database scales to zero. Your retry loop doesn't know that.

Your database scales to zero. Your retry loop doesn't know that.

Comments 1
4 min read
READ COMMITTED isn't as safe as you think

READ COMMITTED isn't as safe as you think

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