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.
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
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
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
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
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
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
Your PostgreSQL Index Probably Doesn't Need Every Row

Your PostgreSQL Index Probably Doesn't Need Every Row

Comments 1
1 min read
SQLite FTS5 Writes: Bulk Build or Trigger Sync?

SQLite FTS5 Writes: Bulk Build or Trigger Sync?

Comments
2 min read
Offline-First Mobil Mimari: Isar, SQLite ve REST API ile Kusursuz Senkronizasyon

Offline-First Mobil Mimari: Isar, SQLite ve REST API ile Kusursuz Senkronizasyon

Comments
5 min read
MongoDB Indexing Strategies: ESR Rule, Explain Plans, and Performance Tuning

MongoDB Indexing Strategies: ESR Rule, Explain Plans, and Performance Tuning

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