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.
Use your filesystem as your database

Use your filesystem as your database

Comments
12 min read
🚀 Zero-Downtime Database Schema Migration: How to Evolve Without Breaking Production

🚀 Zero-Downtime Database Schema Migration: How to Evolve Without Breaking Production

Comments
1 min read
The Outbox Pattern isn't really about messaging. It's about eliminating an impossible atomicity assumption

The Outbox Pattern isn't really about messaging. It's about eliminating an impossible atomicity assumption

Comments
1 min read
Why Increasing Database Connections Makes Queries Slower: Process Overhead, Little’s Law, and Pool Sizing Math

Why Increasing Database Connections Makes Queries Slower: Process Overhead, Little’s Law, and Pool Sizing Math

Comments
8 min read
Data Engineering Basics for Developers: Pipelines, Warehouses, and Streaming

Data Engineering Basics for Developers: Pipelines, Warehouses, and Streaming

Comments 1
9 min read
Vector database showroom. Part 4 Weaviate — The Crossover That Ships Fully Loaded

Vector database showroom. Part 4 Weaviate — The Crossover That Ships Fully Loaded

Comments
3 min read
Vector Databases for RAG: How to Choose One and Wire It In

Vector Databases for RAG: How to Choose One and Wire It In

Comments 1
12 min read
The Prisma migration that passes CI and fails in production

The Prisma migration that passes CI and fails in production

Comments
2 min read
Caching Strategies Demystified: Cache-Aside, Write-Through, and Write-Behind

Caching Strategies Demystified: Cache-Aside, Write-Through, and Write-Behind

Comments
3 min read
SQL and Database Fundamentals: From Tables to Transactions and Indexes

SQL and Database Fundamentals: From Tables to Transactions and Indexes

Comments
17 min read
Why UPDATE Is Secretly an INSERT: How Postgres MVCC, xmin/xmax, and Table Bloat Actually Work

Why UPDATE Is Secretly an INSERT: How Postgres MVCC, xmin/xmax, and Table Bloat Actually Work

Comments
7 min read
Our licenses page lists no licenses, and the subsystem that absence deleted is object storage

Our licenses page lists no licenses, and the subsystem that absence deleted is object storage

Comments
5 min read
Vector-Native Analytics: Embeddings as a First-Class Warehouse Column

Vector-Native Analytics: Embeddings as a First-Class Warehouse Column

Comments
2 min read
Your PostgreSQL Index Probably Doesn't Need Every Row

Your PostgreSQL Index Probably Doesn't Need Every Row

Comments 1
1 min read
Modelling Medical Device Sizes: Encoding Ureteral Access Sheaths in a Product Catalogue

Modelling Medical Device Sizes: Encoding Ureteral Access Sheaths in a Product Catalogue

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