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.
How Discord Migrated Trillions of Messages and Fired Their Garbage Collector

How Discord Migrated Trillions of Messages and Fired Their Garbage Collector

Comments
10 min read
Shopify Sharded a Rails Database With Vitess and the App Never Knew It Happened

Shopify Sharded a Rails Database With Vitess and the App Never Knew It Happened

Comments
9 min read
How Stripe Moves Petabytes Between Database Shards Without Stopping the Money

How Stripe Moves Petabytes Between Database Shards Without Stopping the Money

Comments
9 min read
A Database Permission Change in ClickHouse Took Down 28% of Cloudflare's HTTP Traffic

A Database Permission Change in ClickHouse Took Down 28% of Cloudflare's HTTP Traffic

Comments
8 min read
Understanding SQL: DDL,DML,Filtering and DCL.

Understanding SQL: DDL,DML,Filtering and DCL.

Comments
2 min read
Why Your Database Is Lying to You (And How to Catch It)

Why Your Database Is Lying to You (And How to Catch It)

1
Comments
5 min read
SQL Subqueries vs CTEs: A Complete Guide for Data Analysts

SQL Subqueries vs CTEs: A Complete Guide for Data Analysts

1
Comments
7 min read
SQL Subqueries vs CTEs: What I Reach For When Writing Compliance and Reconciliation Queries

SQL Subqueries vs CTEs: What I Reach For When Writing Compliance and Reconciliation Queries

1
Comments
7 min read
Terra Sheild

Terra Sheild

Comments
6 min read
Shopify's Engineers Hunted Deadlocks at 19 Million Queries per Second

Shopify's Engineers Hunted Deadlocks at 19 Million Queries per Second

Comments
9 min read
Mastering the Basics: A Deep Dive into SQL Fundamentals

Mastering the Basics: A Deep Dive into SQL Fundamentals

Comments
2 min read
The Metadata Tree: How Apache Iceberg Finds the Right Files Without a Database

The Metadata Tree: How Apache Iceberg Finds the Right Files Without a Database

Comments
9 min read
Laravel Performance Optimization: 20 Quick Wins for Production Apps

Laravel Performance Optimization: 20 Quick Wins for Production Apps

Comments
8 min read
Avoiding range overlaps in PostgreSQL with EXCLUDE constraint, better than serializable or assertions

Avoiding range overlaps in PostgreSQL with EXCLUDE constraint, better than serializable or assertions

Comments 1
12 min read
Beginner’s Guide to SQL: DDL, DML, WHERE & CASE WHEN

Beginner’s Guide to SQL: DDL, DML, WHERE & CASE WHEN

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