Franck Pachot: Postgres, ACID, Transactions, NoSql, Distributed SQL, YugabyteDB | archill podcast #7
Franck has been in database industry for about 30 years now. He's worked at places like IBM, Air France and CERN. Currently Franck is a developer advocate at Yugabyte, a company behind YugabyteDB, the open source, distributed SQL database for mission-critical applications.
PODCAST INFO:
Podcast website: https://archillpodcast.buzzsprout.com
Apple Podcasts: https://podcasts.apple.com/us/podcast...
Spotify: https://open.spotify.com/episode/6bl3...
Deezer: https://deezer.page.link/euptvDuP39X5...
OUTLINE:
00:00 Intro
00:52 Database Evolution
02:10 Databases 20 Years Ago
06:30 How Postgres Stores Data
10:08 How Select Works In Postgres
13:20 How Select Works With Index
15:13 Atomicity In ACID
19:31 Consistency In ACID
20:45 Isolation In ACID
21:34 Durability In ACID
22:26 ACID Real Example, Optimistic And Pessimistic
25:36 Transactions, Redo Logs
31:35 Relational vs NoSql
38:01 How NoSql Stores Data
41:50 ACID In NoSql
44:32 What Are Distributed Databases?
48:05 Use Cases Of Distributed Databases
54:31 Multi-Region Distributed Database
56:51 Architecture Of YugabyteDB
01:04:23 Indexes In YugabyteDB
01:09:10 Summary
🔗 CONNECT WITH US:
Archil Sharashenidze on LinkedIn: / archil-sharashenidze
Franck Pachot on LinkedIn: / franckpachot