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.
Day 30 of 100 Days of ClickHouse® - Using ClickHouse® Arrays for Complex Data Structures

Day 30 of 100 Days of ClickHouse® - Using ClickHouse® Arrays for Complex Data Structures

2
Comments
5 min read
Day 71 - Advanced Partitioning Strategies for Petabyte-Scale Tables

Day 71 - Advanced Partitioning Strategies for Petabyte-Scale Tables

Comments
4 min read
Embedding Live Charts in Your App Without a Full BI Tool

Embedding Live Charts in Your App Without a Full BI Tool

Comments
5 min read
Chạy PostgreSQL + Redis + Elasticsearch trên ThinkPad X1 2-in-1 Aura

Chạy PostgreSQL + Redis + Elasticsearch trên ThinkPad X1 2-in-1 Aura

Comments
3 min read
Multi-Tenant Data Isolation in SQLite: Per-User Database Files vs Row-Level

Multi-Tenant Data Isolation in SQLite: Per-User Database Files vs Row-Level

1
Comments
9 min read
Why ClickHouse Merges and Mutations Are Difficult to Track in Production

Why ClickHouse Merges and Mutations Are Difficult to Track in Production

2
Comments
3 min read
moteDB 0.5.1 Is Out: What 18 Months of Building an Embedded Database for Robots Taught Me

moteDB 0.5.1 Is Out: What 18 Months of Building an Embedded Database for Robots Taught Me

3
Comments
5 min read
Why I built a SQL client when 10 already exist — then let AI agents into it

Transaction-level safety over regex guardrails

Why I built a SQL client when 10 already exist — then let AI agents into it

4
Comments 3
4 min read
UUID v4 vs UUID v7: Performance, Security and Real Benchmarks at 100M

UUID v4 vs UUID v7: Performance, Security and Real Benchmarks at 100M

3
Comments
9 min read
Can a Mac Mini Handle 100 Million Rows?

Row-store vs columnar performance on M4

Can a Mac Mini Handle 100 Million Rows?

28
Comments 9
7 min read
Your Postgres Is Quietly Rotting — Here Are the Queries That Show It

Your Postgres Is Quietly Rotting — Here Are the Queries That Show It

2
Comments 2
9 min read
Sharding in a nutshell

Sharding in a nutshell

5
Comments 1
3 min read
Part 8: Persistence and State - EF Core, Migrations, and Reliability

Part 8: Persistence and State - EF Core, Migrations, and Reliability

Comments
3 min read
The empty-database problem: realistic test data in one command

The empty-database problem: realistic test data in one command

Comments
2 min read
Day 20 of 100 Days of ClickHouse® - Introduction to Materialized Views

Day 20 of 100 Days of ClickHouse® - Introduction to Materialized Views

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