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.
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

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

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

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

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

Comments
6 min read
🗄️ MongoDB/Mongoose Cheat Sheet

🗄️ MongoDB/Mongoose Cheat Sheet

Comments
3 min read
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

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

1
Comments
3 min read
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
The origins of MongoDB

The origins of MongoDB

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