Ben Dicken

@BenjDicken • 48,681 subscribers

databases → @planetscale videos → https://t.co/J5soMyf6XC writing → https://t.co/YpfkF0JaV8

Shorts

2,446,399 views

4,026,453 views

291,039 views

1,474,797 views

122,377 views

340,136 views

36,771 views

13,264 views

Videos

sweetdream.ai

Watch Anya Live

Anya is streaming live right now! Join her private show and enjoy exclusive content.

Private Show

Join now for exclusive access

Free preview available • Premium content

964,870 views • 1 month ago

8,640,047 views • 1 year ago

474,309 views • 1 month ago

759,536 views • 1 month ago

416,734 views • 1 month ago

122,484 views • 12 days ago

379,625 views • 1 month ago

1,372,858 views • 6 months ago

686,841 views • 5 months ago

232,776 views • 2 months ago

62,440 views • 16 days ago

1,422,492 views • 1 year ago

44,437 views • 12 days ago

74,926 views • 21 days ago

146,757 views • 1 month ago

502,700 views • 8 months ago

62,041 views • 27 days ago

389,858 views • 6 months ago

236,756 views • 3 months ago

77,250 views • 1 month ago

Live Cam

Ben Dicken

Shorts

Whoah he's right.

oops did it again

How do you make 768 servers look like 1? The answer is sharding. I wrote about *why* it's needed and *how* it's achieved for Postgres and MySQL. It's a fun one. Link below.

You asked for it, so here it is. Visualizing CPU cache speeds relative to RAM. Cache optimization is important too!

S3 transitioned from eventual consistency to strong consistency. No downtime required, across exabytes of data. "if something happens only once in a billion requests, that means it happens multiple times per day within S3" Werner has a great article on the process (link below)

Been working on this for 2 months, and it's finally ready to share! This piece not only *describes* how B-trees and database indexes work, but gives you the opportunity to interact with them, reinforcing the concepts, and providing a bit of fun along the way. Link in thread.

Fast backups at-scale are made possible by sharding. These require an amazing amount of engineering to nail the infrastructure, orchestration, and reliability. I wrote all about it... with the help of some PlanetScale database geniuses, of course!

1 of N reasons why sharding is a great way to scale a database? Backup speed. This is one of the fun little animations I worked on in my recent interactive sharding article. In case you missed it, link below.

Videos

Watch Anya Live

So many S3 performance misunderstandings. Let me clear this up for you all.

Daniel clearly hasn't seen the language balls.

I don't think you understand the magnitude of this situation. Let me explain.

I don't think you understand the magnitude of this situation. Let me explain.

I don't think you understand the magnitude of this situation. Let me explain.

It's time to stop using slow programming languages. I don't think you understand the magnitude of this situation. Let me explain.

Everyone should know how WALs work. Not sure where to start? Write-ahead logs 101:

In case you forgot how good we have it with M.2 NVMe SSD.

FYI physics is still physics. NVMe is fast. Felt like a good day to update you all on this

Most of us don't have access to multi-million dollar NVIDIA gpu sleds (if you do, hit me up). But I wanted to learn how they work, so i build a 3d guide! Unified GPU / CPU systems like this are what's powering all these mega-ai DCs. Incredible what educational tools you can build with llms.

I am once again begging you to put your database servers and application servers in the same region.

The Excalidraw mcp is sick. Have it live draw explanations (with pencil sounds and all) then pop open to the app and make your own changes. Learning with ai is so fun. (Also, don't stop learning, your brain is too valuable)

As a relative F1 noob, the rules around car construction were confusing. So I built a tool to teach me. Each part has restrictions on what teams can and cannot customize + what is and isn't proprietary, etc, etc. Hard to navigate for newcomers. A visual guide.

Breaking: DHH follows Theo - t3.gg. World peace ensues. But seriously Lex Fridman consider this my vote for getting Theo on the show 👀

Ensuring everyone really understands.

Reminder that your benchmark latencies don't mean anything if I don't know precisely where the client and server are located.

tuitter - twitter for your terminal

There's a million reasons why your app can be slow. The stack of software and hardware beneath are complex. Pinning down performance issues is challenging (but also, fun!) A clip from the chapter 1 stream. More to come this week.

How do you make 768 servers look like 1? The answer is sharding. I wrote about why it's needed and how it's achieved for Postgres and MySQL. It's a fun one. Link below.

Been working on this for 2 months, and it's finally ready to share! This piece not only describes how B-trees and database indexes work, but gives you the opportunity to interact with them, reinforcing the concepts, and providing a bit of fun along the way. Link in thread.