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.
Enhanced Tagging in Postgres Query Insights

Enhanced Tagging in Postgres Query Insights

Comments
7 min read
Design review: Live SQL queries on PostgreSQL

Design review: Live SQL queries on PostgreSQL

2
Comments
2 min read
Setting Up Disaster Recovery for HPE Morpheus Enterprise with MySQL InnoDB ClusterSet Step by Step

Setting Up Disaster Recovery for HPE Morpheus Enterprise with MySQL InnoDB ClusterSet Step by Step

Comments
18 min read
Dapper vs. Entity Framework Core: An In-Depth Comparison

Dapper vs. Entity Framework Core: An In-Depth Comparison

1
Comments
3 min read
SQL vs NoSQL — A Decision Framework That Actually Works

SQL vs NoSQL — A Decision Framework That Actually Works

Comments
2 min read
.NET ORM Options & Best Practices for 2026: EF Core vs Dapper vs Hybrid Approaches

.NET ORM Options & Best Practices for 2026: EF Core vs Dapper vs Hybrid Approaches

Comments
6 min read
PostgreSQL BRIN Indexes: When & How to Use Block Range Indexes

PostgreSQL BRIN Indexes: When & How to Use Block Range Indexes

Comments
4 min read
Scaling Databases: PostgreSQL Table Partitioning in Laravel 🐘

Scaling Databases: PostgreSQL Table Partitioning in Laravel 🐘

Comments
3 min read
How I indexed 18,141 polynomial fan curves in Postgres and matched a duty point in 4 ms

How I indexed 18,141 polynomial fan curves in Postgres and matched a duty point in 4 ms

Comments
6 min read
Generating Realistic Seed Data That Respects Foreign Keys, in 20 Seconds

Generating Realistic Seed Data That Respects Foreign Keys, in 20 Seconds

1
Comments 1
6 min read
SQLite Tcl Extension, TimescaleDB Aggregates & PostgreSQL Data Pipelines

SQLite Tcl Extension, TimescaleDB Aggregates & PostgreSQL Data Pipelines

Comments
3 min read
An index made our query faster. It slowly suffocated our database.

An index made our query faster. It slowly suffocated our database.

Comments
5 min read
Level Up Your SQL: Subqueries & CTEs in the Real World

Level Up Your SQL: Subqueries & CTEs in the Real World

Comments
9 min read
Why don’t my database numbers match? I built a tool to find out.

Why don’t my database numbers match? I built a tool to find out.

Comments
2 min read
PostgreSQL High Availability: A Practical Guide with Patroni and pgBouncer

PostgreSQL High Availability: A Practical Guide with Patroni and pgBouncer

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