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.
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
A Second Check Is a Second Source of Truth

A Second Check Is a Second Source of Truth

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
Ontology on Snowflake: How to Make AI Actually Understand Your Data

Ontology on Snowflake: How to Make AI Actually Understand Your Data

2
Comments 1
2 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
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
Modeling a Creator SaaS in a Single DynamoDB Table

Modeling a Creator SaaS in a Single DynamoDB Table

Comments 1
4 min read
A 1000x Speedup From One Index — and Why It Sometimes Does Nothing

A 1000x Speedup From One Index — and Why It Sometimes Does Nothing

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