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.
Multi-Tenant Data Isolation in SQLite: Per-User Database Files vs Row-Level
helperx profile

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

#database #sqlite #architecture #saas
1
Comments
9 min read
My OpenCode Database Was Mostly Empty Space
antonio_zhu_e726fd856cd86 profile

My OpenCode Database Was Mostly Empty Space

#agents #database #programming
Comments
6 min read
Why ClickHouse Merges and Mutations Are Difficult to Track in Production
kanishga_subramani_49ad73 profile

Why ClickHouse Merges and Mutations Are Difficult to Track in Production

#clickhouse #database #dataengineering #observability
2
Comments
3 min read
moteDB 0.5.1 Is Out: What 18 Months of Building an Embedded Database for Robots Taught Me
motedb profile
mote

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

#rust #database #embedded #opensource
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
gillarohith profile

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

#showdev #ai #mcp #database
4
Comments 3
4 min read
UUID v4 vs UUID v7: Performance, Security and Real Benchmarks at 100M
kouadio_mathiaskouame_a6 profile

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

#uuid #database #performance #webdev
3
Comments
9 min read
Your Postgres Is Quietly Rotting — Here Are the Queries That Show It
arthurpro profile

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

#postgres #database #sql
2
Comments 2
9 min read
Sharding in a nutshell
code_with_aravind profile

Sharding in a nutshell

#systemdesign #dataengineering #database #webdev
5
Comments 1
3 min read
Part 8: Persistence and State - EF Core, Migrations, and Reliability
homolibere profile
Nick

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

#dotnet #architecture #csharp #database
Comments
3 min read
The empty-database problem: realistic test data in one command
sara_mo profile

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

#python #testing #opensource #database
Comments
2 min read
Day 20 of 100 Days of ClickHouse® - Introduction to Materialized Views
kanishga_subramani_49ad73 profile

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

#clickhouse #devops #database #dataengineering
9
Comments 2
2 min read
Postmortem: Silent Data Loss in an In-Process Vector Store, and the Case for Durable Execution
obataka profile

Postmortem: Silent Data Loss in an In-Process Vector Store, and the Case for Durable Execution

#architecture #database #python #zvec
Comments 2
9 min read
Zero-Downtime MariaDB PostgreSQL Migration: Why the Usual Tools Fell Short, and How Debezium CDC Solved It
wwr0ngn4m3 profile

Zero-Downtime MariaDB PostgreSQL Migration: Why the Usual Tools Fell Short, and How Debezium CDC Solved It

#database #dataengineering #devops #postgres
Comments
9 min read
SQL Queries Every SaaS Founder Should Know
vivekdraxlr profile

SQL Queries Every SaaS Founder Should Know

#sql #database #analytics #tutorial
Comments
7 min read
Day 29 of 100 Days of ClickHouse® - Understanding Distributed Tables
kanishga_subramani_49ad73 profile

Day 29 of 100 Days of ClickHouse® - Understanding Distributed Tables

#analytics #clickhouse #database #dataengineering
2
Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.