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.
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
A Practical Guide to Exception Handling and Flow Control in GBase 8a Stored Procedures

A Practical Guide to Exception Handling and Flow Control in GBase 8a Stored Procedures

2
Comments
2 min read
The Restart Challenge: Day 04

The Restart Challenge: Day 04

Comments
1 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
SpacetimeDB vs Convex: Performance Analysis Review

SpacetimeDB vs Convex: Performance Analysis Review

Comments
5 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
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
Local Analysis of Garmin Activities and Fitness Data without Cloud

Local Analysis of Garmin Activities and Fitness Data without Cloud

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

Database Subsetting for PostgreSQL: A Practical Guide (2026)

Comments
11 min read
MariaDB End-of-Life Dates — Official EOL Schedule for Every Version

MariaDB End-of-Life Dates — Official EOL Schedule for Every Version

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

TradeMemory An AI-Powered Persistence Layer for Disciplined Trading

1
Comments
4 min read
I built a storage engine from scratch. Here’s everything I learned.

I built a storage engine from scratch. Here’s everything I learned.

Comments 2
5 min read
How to Prompt AI Tools to Write Accurate SQL Queries (And Why Most Developers Get This Wrong)

How to Prompt AI Tools to Write Accurate SQL Queries (And Why Most Developers Get This Wrong)

1
Comments
6 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
Secure Database Access for AI Agents: Building an MCP Server with SQLatte

Secure Database Access for AI Agents: Building an MCP Server with SQLatte

2
Comments 3
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.