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.
Inconsistency Resolution in Distributed Systems: Versioning

Inconsistency Resolution in Distributed Systems: Versioning

2
Comments 1
3 min read
The Complete Guide to PostgreSQL Lock Types for Schema Changes

The Complete Guide to PostgreSQL Lock Types for Schema Changes

1
Comments
5 min read
How to Monitor MongoDB Metrics with OpenTelemetry

How to Monitor MongoDB Metrics with OpenTelemetry

2
Comments
11 min read
Designing Efficient Queries with SQL Joins and Window Functions

Designing Efficient Queries with SQL Joins and Window Functions

2
Comments
7 min read
Mastering Joins and Window Functions in SQL for Data Engineers

Mastering Joins and Window Functions in SQL for Data Engineers

Comments
4 min read
SQL Joins and Window Functions- What I Learned Catching Up After Missing Class..

SQL Joins and Window Functions- What I Learned Catching Up After Missing Class..

Comments
4 min read
PostgreSQL JSONB: When to Use It and How to Query It Like a Pro

PostgreSQL JSONB: When to Use It and How to Query It Like a Pro

Comments
3 min read
Database Indexing Explained: How to Make Your Queries 1000x Faster

Database Indexing Explained: How to Make Your Queries 1000x Faster

1
Comments
3 min read
PostgreSQL Internals: Inside the Storage Engine

PostgreSQL Internals: Inside the Storage Engine

1
Comments
9 min read
Why Your TimescaleDB Compression Ratio Is Bad (And How to Fix It)

Why Your TimescaleDB Compression Ratio Is Bad (And How to Fix It)

Comments
4 min read
Data Pipeline Architecture: From Messy CSVs to Clean Database

Data Pipeline Architecture: From Messy CSVs to Clean Database

Comments
5 min read
How to use pg_dump for PostgreSQL backups — the complete 2026 tutorial

How to use pg_dump for PostgreSQL backups — the complete 2026 tutorial

Comments
9 min read
How We Built a 162K-Word Database on Cloudflare Workers + D1

How We Built a 162K-Word Database on Cloudflare Workers + D1

Comments
4 min read
SurrealDB: The "One-Size-Fits-All" Database for Lazy Developers (Part 1)

SurrealDB: The "One-Size-Fits-All" Database for Lazy Developers (Part 1)

1
Comments 1
2 min read
Room Database Complete Guide: Local Data Persistence in Compose

Room Database Complete Guide: Local Data Persistence in Compose

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