Forem

Database

Posts on building, using, and learning about databases.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Five Corrections: What an AI Agent Didn't Know About My Production Database

Five Corrections: What an AI Agent Didn't Know About My Production Database

2
Comments
5 min read
Improving Data Ingestion Throughput with a Queue-Based Pipeline: Python + Duckdb
Cover image for Improving Data Ingestion Throughput with a Queue-Based Pipeline: Python + Duckdb

Improving Data Ingestion Throughput with a Queue-Based Pipeline: Python + Duckdb

Comments
3 min read
I built a database in France because the Cloud Act makes EU data sovereignty impossible
Cover image for I built a database in France because the Cloud Act makes EU data sovereignty impossible

Local-first architecture for AI privacy

I built a database in France because the Cloud Act makes EU data sovereignty impossible

5
Comments 10
12 min read
The Gravity Well Problem: Scaling PostgreSQL 17 Index Maintenance at Terabyte Scale
Cover image for The Gravity Well Problem: Scaling PostgreSQL 17 Index Maintenance at Terabyte Scale

The Gravity Well Problem: Scaling PostgreSQL 17 Index Maintenance at Terabyte Scale

1
Comments
8 min read
Understanding SQL Joins and Window Functions

Understanding SQL Joins and Window Functions

Comments
4 min read
Database Branch Testing: How Isolated Environments Improve QA Confidence
Cover image for Database Branch Testing: How Isolated Environments Improve QA Confidence

Database Branch Testing: How Isolated Environments Improve QA Confidence

1
Comments
11 min read
Geolocation Optimization: Caching and Local Database Lookup

Geolocation Optimization: Caching and Local Database Lookup

Comments
2 min read
PostgreSQL backup to S3 — How to store your database backups in the cloud
Cover image for PostgreSQL backup to S3 — How to store your database backups in the cloud

PostgreSQL backup to S3 — How to store your database backups in the cloud

Comments
6 min read
🗄️ MongoDB/Mongoose Cheat Sheet
Cover image for 🗄️ MongoDB/Mongoose Cheat Sheet

🗄️ MongoDB/Mongoose Cheat Sheet

Comments
3 min read
Your pgvector Queries Are Doing Sequential Scans — Here's Why
Cover image for Your pgvector Queries Are Doing Sequential Scans — Here's Why

Your pgvector Queries Are Doing Sequential Scans — Here's Why

1
Comments
4 min read
Zero Data Loss Migration: Moving Billions of Rows from SQL Server to Aurora RDS — Architecture, Predictive CDC Monitoring & Lessons from Production

Zero Data Loss Migration: Moving Billions of Rows from SQL Server to Aurora RDS — Architecture, Predictive CDC Monitoring & Lessons from Production

4
Comments 2
7 min read
PostGIS Geometry Quality: Invalid Geometries, Mixed SRIDs, and Complexity
Cover image for PostGIS Geometry Quality: Invalid Geometries, Mixed SRIDs, and Complexity

PostGIS Geometry Quality: Invalid Geometries, Mixed SRIDs, and Complexity

1
Comments
3 min read
The Backyard Quarry, Part 4: Searching a Pile of Rocks
Cover image for The Backyard Quarry, Part 4: Searching a Pile of Rocks

The Backyard Quarry, Part 4: Searching a Pile of Rocks

1
Comments
4 min read
the difference between snowflake and the "other" databases

the difference between snowflake and the "other" databases

1
Comments
4 min read
Building a database to understand databases

Building a database to understand databases

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