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.
Inside SQLite’s Frontend: The Parser- Turning Tokens into Meaning

Inside SQLite’s Frontend: The Parser- Turning Tokens into Meaning

17
Comments 1
4 min read
Best Tools to Build MongoDB Aggregation Pipelines in 2026

Best Tools to Build MongoDB Aggregation Pipelines in 2026

7
Comments
4 min read
Why I don't trust AI with my query plans

Why I don't trust AI with my query plans

Comments
2 min read
From 8s to 47ms: Optimizing PostgreSQL for a Government Tender Search Platform

From 8s to 47ms: Optimizing PostgreSQL for a Government Tender Search Platform

Comments
9 min read
How PostgreSQL WAL Actually Works (And Why Everything Depends On It)

How PostgreSQL WAL Actually Works (And Why Everything Depends On It)

2
Comments
4 min read
No Redis. No Kafka. Just Postgres. I Built Chat.

No Redis. No Kafka. Just Postgres. I Built Chat.

31
Comments 2
13 min read
Why Unstructured Data is a Good Fit for Java

Why Unstructured Data is a Good Fit for Java

Comments
8 min read
I Built a Key-Value Database from Scratch — Here’s What I Learned

I Built a Key-Value Database from Scratch — Here’s What I Learned

7
Comments 2
4 min read
PostgreSql(Aggregative Functions)

PostgreSql(Aggregative Functions)

8
Comments
1 min read
Inside SQLite’s Frontend: How Your SQL Becomes Bytecode

Inside SQLite’s Frontend: How Your SQL Becomes Bytecode

18
Comments 1
4 min read
After 3 Years of Heavy Use, Amazon RDS Blue/Green Deployments Just Got Even Better (Sub-5-Second Switchovers!)

After 3 Years of Heavy Use, Amazon RDS Blue/Green Deployments Just Got Even Better (Sub-5-Second Switchovers!)

19
Comments
3 min read
How I Handle Mismatched Data Across Shopify, QuickBooks, and 3 Other Systems

How I Handle Mismatched Data Across Shopify, QuickBooks, and 3 Other Systems

Comments
7 min read
PostgreSql(Filtering & Sorting)

PostgreSql(Filtering & Sorting)

8
Comments
1 min read
PostgreSQL(Alternations)

PostgreSQL(Alternations)

8
Comments
1 min read
Keeping Database Schema in Sync With Production

Keeping Database Schema in Sync With Production

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