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.
28/30 Days System Design Questions!

28/30 Days System Design Questions!

1
Comments 4
1 min read
Migrate a Prisma project to Postgres, MySQL, Mongo — or 10 other databases — with zero code change, using @mostajs/orm-cli

Migrate a Prisma project to Postgres, MySQL, Mongo — or 10 other databases — with zero code change, using @mostajs/orm-cli

Comments
4 min read
The Problem with Traditional Indexes and Spatial Queries

The Problem with Traditional Indexes and Spatial Queries

Comments
5 min read
PostgreSQL Ecosystem: New Extensions, Graph Queries, & Performance Insights

PostgreSQL Ecosystem: New Extensions, Graph Queries, & Performance Insights

Comments
3 min read
I Learned SQL in College - But Nobody Told Me Where to Actually Use It

I Learned SQL in College - But Nobody Told Me Where to Actually Use It

Comments
3 min read
The Day I Realized Backups Aren't Disaster Recovery: Lessons From Building an AWS Recovery Strategy

The Day I Realized Backups Aren't Disaster Recovery: Lessons From Building an AWS Recovery Strategy

Comments
3 min read
How I architected the backend for a local vehicle rental marketplace

How I architected the backend for a local vehicle rental marketplace

Comments 1
2 min read
Before you build search with Elasticsearch, decide this first

Before you build search with Elasticsearch, decide this first

Comments
5 min read
PostgreSQL Connection Pooling Explained: How It Works and Why It Matters

PostgreSQL Connection Pooling Explained: How It Works and Why It Matters

Comments
15 min read
Query Markdown as a Database with mq-db: SQL, mq, and Interval Indexes

Query Markdown as a Database with mq-db: SQL, mq, and Interval Indexes

Comments
4 min read
SQL for Developers: The Practical Guide (2026)

SQL for Developers: The Practical Guide (2026)

Comments
5 min read
MongoDB Schema Validation: How JSON Schema Keeps Your Data Clean

MongoDB Schema Validation: How JSON Schema Keeps Your Data Clean

4
Comments
7 min read
1.4.2 Cost model: sequential scan formula

1.4.2 Cost model: sequential scan formula

Comments
10 min read
EF6 to EF Core: 5 query translations that quietly break in production

EF6 to EF Core: 5 query translations that quietly break in production

Comments
5 min read
Product Tree Denormalization in Side Projects: Is It Really Necessary?

Product Tree Denormalization in Side Projects: Is It Really Necessary?

Comments
7 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.