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.
Data Substrate Versus Vector Db Rag

Data Substrate Versus Vector Db Rag

Comments
3 min read
pgvector vs Pinecone vs Qdrant: Benchmarked for RAG in 2026

pgvector vs Pinecone vs Qdrant: Benchmarked for RAG in 2026

Comments
12 min read
UUIDv7 in PostgreSQL 18: uuidv7() vs UUIDv4 vs bigint Primary Keys, Benchmarked

UUIDv7 in PostgreSQL 18: uuidv7() vs UUIDv4 vs bigint Primary Keys, Benchmarked

Comments
11 min read
Vector Database Memory Sizing and Cost Math: How Much RAM Do 1 Million Vectors Need?

Vector Database Memory Sizing and Cost Math: How Much RAM Do 1 Million Vectors Need?

Comments
11 min read
Your Database Is Small. That Doesn’t Mean Your Queries Are Fast

Your Database Is Small. That Doesn’t Mean Your Queries Are Fast

1
Comments
3 min read
Database Connection Pooling: Why Opening a New Database Connection Every Time Is a Bad Idea

Database Connection Pooling: Why Opening a New Database Connection Every Time Is a Bad Idea

Comments
3 min read
Hibernate vs MyBatis: How Much ORM Magic Do You Actually Want?

Hibernate vs MyBatis: How Much ORM Magic Do You Actually Want?

Comments
7 min read
Postgres is Crying: A Zero-Downtime, 15TB Migration to BigQuery with Python & Arrow

Postgres is Crying: A Zero-Downtime, 15TB Migration to BigQuery with Python & Arrow

Comments 1
9 min read
Микросервисы и «зоопарк» баз данных: почему маленьким командам это не всегда нужно

Микросервисы и «зоопарк» баз данных: почему маленьким командам это не всегда нужно

Comments
1 min read
Migrating a Large Table Without Locking Production

Migrating a Large Table Without Locking Production

4
Comments 1
15 min read
Borramos la tabla de producción a propósito: una prueba de desastre real con PostgreSQL, Neon y Render

Borramos la tabla de producción a propósito: una prueba de desastre real con PostgreSQL, Neon y Render

Comments
5 min read
1,250,964 audit rows recorded that we had decided nothing, and 51,884 recorded a decision

1,250,964 audit rows recorded that we had decided nothing, and 51,884 recorded a decision

Comments
5 min read
Idempotency Beyond the HTTP Header

Idempotency Beyond the HTTP Header

Comments 2
3 min read
Data Modelling, Relationships & Joins in PowerBI

Data Modelling, Relationships & Joins in PowerBI

Comments
10 min read
We dropped 8 indexes and added 3 without a single production statistic

We dropped 8 indexes and added 3 without a single production statistic

Comments
5 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.