How Shopify’s engineering improved database writes by 50% with ULID @hnasr
How Shopify’s engineering improved database writes by 50% with ULID  @hnasr
Uploaded December 2022 | Updated November 2026, 3 days ago
Fundamentals of Database Engineering udemy course (link redirects to udemy with coupon)
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)
backend.husseinnasser.com

Fundamentals of Networking for Effective Backends udemy course (link redirects to udemy with coupon)
network.husseinnasser.com

Fundamentals of Database Engineering udemy course (link redirects to udemy with coupon)
database.husseinnasser.com

Follow me on Medium
medium.com/@hnasr/membership


Introduction to NGINX (link redirects to udemy with coupon)
nginx.husseinnasser.com

Python on the Backend (link redirects to udemy with coupon)
python.husseinnasser.com

Become a Member on YouTube
youtube.com/channel/UC_ML5xP23TOWKUcc-oAE_Eg/join

Buy me a coffee if you liked this
buymeacoffee.com/hnasr

Arabic Software Engineering Channel
youtube.com/channel/UChWZsjdoRvZ0T9QWZOD6UpA

🔥 Members Only Content
youtube.com/playlist?list=UUMO_ML5xP23TOWKUcc-oAE_Eg



🏭 Backend Engineering Videos in Order
backend.husseinnasser.com

💾 Database Engineering Videos
youtube.com/playlist?list=PLQnljOFTspQXjD0HOzN7P2tgzu7scWpl2

🎙️Listen to the Backend Engineering Podcast
husseinnasser.com/podcast

Gears and tools used on the Channel (affiliates)

🖼️ Slides and Thumbnail Design
Canva
partner.canva.com/c/2766475/647168/10068


Stay Awesome,
Hussein
How Shopify’s engineering improved database writes by 50% with ULIDSQL is an API, its all about data storageA private file descriptor per processZero Copy File Transfer - Kernel TLSThe Cost of Memory FragmentationFundamentals of Operating SystemsPostgres is half as fast in Linux 7.0, and we always knew whyWhat happens before the Backend gets the RequestA Postgres Page can fit 291 rows on a single column tablering 3 to ring 0WebTransport is a Game Changer ProtocolSomeone is always getting blocked
Hussein Nasser |

How Shopify’s engineering improved database writes by 50% with ULID

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER