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.
I Built a Bloom Filter from Scratch in Pure Python and Finally Understood How Databases Skip Reading Data

I Built a Bloom Filter from Scratch in Pure Python and Finally Understood How Databases Skip Reading Data

Comments
6 min read
How Cassandra Compression Actually Works (Chunks, Offsets, and Reads)

How Cassandra Compression Actually Works (Chunks, Offsets, and Reads)

Comments
5 min read
33/60 Days System Design Questions

33/60 Days System Design Questions

1
Comments 4
1 min read
The graph nobody is watching

The graph nobody is watching

Comments
7 min read
Entity Framework vs. Dapper: Choosing the Right ORM for .NET

Entity Framework vs. Dapper: Choosing the Right ORM for .NET

Comments
4 min read
Beyond UUID v4: v7, ULID, and the Future of Unique IDs

Beyond UUID v4: v7, ULID, and the Future of Unique IDs

Comments
2 min read
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
SQL: Data Constraints

SQL: Data Constraints

1
Comments 2
4 min read
SQL: JOIN Queries

SQL: JOIN Queries

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