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.
7 Must-Know SQL Query Optimization Techniques for Faster Databases in 2026

7 Must-Know SQL Query Optimization Techniques for Faster Databases in 2026

Comments
4 min read
Where Does Your Data Live? Decoding the Modern Data Ecosystem

Where Does Your Data Live? Decoding the Modern Data Ecosystem

2
Comments 1
6 min read
Best Stripe Sigma Alternative for PostgreSQL Users

Best Stripe Sigma Alternative for PostgreSQL Users

Comments
10 min read
Schema Diff: Catch Drift Between Staging and Production

Schema Diff: Catch Drift Between Staging and Production

Comments
4 min read
Multi-Tenant SaaS Architecture: What Nobody Tells You Before You Build

Multi-Tenant SaaS Architecture: What Nobody Tells You Before You Build

Comments
5 min read
SQL Assertions, ANSI join, and ORA-08697

SQL Assertions, ANSI join, and ORA-08697

Comments
3 min read
Consistency boundaries in SQL databases vs. MongoDB

Consistency boundaries in SQL databases vs. MongoDB

Comments
7 min read
Database Migration Strategies for Zero-Downtime

Database Migration Strategies for Zero-Downtime

Comments
9 min read
Event Sourcing 实战:让业务数据自己说话

Event Sourcing 实战:让业务数据自己说话

Comments
2 min read
How We Made Our Supabase RLS Migrations Idempotent (And Why You Should Too)

How We Made Our Supabase RLS Migrations Idempotent (And Why You Should Too)

Comments
3 min read
PostgreSQL JSONB: A Complete Guide to Storing and Querying JSON Data

PostgreSQL JSONB: A Complete Guide to Storing and Querying JSON Data

Comments
1 min read
Database Indexing Explained: What's Actually Happening Under the Hood

Database Indexing Explained: What's Actually Happening Under the Hood

1
Comments
4 min read
COBOL Database Migration Tool - VSAM, DB2, CICS, IMS to 5 Modern SQL Databases With DAL Code in 6 Languages

COBOL Database Migration Tool - VSAM, DB2, CICS, IMS to 5 Modern SQL Databases With DAL Code in 6 Languages

Comments
3 min read
Making AskDB Data Fresher: Adding Auto-Sync

Making AskDB Data Fresher: Adding Auto-Sync

Comments
2 min read
Building a Safe Money Transfer System in PostgreSQL — Transactions, Rollbacks, and What Happens When Things Break

Building a Safe Money Transfer System in PostgreSQL — Transactions, Rollbacks, and What Happens When Things Break

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