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.
.NET ORM Options & Best Practices for 2026: EF Core vs Dapper vs Hybrid Approaches
vikrant_bagal_afae3e25ca7 profile

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

#dotnet #database #entity
Comments
6 min read
PostgreSQL BRIN Indexes: When & How to Use Block Range Indexes
philip_mcclarence_2ef9475 profile

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

#database #performance #postgres #tutorial
Comments
4 min read
Scaling Databases: PostgreSQL Table Partitioning in Laravel 🐘
iprajapatiparesh profile

Scaling Databases: PostgreSQL Table Partitioning in Laravel 🐘

#postgres #laravel #database #architecture
Comments
3 min read
How I indexed 18,141 polynomial fan curves in Postgres and matched a duty point in 4 ms
goncharovart profile

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

#showdev #database #performance #postgres
Comments
6 min read
Generating Realistic Seed Data That Respects Foreign Keys, in 20 Seconds
gillarohith profile

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

#database #postgres #testing #webdev
1
Comments 1
6 min read
SQLite Tcl Extension, TimescaleDB Aggregates & PostgreSQL Data Pipelines
soytuber profile
soy

SQLite Tcl Extension, TimescaleDB Aggregates & PostgreSQL Data Pipelines

#database #sql #sqlite
Comments
3 min read
An index made our query faster. It slowly suffocated our database.
diata0210 profile

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

#database #backend #performance #webdev
Comments
5 min read
You might not need… the repository pattern
jayfreestone profile

You might not need… the repository pattern

#architecture #backend #database
1
Comments
9 min read
Single-Node Data Engineering: DuckDB, DataFusion, Polars, and LakeSail
alexmercedcoder profile

Single-Node Data Engineering: DuckDB, DataFusion, Polars, and LakeSail

#architecture #database #dataengineering #performance
1
Comments
18 min read
Building Agentic Commerce Infrastructure: Overcoming SQLite Concurrency for Autonomous Procurement Agents
anhmtk profile

Building Agentic Commerce Infrastructure: Overcoming SQLite Concurrency for Autonomous Procurement Agents

#ai #database #webdev #mcp
5
Comments 8
4 min read
Level Up Your SQL: Subqueries & CTEs in the Real World
adev3loper profile

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

#sql #dataengineering #database #assignment
Comments
9 min read
Why don’t my database numbers match? I built a tool to find out.
harrywynn profile

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

#database #webdev #programming #dataengineering
Comments
2 min read
Range Scans and Tombstones in Bf-Tree
lovestaco profile

Range Scans and Tombstones in Bf-Tree

#webdev #programming #database #architecture
15
Comments 1
2 min read
PostgreSQL High Availability: A Practical Guide with Patroni and pgBouncer
instadevops profile

PostgreSQL High Availability: A Practical Guide with Patroni and pgBouncer

#postgres #database #devops #highavailability
Comments
6 min read
How to Save Bloated MCP with Code Mode

Collapsing 2,500 endpoints into two tools
jiasheng profile
JS for ZenStack

How to Save Bloated MCP with Code Mode

#ai #webdev #agents #database
73
Comments 31
7 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.