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.
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
I Benchmarked 4,999 WordPress Plugins for Speed. Here Are the Results.

I Benchmarked 4,999 WordPress Plugins for Speed. Here Are the Results.

Comments
2 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
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
PostGIS Geometry Quality: Invalid Geometries, Mixed SRIDs, and Complexity

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

1
Comments
3 min read
Bringing Time-Series Forecasting into Apache IoTDB Database

Bringing Time-Series Forecasting into Apache IoTDB Database

Comments
5 min read
Monitor Manticore Search in Grafana with One Command

Monitor Manticore Search in Grafana with One Command

Comments
4 min read
WAL (Write-Ahead Logging) Concepts

WAL (Write-Ahead Logging) Concepts

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