Skip to content

DEV Community

Database

Posts on building, using, and learning about databases.

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

Apr 26

Time-Series, Document, or Relational? The 5-Question Test Every New Project Needs

#database #architecture #postgres #tutorial

8 min read

May 9

You need foreign keys and surrogate keys because you broke your relationships

#architecture #database #sql #document

9 min read

Apr 26

LSM Trees vs B-Trees: How Storage Engines Choose Their Data Structure

#architecture #database #systems #backend

3 min read

alexey.zh

Apr 26

Don’t Trust Backups You Haven’t Restored

#go #postgres #database

8 min read

Apr 26

Why PostgreSQL EXPLAIN ANALYZE Can Mislead You — and What to Use Instead

#postgres #database #postgressql #dataengineering

6 min read

May 9

Cloud Embeddings vs. Local Sovereign Memory: AI Agent Memory Layer Compared (2026)

#ai #vectordatabase #opensource #database

12 min read

Apr 30

The Metadata Structure of Modern Table Formats

#architecture #database #dataengineering #tutorial

7 min read

Michael

Apr 30

3 General Methods to Optimize Query Performance in GBase 8a

#gbase #database #数据库

3 min read

soy

Apr 25

DuckDB Single-Node Analytics, PostgreSQL Bloom Filters, SQLite Compression

#database #sql #sqlite

4 min read

Aviral Srivastava

Apr 30

Cache Stampede Prevention

#backend #database #performance #systemdesign

8 min read

Michael

Apr 30

GBase 8a Operations Cheat Sheet: Essential Commands for DBAs

#cli #database #sql #tutorial

2 min read

Prathamesh Thakre

Apr 25

Redis + Circuit Breaker: The Real Defense Against Database Meltdowns in High-Throughput Systems

#architecture #database #performance #systemdesign

10 min read

Apr 25

Change Data Capture: Streaming Database Changes to Downstream Systems

#architecture #database #systems #backend

3 min read

Eric Rodríguez

Apr 25

Day 66: Why Point-in-Time Recovery is the first button you should click in DynamoDB

#aws #database #serverless #devops

1 min read

Erich

Apr 29

Cache policy implementations vs the original papers

#database

6 min read

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