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.
Mariabackup tutorial — Using Mariabackup for hot physical backups of MariaDB

Mariabackup tutorial — Using Mariabackup for hot physical backups of MariaDB

1
Comments
11 min read
JOIN FETCH can be slower than N+1: a reproducible Doctrine benchmark (+ 1-row-per-entity JSON aggregation)

JOIN FETCH can be slower than N+1: a reproducible Doctrine benchmark (+ 1-row-per-entity JSON aggregation)

1
Comments 2
2 min read
From System Transactions to User Transactions in SQLite

From System Transactions to User Transactions in SQLite

21
Comments
4 min read
Looking for collaborators to build a developer tool (Vizora)

Looking for collaborators to build a developer tool (Vizora)

2
Comments 3
1 min read
From Documents to Relations: A Complete Guide to Migrating MongoDB to Supabase at Scale

From Documents to Relations: A Complete Guide to Migrating MongoDB to Supabase at Scale

12
Comments
19 min read
Journals Beyond the Basics in SQLite

Journals Beyond the Basics in SQLite

24
Comments
4 min read
Data Granularity: The Hidden Factor Behind AI Testing Quality

Data Granularity: The Hidden Factor Behind AI Testing Quality

Comments
8 min read
Azure Cosmos DB vNext Emulator: Query and Observability Enhancements

Azure Cosmos DB vNext Emulator: Query and Observability Enhancements

Comments
10 min read
Scaling the Data Layer in Distributed Systems

Scaling the Data Layer in Distributed Systems

1
Comments
4 min read
Understanding Database Indexes: How They Work and When They Hurt Performance

Understanding Database Indexes: How They Work and When They Hurt Performance

Comments
6 min read
From Journals to Transactions: How SQLite Executes Work Safely

From Journals to Transactions: How SQLite Executes Work Safely

18
Comments
3 min read
5 Surprising Truths About Your SQL SELECT Query (And Why They Matter)

5 Surprising Truths About Your SQL SELECT Query (And Why They Matter)

1
Comments
4 min read
Navigating Database Trends: NoSQL, PostgreSQL, & Beyond for Modern Data

Navigating Database Trends: NoSQL, PostgreSQL, & Beyond for Modern Data

Comments
4 min read
🚀 Scaling to 93K RPM: Moving Quota Management from SQL to Redis

🚀 Scaling to 93K RPM: Moving Quota Management from SQL to Redis

Comments 1
3 min read
SQL Aggregations Finally Made Sense: GROUP BY, HAVING, MIN, MAX, AVG

SQL Aggregations Finally Made Sense: GROUP BY, HAVING, MIN, MAX, AVG

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