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.
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
Migrating from Neon to Supabase (Postgres + Drizzle, in production)

Migrating from Neon to Supabase (Postgres + Drizzle, in production)

Comments
7 min read
I built a 13-database ORM for Node.js because Prisma doesn't support Oracle

I built a 13-database ORM for Node.js because Prisma doesn't support Oracle

Comments
2 min read
Subqueries vs CTEs in SQL: A Complete Guide for Beginners

Subqueries vs CTEs in SQL: A Complete Guide for Beginners

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