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.
Write-ahead logs: what fsync actually means and why it matters

Write-ahead logs: what fsync actually means and why it matters

1
Comments
8 min read
Lakehouse Table Formats in 2026: Iceberg, Delta Lake, Hudi, Paimon, and DuckLake, How They Work, Where They Stand, and Where They're Going

Lakehouse Table Formats in 2026: Iceberg, Delta Lake, Hudi, Paimon, and DuckLake, How They Work, Where They Stand, and Where They're Going

Comments
22 min read
The File Format Renaissance: Parquet, Lance, Vortex, Nimble, BtrBlocks, and the New Physics of Columnar Storage

The File Format Renaissance: Parquet, Lance, Vortex, Nimble, BtrBlocks, and the New Physics of Columnar Storage

Comments
21 min read
The only scalable delete in Postgres is DROP TABLE

The only scalable delete in Postgres is DROP TABLE

1
Comments
5 min read
Database Optimization Techniques for High-Traffic Laravel Applications

Database Optimization Techniques for High-Traffic Laravel Applications

Comments
4 min read
I scanned 15 public Lovable apps. 40% load their database in the browser.

I scanned 15 public Lovable apps. 40% load their database in the browser.

Comments 4
1 min read
QN : Ingest and transform data in a lakehouse

QN : Ingest and transform data in a lakehouse

Comments
2 min read
DuckLake Spec, pg_background 2.0, and pgsql_tweaks 1.0.3 Enhance Database Ecosystem

DuckLake Spec, pg_background 2.0, and pgsql_tweaks 1.0.3 Enhance Database Ecosystem

Comments
4 min read
Best Tools to Sync Stripe Data to a Database (2026)

Best Tools to Sync Stripe Data to a Database (2026)

1
Comments
10 min read
Update record using JooqTemplate

Update record using JooqTemplate

Comments
1 min read
PostgreSQL 22013 Error: Causes and Solutions Complete Guide

PostgreSQL 22013 Error: Causes and Solutions Complete Guide

1
Comments
3 min read
Introduzindo SQL

Introduzindo SQL

1
Comments
5 min read
T-SQL patterns that break when you migrate SQL Server to PostgreSQL (and where they hide in Java/C#)

T-SQL patterns that break when you migrate SQL Server to PostgreSQL (and where they hide in Java/C#)

Comments
1 min read
Self-Host Postgres or Use Supabase? Here's How to Decide

Self-Host Postgres or Use Supabase? Here's How to Decide

Comments
3 min read
Day 9: A Database That Won't Start Is Usually a Permissions Problem

Day 9: A Database That Won't Start Is Usually a Permissions Problem

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