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.
PostgreSQL serial vs identity: Which to Use, and How to Convert Old serial Columns

PostgreSQL serial vs identity: Which to Use, and How to Convert Old serial Columns

Comments
9 min read
Postgres Indexes Under Write Load: Every Index Is a Tax on Every Write

Postgres Indexes Under Write Load: Every Index Is a Tax on Every Write

Comments
4 min read
Data Modelling, Relationships And Joins In Power BI

Data Modelling, Relationships And Joins In Power BI

Comments
8 min read
WhatIf Graph: Using FalkorDB to Understand the Impact of Decisions Before They Happen

WhatIf Graph: Using FalkorDB to Understand the Impact of Decisions Before They Happen

1
Comments
6 min read
28 migration files, two of which cancel each other out, and not one of them written by hand

28 migration files, two of which cancel each other out, and not one of them written by hand

1
Comments
6 min read
Self-Hosting Supabase for Health Data under GDPR: Lessons From Running a Telemedicine Platform

Self-Hosting Supabase for Health Data under GDPR: Lessons From Running a Telemedicine Platform

1
Comments
7 min read
Drizzle vs Prisma in 2026: Benchmarks, Drizzle 1.0, Prisma 8 and Which to Choose

Drizzle vs Prisma in 2026: Benchmarks, Drizzle 1.0, Prisma 8 and Which to Choose

Comments
14 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
pgvector vs Pinecone vs Qdrant: Benchmarked for RAG in 2026

pgvector vs Pinecone vs Qdrant: Benchmarked for RAG in 2026

Comments
12 min read
Data Substrate Versus Vector Db Rag

Data Substrate Versus Vector Db Rag

Comments
3 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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.