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.
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
You probably don't need a dedicated vector database (Use pgvector instead)

You probably don't need a dedicated vector database (Use pgvector instead)

1
Comments 5
6 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
The Hidden Race Condition Inside firstOrCreate()

The Hidden Race Condition Inside firstOrCreate()

1
Comments
2 min read
Daxon: Bringing a Complete Data Intelligence Workspace Into VS Code

Daxon: Bringing a Complete Data Intelligence Workspace Into VS Code

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