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.
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
JSONB vs Relational in 2026: 5 Query Shapes, 5 Verdicts
gabrielanhaia profile

JSONB vs Relational in 2026: 5 Query Shapes, 5 Verdicts

#postgres #database #performance #backend
Comments
8 min read
Logical Replication for Migrations: Zero-Downtime Postgres Upgrades in 2026
gabrielanhaia profile

Logical Replication for Migrations: Zero-Downtime Postgres Upgrades in 2026

#postgres #database #devops #replication
Comments
9 min read
Postgres VACUUM Tuning: 4 Settings That Decide Whether Autovacuum Keeps Up
gabrielanhaia profile

Postgres VACUUM Tuning: 4 Settings That Decide Whether Autovacuum Keeps Up

#postgres #database #performance #devops
Comments
8 min read
Read-Modify-Write: The Optimistic Concurrency Pattern Most ORMs Get Wrong
gabrielanhaia profile

Read-Modify-Write: The Optimistic Concurrency Pattern Most ORMs Get Wrong

#database #orm #concurrency #backend
Comments
8 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
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
Read Replicas Lie About Consistency. 4 Sync Modes Behind the Lie.
gabrielanhaia profile

Read Replicas Lie About Consistency. 4 Sync Modes Behind the Lie.

#postgres #database #distributedsystems #backend
Comments
8 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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.