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.
Database Scaling, Explained by Breaking Things: Indexing, Replication, Caching

Interactive simulators let you break systems first

Database Scaling, Explained by Breaking Things: Indexing, Replication, Caching

15
Comments 5
5 min read
Rate Limiting Isn't One Layer: What LogicVisor and Titan Actually Do Differently

Rate Limiting Isn't One Layer: What LogicVisor and Titan Actually Do Differently

Comments 2
5 min read
Conductor: PostgreSQL-Backed Async Task Queue for Python (No Redis Required)

Conductor: PostgreSQL-Backed Async Task Queue for Python (No Redis Required)

1
Comments
4 min read
MySQL Will Quietly Eat Your Data If You Let It: Truncation, Charsets, and the 1366 You Never See

MySQL Will Quietly Eat Your Data If You Let It: Truncation, Charsets, and the 1366 You Never See

2
Comments
6 min read
Our Background Jobs Exhausted the Database Pool. Then the API Stopped Working.

Our Background Jobs Exhausted the Database Pool. Then the API Stopped Working.

Comments 2
5 min read
Adding an index made my query slower. Here's why.

Adding an index made my query slower. Here's why.

Comments 1
3 min read
Optimizing ASP.NET + EF6 for Bulk Insertion and Massive Data Selection: A Practical Guide

Optimizing ASP.NET + EF6 for Bulk Insertion and Massive Data Selection: A Practical Guide

Comments
10 min read
How I Built a $0/Month Ecommerce MVP Without Shopify

How I Built a $0/Month Ecommerce MVP Without Shopify

Comments
2 min read
The text-to-SQL demo takes an afternoon. The other 90% is why you should buy it.

The text-to-SQL demo takes an afternoon. The other 90% is why you should buy it.

Comments 1
3 min read
A Straightforward Guide for MVCC in MySQL

A Straightforward Guide for MVCC in MySQL

7
Comments 2
8 min read
MariaDB 12 Broke Our Concurrent Updates: Debugging ERROR 1020 After an Upgrade

MariaDB 12 Broke Our Concurrent Updates: Debugging ERROR 1020 After an Upgrade

Comments 2
2 min read
MongoDB Aggregation Pipelines: Stage Order Is the Win

MongoDB Aggregation Pipelines: Stage Order Is the Win

Comments 2
3 min read
How Do You Delete Billions of WhatsApp Statuses Every Day Without Bringing Your Database to Its Knees?

How Do You Delete Billions of WhatsApp Statuses Every Day Without Bringing Your Database to Its Knees?

3
Comments
9 min read
Your companies table is lying to you about when things happened

Your companies table is lying to you about when things happened

Comments
2 min read
Demystifying Connection Pooling: How to Stop Crashing Your Database

Demystifying Connection Pooling: How to Stop Crashing Your Database

Comments 2
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.