Database - DEV Community

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.
4 SQL statements and a segfault: inside PostgreSQL's 22-year-old type confusion, CVE-2026-6460

4 SQL statements and a segfault: inside PostgreSQL's 22-year-old type confusion, CVE-2026-6460

8
Comments 1
5 min read
Choosing a Futures Tick Database: Test Event Fidelity Before Query Speed

Choosing a Futures Tick Database: Test Event Fidelity Before Query Speed

Comments
5 min read
SmartInventory

SmartInventory

Comments
8 min read
Evaluating Event Sourcing: Balancing Production Trade-Offs and Operational Complexity Against Theoretical Benefits

Evaluating Event Sourcing: Balancing Production Trade-Offs and Operational Complexity Against Theoretical Benefits

Comments
9 min read
We spent months building a database client, then decided to turn it into a VS Code extension

We spent months building a database client, then decided to turn it into a VS Code extension

1
Comments
3 min read
I built an SSTable storage engine

I built an SSTable storage engine

Comments
15 min read
Getting PostgreSQL ready for Black Friday: a SQL-first checklist

Getting PostgreSQL ready for Black Friday: a SQL-first checklist

Comments
25 min read
Postgres to Redshift: A CDC Walkthrough That Ends in One External Schema

Postgres to Redshift: A CDC Walkthrough That Ends in One External Schema

Comments
12 min read
A Full Table Scan Isn’t Always a Mistake

A Full Table Scan Isn’t Always a Mistake

Comments
4 min read
One constant was costing my schema retriever 17 points

One constant was costing my schema retriever 17 points

Comments
2 min read
Postgres not using your index? It's counting pages, not rows

Postgres not using your index? It's counting pages, not rows

Comments
10 min read
Build a Pre-Deployment Schema Drift Check for SQL Server

Build a Pre-Deployment Schema Drift Check for SQL Server

Comments
5 min read
Laravel chunk() Silently Skips Half Your Rows (+3 Eloquent Mistakes on Big Tables)

Laravel chunk() Silently Skips Half Your Rows (+3 Eloquent Mistakes on Big Tables)

Comments
3 min read
5 SQL mistakes that return the wrong number with no error (reproduce each one in Postgres)

5 SQL mistakes that return the wrong number with no error (reproduce each one in Postgres)

Comments
4 min read
Why I Built a Free, Offline-First Habit Tracker with Zero Logins and Local SQLite

Why I Built a Free, Offline-First Habit Tracker with Zero Logins and Local SQLite

Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.