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.
Listening to the Heartbeat of Your Database: Understanding Change Data Capture (CDC)

Listening to the Heartbeat of Your Database: Understanding Change Data Capture (CDC)

Comments
4 min read
Blazing Fast Analytics: Materialized Views in Larave

Blazing Fast Analytics: Materialized Views in Larave

Comments
3 min read
Day 24 of 100 Days of ClickHouse: Working with the ClickHouse HTTP API

Day 24 of 100 Days of ClickHouse: Working with the ClickHouse HTTP API

3
Comments
5 min read
The Postgres migration that locks your table at 3am, and how to catch it in review

The Postgres migration that locks your table at 3am, and how to catch it in review

3
Comments
5 min read
Spring Deep Dive: Transactions

Spring Deep Dive: Transactions

6
Comments 2
7 min read
Four Questions to Ask Before Celebrating a 4x Proxy Benchmark

Four Questions to Ask Before Celebrating a 4x Proxy Benchmark

Comments
2 min read
Nullable Is a Rollout Strategy, Not a Domain Model

Nullable Is a Rollout Strategy, Not a Domain Model

Comments 1
3 min read
From Joins to Graph Edges: SQL/PGQ in PostgreSQL 19

From Joins to Graph Edges: SQL/PGQ in PostgreSQL 19

Comments 1
6 min read
The N+1 Query Problem: How One Page Fires 2,101 Queries (and How to Get Back to 3)

The N+1 Query Problem: How One Page Fires 2,101 Queries (and How to Get Back to 3)

Comments 5
3 min read
Apache Data Lakehouse Weekly: July 16 to July 23, 2026

Apache Data Lakehouse Weekly: July 16 to July 23, 2026

Comments
25 min read
How to Embed a SQL Dashboard into Your SaaS App (Without Building Everything from Scratch)

How to Embed a SQL Dashboard into Your SaaS App (Without Building Everything from Scratch)

1
Comments
6 min read
Use SQLite STRICT Tables for Agent Control Data

Use SQLite STRICT Tables for Agent Control Data

Comments
3 min read
SQL-First Paradigm: Rethinking Persistence Layer Design from First Principles

SQL-First Paradigm: Rethinking Persistence Layer Design from First Principles

1
Comments 1
9 min read
Real-Time VPN & Proxy Detection: Why Static IP Databases Are Failing You

Real-Time VPN & Proxy Detection: Why Static IP Databases Are Failing You

Comments
2 min read
DuckDB 1.4.5 LTS, pgEdge ColdFront Beta, and SQLite's FCNTL_PDB Internals

DuckDB 1.4.5 LTS, pgEdge ColdFront Beta, and SQLite's FCNTL_PDB Internals

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