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.
Your Microservices Aren’t Scalable. Your Database Is Just Crying.

Your Microservices Aren’t Scalable. Your Database Is Just Crying.

86
Comments 13
4 min read
SQL Restaurant Kitchen ---Indexes and Partitions

SQL Restaurant Kitchen ---Indexes and Partitions

9
Comments 1
9 min read
The Tree Module: Where Pages Turn Into Rows in SQLite

The Tree Module: Where Pages Turn Into Rows in SQLite

25
Comments
4 min read
Pager Lifecycle Functions: Pinning Pages, Running Transactions, and Making Them Stick in SQLite

Pager Lifecycle Functions: Pinning Pages, Running Transactions, and Making Them Stick in SQLite

24
Comments 2
4 min read
SQL Dates Finally Made Sense: NOW, AGE, EXTRACT, and Why Time Is Weird

SQL Dates Finally Made Sense: NOW, AGE, EXTRACT, and Why Time Is Weird

31
Comments
3 min read
Querying & Filtering in Oracle Databases: What Actually Clicked for Me As a Beginner

Querying & Filtering in Oracle Databases: What Actually Clicked for Me As a Beginner

30
Comments 1
4 min read
Columns & Data Types in Oracle: What Actually Stuck on Day 2 (As a Beginner)

Columns & Data Types in Oracle: What Actually Stuck on Day 2 (As a Beginner)

29
Comments 2
3 min read
Journals Beyond the Basics in SQLite

Journals Beyond the Basics in SQLite

24
Comments
4 min read
Scaling to 200+ Cities by Deleting 90% of My Database

Scaling to 200+ Cities by Deleting 90% of My Database

Comments 2
6 min read
Migração de dados entre serviços: estratégias, riscos e trade-offs

Migração de dados entre serviços: estratégias, riscos e trade-offs

7
Comments 1
5 min read
Go Concurrency with Database Transactions

Go Concurrency with Database Transactions

2
Comments
3 min read
Page Cache and Pager State: Where Concurrency Becomes Concrete

Page Cache and Pager State: Where Concurrency Becomes Concrete

18
Comments
4 min read
Lock Management Inside a Process: Why Native Locks Alone Are Not Enough

Lock Management Inside a Process: Why Native Locks Alone Are Not Enough

22
Comments 1
4 min read
The Pager: Where SQLite Transactions Touch Disk Reality

The Pager: Where SQLite Transactions Touch Disk Reality

24
Comments
3 min read
How SQLite Turns Hardware Chaos into Correctness

How SQLite Turns Hardware Chaos into Correctness

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