tubeshowcase●1,658,115 videos♡ My collection 0
← Learn to Code

Learn to Code18:55

How/Why to Sweep Async Tasks Under a Postgres Table | POSETTE 2024

Microsoft Developer ↗

From the creator

Video of a conference talk about how & why to sweep async tasks under a Postgres table presented by Taylor Troesh at POSETTE: An Event for Postgres 2024. Instead of returning hostile "500" errors to users, a small async worker query pattern makes fault-tolerant design the default. In this talk, we'll talk about (1) how backend/database design impacts frontend experience, (2) the pervasive insanity of hand-rolling two-phase commit, (3) Postgres as a platform, (4) how async DB queues form a natural complement to Jira, and (5) how the tiny async query pattern works, and (6) how to tweak the query for optimized parallelism, prioritization, and sampling. Taylor tinkers with writing, learning, time, design, software, ideas, humor, and entrepreneurship. Chapters: 00:00 The problem 02:23 async tasks under a postgres table 03:18 FOR UPDATE SKIP LOCKED 09:19 Postgres vs Alternatives 10:48 Implementing the worker 18:07 Conclusion 📕 Everything you need to know about POSETTE: An Event for Postgres 2024 can be found at: https://aka.ms/posette ✅ Learn more: Watch more POSETTE talks: https://aka.ms/posette-playlist-2024 📌 Let’s connect: X – @PosetteConf https://x.com/PosetteConf Mastodon - @posetteconf https://mastodon.social/@posetteconf Threads – @posetteconf https://www.threads.net/@posetteconf 🔔 Subscribe to the POSETTE News: https://aka.ms/posette-subscribe #PosetteConf #PostgreSQL #Database Presenters: Taylor Troesh, mayor of taylor.town

Published 2024-06-13 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.

Keep exploring Learn to Code