Forem

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
Cover image for 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
I Built a Schema Migration Tool for Cassandra Because Nothing Else Worked

I Built a Schema Migration Tool for Cassandra Because Nothing Else Worked

1
Comments
5 min read
Why I don't trust AI with my query plans
Cover image for Why I don't trust AI with my query plans

Why I don't trust AI with my query plans

Comments
2 min read
Best Tools to Build MongoDB Aggregation Pipelines in 2026
Cover image for Best Tools to Build MongoDB Aggregation Pipelines in 2026

Best Tools to Build MongoDB Aggregation Pipelines in 2026

7
Comments
4 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)
Cover image for 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.
Cover image for No Redis. No Kafka. Just Postgres. I Built Chat.

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

32
Comments 2
13 min read
Qdrant Hybrid Search Combined with SQL Query Results
Cover image for Qdrant Hybrid Search Combined with SQL Query Results

Qdrant Hybrid Search Combined with SQL Query Results

1
Comments 1
6 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
Cover image for 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)
Cover image for PostgreSql(Aggregative Functions)

PostgreSql(Aggregative Functions)

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

Inside SQLite’s Frontend: How Your SQL Becomes Bytecode

18
Comments 1
4 min read
SQL triggers for blocking

SQL triggers for blocking

Comments
1 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)
Cover image for PostgreSql(Filtering & Sorting)

PostgreSql(Filtering & Sorting)

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