Forem

Database

Posts on building, using, and learning about databases.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Beyond CRUD: How easy-query Brings OLAP Superpowers to Your Java ORM

Beyond CRUD: How easy-query Brings OLAP Superpowers to Your Java ORM

2
Comments
7 min read
Dissecting MongoDB — It Uses B-Trees Too, So Why Are Writes Actually Faster?
Cover image for Dissecting MongoDB — It Uses B-Trees Too, So Why Are Writes Actually Faster?

Dissecting MongoDB — It Uses B-Trees Too, So Why Are Writes Actually Faster?

4
Comments
10 min read
Stop writing cron jobs: I built a C++ database with native temporal states
Cover image for Stop writing cron jobs: I built a C++ database with native temporal states

Stop writing cron jobs: I built a C++ database with native temporal states

5
Comments
1 min read
How I made a 31M-row SQLite query go from 168 seconds to 5 seconds

How I made a 31M-row SQLite query go from 168 seconds to 5 seconds

1
Comments
4 min read
Next.js 16 SaaS Database Schema with Prisma: Users, Subscriptions, and AI Chat

Next.js 16 SaaS Database Schema with Prisma: Users, Subscriptions, and AI Chat

1
Comments
4 min read
Building a Content Cleanup System for Old Videos

Building a Content Cleanup System for Old Videos

Comments
2 min read
Introducing Xata OSS: Postgres platform with branching, now Apache 2.0
Cover image for Introducing Xata OSS: Postgres platform with branching, now Apache 2.0

Introducing Xata OSS: Postgres platform with branching, now Apache 2.0

2
Comments
7 min read
pg_duckpipe: Real-time CDC for streaming Postgres Table into Columnar Ducklake
Cover image for pg_duckpipe: Real-time CDC for streaming Postgres Table into Columnar Ducklake

pg_duckpipe: Real-time CDC for streaming Postgres Table into Columnar Ducklake

1
Comments
3 min read
Reacting to Database Changes in Real-Time: How I Built a CDC Tool
Cover image for Reacting to Database Changes in Real-Time: How I Built a CDC Tool

Reacting to Database Changes in Real-Time: How I Built a CDC Tool

1
Comments 1
8 min read
AUTOVACUUM in SQLite: How Your Database Cleans Up After Itself
Cover image for AUTOVACUUM in SQLite: How Your Database Cleans Up After Itself

AUTOVACUUM in SQLite: How Your Database Cleans Up After Itself

21
Comments 5
4 min read
Salesforce Put Heroku Into Maintenance Mode.
Cover image for Salesforce Put Heroku Into Maintenance Mode.

Salesforce Put Heroku Into Maintenance Mode.

1
Comments
2 min read
SQL Formatting Best Practices: Write Clean, Readable Queries

SQL Formatting Best Practices: Write Clean, Readable Queries

Comments
14 min read
What an Old Oracle Database Taught Me About Not Trusting Assumptions

What an Old Oracle Database Taught Me About Not Trusting Assumptions

3
Comments
1 min read
AWS Glue Alternatives: Simpler Ways to Sync API Data to RDS

AWS Glue Alternatives: Simpler Ways to Sync API Data to RDS

Comments
9 min read
UUID Generator Guide: Understanding v1, v4, and v5 UUIDs

UUID Generator Guide: Understanding v1, v4, and v5 UUIDs

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