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.
One Request Waited 5 Seconds to Clean Up Laravel Sessions. Here Is What 13.39's session:garbage-collect Changes

One Request Waited 5 Seconds to Clean Up Laravel Sessions. Here Is What 13.39's session:garbage-collect Changes

Comments
7 min read
The Hidden Cost of PostgreSQL JSONB Columns Under High Write Load

Shows 8x WAL bloat from tiny updates

The Hidden Cost of PostgreSQL JSONB Columns Under High Write Load

27
Comments 22
6 min read
I Cut My Flutter App's Data Usage by 95% with a Delta-Sync Engine

I Cut My Flutter App's Data Usage by 95% with a Delta-Sync Engine

1
Comments
5 min read
SQL INNER JOIN vs LEFT JOIN vs RIGHT JOIN vs FULL OUTER JOIN: Differences With Examples (Tested in MySQL 8.4 and SQLite)

SQL INNER JOIN vs LEFT JOIN vs RIGHT JOIN vs FULL OUTER JOIN: Differences With Examples (Tested in MySQL 8.4 and SQLite)

Comments
12 min read
Why Database Schema Design Should Come Before Backend Development

Why Database Schema Design Should Come Before Backend Development

Comments
4 min read
Longer Timeouts Won't Fix Your Webhook Duplicates. Claiming the Work Once Will

Longer Timeouts Won't Fix Your Webhook Duplicates. Claiming the Work Once Will

3
Comments 6
6 min read
Designing Airflow DAGs with Retries, SLAs, and Idempotency

Designing Airflow DAGs with Retries, SLAs, and Idempotency

1
Comments
7 min read
supabase-js try/catch Doesn't Catch Errors: Check { error }

supabase-js try/catch Doesn't Catch Errors: Check { error }

Comments
4 min read
How EXPLAIN ANALYZE helped us cut PostgreSQL query time by 80% under peak load

How EXPLAIN ANALYZE helped us cut PostgreSQL query time by 80% under peak load

1
Comments
3 min read
When Your Data Breaks on AWS (HA & DR Part 1): Aurora Backtrack, Idempotency, and the Delta Problem

When Your Data Breaks on AWS (HA & DR Part 1): Aurora Backtrack, Idempotency, and the Delta Problem

1
Comments
10 min read
KV-Cache Offload to NVMe vs Recompute: The TTFT Bill Comes Due

KV-Cache Offload to NVMe vs Recompute: The TTFT Bill Comes Due

Comments
5 min read
Recover a popped job from a durable SQLite outbox

Recover a popped job from a durable SQLite outbox

Comments
2 min read
PostgreSQL Indexing Cheat Sheet for Busy Developers

PostgreSQL Indexing Cheat Sheet for Busy Developers

Comments
1 min read
How to reconcile Stripe payments in a double-entry ledger

How to reconcile Stripe payments in a double-entry ledger

Comments
12 min read
Confirm a missing index with EXPLAIN ANALYZE and index inspection

Confirm a missing index with EXPLAIN ANALYZE and index inspection

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