close

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.
SQLite Cross-DB FKs, SQL-First Postgres, & N+1 Query Fingerprinting

SQLite Cross-DB FKs, SQL-First Postgres, & N+1 Query Fingerprinting

Comments
4 min read
storage_engine: Two High-Performance Table Access Methods for PostgreSQL Analytics and HTAP Workloads

storage_engine: Two High-Performance Table Access Methods for PostgreSQL Analytics and HTAP Workloads

Comments
9 min read
DuckDB in the Wild: What 6 Minutes of Benchmarking Across 4 Machines Taught Me About Real-World Performance

DuckDB in the Wild: What 6 Minutes of Benchmarking Across 4 Machines Taught Me About Real-World Performance

Comments
5 min read
3 Database Indexes Turned a 30-Second Query Into 0.4 Seconds

3 Database Indexes Turned a 30-Second Query Into 0.4 Seconds

Comments
3 min read
The Restart Challenge: Day 04

The Restart Challenge: Day 04

Comments
1 min read
ETL vs ELT: Understanding the Two Pillars of Modern Data Engineering

ETL vs ELT: Understanding the Two Pillars of Modern Data Engineering

Comments
16 min read
Database Subsetting for PostgreSQL: A Practical Guide (2026)

Database Subsetting for PostgreSQL: A Practical Guide (2026)

Comments
11 min read
Local Analysis of Garmin Activities and Fitness Data without Cloud

Local Analysis of Garmin Activities and Fitness Data without Cloud

Comments
4 min read
How We Built a Disaggregated Storage Layer for a Columnar MPP Database (And What Broke in Production)

How We Built a Disaggregated Storage Layer for a Columnar MPP Database (And What Broke in Production)

Comments
6 min read
TradeMemory An AI-Powered Persistence Layer for Disciplined Trading

TradeMemory An AI-Powered Persistence Layer for Disciplined Trading

BERJAYA 1
Comments
4 min read
Seed Data Without a Dependency Tree: A Tiny PHP CLI Instead of Faker

Seed Data Without a Dependency Tree: A Tiny PHP CLI Instead of Faker

Comments
10 min read
Solving the 100M-Row Problem: A Summary Table Pattern for High-Volume Push Notification Logs

Solving the 100M-Row Problem: A Summary Table Pattern for High-Volume Push Notification Logs

Comments
13 min read
PostgreSQL Slow Query Log: Finding & Fixing Your Slowest Queries

PostgreSQL Slow Query Log: Finding & Fixing Your Slowest Queries

Comments
4 min read
PostgreSQL Read Replicas with Docker: A Step-by-Step Guide

PostgreSQL Read Replicas with Docker: A Step-by-Step Guide

BERJAYA BERJAYA 3
Comments
24 min read
Vector Embeddings: How They Work, Where to Store Them, and Best Practices

Vector Embeddings: How They Work, Where to Store Them, and Best Practices

BERJAYA 1
Comments
10 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.