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.
LioranDB V2 Is in Pre-Alpha. Please Try to Break It.

LioranDB V2 Is in Pre-Alpha. Please Try to Break It.

1
Comments
3 min read
CDC without Kafka: keeping Postgres, OpenSearch, and Redis in sync with one binary

CDC without Kafka: keeping Postgres, OpenSearch, and Redis in sync with one binary

Comments
8 min read
Why Your SQL Server Database Is Slow (and How to Fix It)

Why Your SQL Server Database Is Slow (and How to Fix It)

1
Comments 1
4 min read
Don't give your agent the production database

Don't give your agent the production database

Comments
4 min read
Redis Pipeline Contention Under Write Amplification: Batching Strategy, HOL Blocking, and the Flush Timing Problem

Redis Pipeline Contention Under Write Amplification: Batching Strategy, HOL Blocking, and the Flush Timing Problem

Comments
5 min read
New Redash fork with AI capabilities!

New Redash fork with AI capabilities!

1
Comments
1 min read
Open Source Isn't a Business Model Choice Anymore. It's the Only Option.

Open Source Isn't a Business Model Choice Anymore. It's the Only Option.

Comments
4 min read
How to Set Up DuckDB (Run SQL on a CSV With No Import Step)

How to Set Up DuckDB (Run SQL on a CSV With No Import Step)

Comments
10 min read
Database Reliability: The SRE Approach to Keeping Data Safe

Database Reliability: The SRE Approach to Keeping Data Safe

Comments
3 min read
5 Things AI Cannot Do at Firebase

5 Things AI Cannot Do at Firebase

6
Comments 1
6 min read
Every Query Is Fast Until the Table Grows Up

Every Query Is Fast Until the Table Grows Up

Comments
2 min read
You probably don't need a dedicated vector database (Use pgvector instead)

You probably don't need a dedicated vector database (Use pgvector instead)

1
Comments 5
6 min read
Subqueries vs CTEs: Query Optimizer Internals & Memory Spooling Explained

Subqueries vs CTEs: Query Optimizer Internals & Memory Spooling Explained

Comments
2 min read
How I Replaced Production Data Dumps With AI-Generated Seed Data

How I Replaced Production Data Dumps With AI-Generated Seed Data

1
Comments
6 min read
How to let AI agents manage your database schema (with MCP)

How to let AI agents manage your database schema (with MCP)

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