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.
B+Tree vs LSM Tree: Why Your Database's Data Structure Is Everything

B+Tree vs LSM Tree: Why Your Database's Data Structure Is Everything

1
Comments 2
11 min read
PostgreSQL Joins and Window Function

PostgreSQL Joins and Window Function

1
Comments
2 min read
Sleep Better at Night: Why Unit Testing is Your Secret Weapon for Graded Units 🛡️

Sleep Better at Night: Why Unit Testing is Your Secret Weapon for Graded Units 🛡️

1
Comments
2 min read
PostGIS Spatial Indexing: Why Your Queries Are Doing Sequential Scans

PostGIS Spatial Indexing: Why Your Queries Are Doing Sequential Scans

2
Comments
3 min read
From ERD to SQL: Implementing a Normalised Database Step-by-Step

From ERD to SQL: Implementing a Normalised Database Step-by-Step

Comments
3 min read
Distributed Systems - Lamport Clock vs Hybrid Logical Clocks

Distributed Systems - Lamport Clock vs Hybrid Logical Clocks

Comments 1
4 min read
SQL Joins & Window Functions

SQL Joins & Window Functions

Comments
3 min read
Pagination & Filtering: Managing Large Datasets Efficiently with FastAPI

Pagination & Filtering: Managing Large Datasets Efficiently with FastAPI

1
Comments
2 min read
UUID v4 vs v7: Which Should You Use in 2026? (With Generator)

UUID v4 vs v7: Which Should You Use in 2026? (With Generator)

Comments
2 min read
Distributed Systems - Quorum vs. Raft vs 2PC

Distributed Systems - Quorum vs. Raft vs 2PC

Comments
3 min read
SQL Query Optimization: 15 Techniques to Speed Up Your Database 2026

SQL Query Optimization: 15 Techniques to Speed Up Your Database 2026

Comments
4 min read
Membangun Alur Order Konveksi: WhatsApp Form Database (Anti Double-Order + Audit Trail)

Membangun Alur Order Konveksi: WhatsApp Form Database (Anti Double-Order + Audit Trail)

Comments
6 min read
Four Pagination Strategies for Enterprise Database Lists

Four Pagination Strategies for Enterprise Database Lists

1
Comments
6 min read
ORMs 101: The Ultimate Guide

ORMs 101: The Ultimate Guide

6
Comments
16 min read
From 30 Seconds to 3 Milliseconds: Replacing LIKE with FTS5 on 1.7M Patent Records

From 30 Seconds to 3 Milliseconds: Replacing LIKE with FTS5 on 1.7M Patent Records

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