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.
Migrating a ScyllaDB Cluster the “Brain Transplant” Way

Migrating a ScyllaDB Cluster the “Brain Transplant” Way

Comments
6 min read
When should you stop using Google Sheets as your backend?

When should you stop using Google Sheets as your backend?

2
Comments 2
3 min read
How to Troubleshoot Performance Degradation in GBase 8a

How to Troubleshoot Performance Degradation in GBase 8a

2
Comments
3 min read
1.3.2 How RLS Rewrites Queries (Mechanism)

1.3.2 How RLS Rewrites Queries (Mechanism)

Comments 1
11 min read
Why Your AI Model Is Only As Good As the Data You Test It On

Why Your AI Model Is Only As Good As the Data You Test It On

Comments
4 min read
How I auto-enrich a brand database with AI on cache miss (Lovable + Claude API)

How I auto-enrich a brand database with AI on cache miss (Lovable + Claude API)

Comments
1 min read
Understanding SQL query structure

Understanding SQL query structure

Comments
1 min read
DuckDB, Postgres, and Parquet: when one SQL query becomes a workflow

DuckDB, Postgres, and Parquet: when one SQL query becomes a workflow

Comments
4 min read
Avoiding range overlaps in PostgreSQL with EXCLUDE constraint, better than serializable or assertions

Avoiding range overlaps in PostgreSQL with EXCLUDE constraint, better than serializable or assertions

Comments 1
12 min read
Building a Vector Search Engine from Scratch in Python (Flat, IVF, HNSW)

Building a Vector Search Engine from Scratch in Python (Flat, IVF, HNSW)

Comments
6 min read
Zero-Downtime Database Migrations in Production (2026)

Zero-Downtime Database Migrations in Production (2026)

1
Comments 2
2 min read
ClickHouse JOINs Aren't Slow Anymore (You're Reading 2020's Docs)

ClickHouse JOINs Aren't Slow Anymore (You're Reading 2020's Docs)

Comments
6 min read
Back to Code | Ep 04: Forgetting the Machine — Big O and the Performance Tax

Back to Code | Ep 04: Forgetting the Machine — Big O and the Performance Tax

Comments
2 min read
SQLite Corruption in Sandboxes, PostgreSQL Caching, & Rust DB Proxy Architecture

SQLite Corruption in Sandboxes, PostgreSQL Caching, & Rust DB Proxy Architecture

Comments
3 min read
Why I Built a Standalone 10M-Row BI Agent in Next.js & DuckDB

Why I Built a Standalone 10M-Row BI Agent in Next.js & DuckDB

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