How Shopify’s engineering improved writes by 50% with ULID | The Backend Engineering Show - podcast episode cover

How Shopify’s engineering improved writes by 50% with ULID | The Backend Engineering Show

Dec 23, 202232 min
--:--
--:--
Download Metacast podcast app
Listen to this episode in Metacast mobile app
Don't just listen to podcasts. Learn from them with transcripts, summaries, and chapters for every episode. Skim, search, and bookmark insights. Learn more

Episode description

Fundamentals of Database Engineering udemy course (link redirects to udemy with coupon)

https://database.husseinnasser.com

Shopify posted a blog on tips to for scalable payment system, one tip peeked my interest related to switching from UUID to ULID. I explore the reasoning behind this in this video.

https://shopify.engineering/building-resilient-payment-systems

0:00 Intro

1:30 idempotency

6:30 UUID vs ULID

9:50 Clustered Index

13:30 Why UUID4 Inserts are slow

17:15 How ULID helps Shopify

22:00 Problem with tail pages

25:00 Does ULID help in all cases?

Fundamentals of Backend Engineering Design patterns udemy course (link redirects to udemy with coupon)

https://backend.husseinnasser.com

For the best experience, listen in Metacast app for iOS or Android