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.
PostgreSQL Credential Rotation, pgvector HALFVEC, & SQLite Type Affinity

PostgreSQL Credential Rotation, pgvector HALFVEC, & SQLite Type Affinity

Comments
3 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
How GitHub Upgraded 1200 MySQL Hosts Without Dropping a Single Query

How GitHub Upgraded 1200 MySQL Hosts Without Dropping a Single Query

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 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
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: 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
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
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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.