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.
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
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
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
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
qrrot - database with AI
piterovxyz profile

qrrot - database with AI

#ai #go #sql #database
1
Comments
6 min read
Migrating from Neon to Supabase (Postgres + Drizzle, in production)
blackie360 profile

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

#database #nextjs #postgres #tutorial
Comments
7 min read
Subqueries vs CTEs in SQL: A Complete Guide for Beginners
k1gen_ profile

Subqueries vs CTEs in SQL: A Complete Guide for Beginners

#beginners #database #sql #tutorial
Comments
8 min read
Distributed Uniqueness: Implementing Twitter Snowflake IDs in Rails 8
zilton7 profile

Distributed Uniqueness: Implementing Twitter Snowflake IDs in Rails 8

#rails #ruby #database #architecture
Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.