/Database

Database Design For Google Calendar: A Tutorial

- Alexey Makhotkin tl;dr: “In this database design tutorial I’m going to show how to design the database tables for a real-world project of substantial complexity. We’ll design a clone of Google Calendar. We will model as much as possible of the functionality that is directly related to the calendar.”

featured in #587

Database Design For Google Calendar: A Tutorial

- Alexey Makhotkin tl;dr: “In this database design tutorial I’m going to show how to design the database tables for a real-world project of substantial complexity. We’ll design a clone of Google Calendar. We will model as much as possible of the functionality that is directly related to the calendar.”

featured in #586

Database Sharding Explained

- Mahdi Yusuf tl;dr: Mahdi discusses when to use it, how it can be set up, why we shard data stores and various options you have before sharding.

featured in #584

Migrating Billions Of Records: Moving Our Active DNS Database While It’s In Use

- Alex Fattouche Corey Horton tl;dr: “When initially measured in 2022, DNS data took up approximately 40% of the storage capacity in Cloudflare’s main database cluster (cfdb). This database cluster, consisting of a primary system and multiple replicas, is responsible for storing DNS zones, propagated to our data centers in over 330 cities via our distributed KV store.” 

featured in #565

Things You Should Know About Databases

- Mahdi Yusuf tl;dr: "So, without fully getting into the weeds on database-specific quirks, I will cover everything you should understand about RDBMS indexes. I will touch briefly on transactions and isolation levels and how they can impact your reasoning about specific transactions."

featured in #553

Dealing With Large Tables

- Benjamin Dicken tl;dr: “Large databases often have a small number of very large tables that makes scaling difficult. How can you scale with these while keeping your database performant? This article covers vertical scaling, vertical sharding and horizontal sharding.”

featured in #550

B-trees And Database Indexes

- Benjamin Dicken tl;dr: “By the time you finish this article, you'll have learned how B-trees and B+trees work, why databases use them for indexes, and why using a UUID as your primary key might be a bad idea.”

featured in #549

Speed Up Your App By Caching Database Queries

- Jon Harrell tl;dr: Users demand speed and efficiency. Caching database queries can significantly improve your app's performance. Discover how to use caching to get lightning-fast load times and a smooth user experience for all of your users globally, no matter where your database lives.

featured in #541

The Best Engineering Interview Question I’ve Ever Gotten, Part 1

- Arthur O’Dwyer tl;dr: "It’s been a while since I was on the receiving end of a software engineering interview. But I still remember my favorite interview question. It was at MemSQL circa 2013... Since MemSQL was a database company, this is a database challenge."

featured in #536

The Best Engineering Interview Question I’ve Ever Gotten, Part 1

- Arthur O’Dwyer tl;dr: "It’s been a while since I was on the receiving end of a software engineering interview. But I still remember my favorite interview question. It was at MemSQL circa 2013... Since MemSQL was a database company, this is a database challenge."

featured in #535