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
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
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
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
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
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
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
What Developers Get Wrong About Storing Sensor Data
Cover image for What Developers Get Wrong About Storing Sensor Data

What Developers Get Wrong About Storing Sensor Data

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

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

Comments
4 min read
Why PostgreSQL Ignores Your Index (Sometimes), Entry #2

Why PostgreSQL Ignores Your Index (Sometimes), Entry #2

3
Comments
3 min read
How I Cured "AI Amnesia" Without Vector DBs (Zero Cost Architecture) Daemon's Project

How I Cured "AI Amnesia" Without Vector DBs (Zero Cost Architecture) Daemon's Project

1
Comments 5
3 min read
Covariate Forecasting: The Next Leap in Time-Series Database Capabilities
Cover image for Covariate Forecasting: The Next Leap in Time-Series Database Capabilities

Covariate Forecasting: The Next Leap in Time-Series Database Capabilities

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