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/franck-pachot-postgres-acid-transactions-nosql-distributed/id1719654406?i=1000643782605
Spotify: https://open.spotify.com/episode/6bl3M7nHckdBuIjNVyOzZL?si=VhHFOlZuSQexK10h8q4cgw
Deezer: https://deezer.page.link/euptvDuP39X5aVgT9

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: https://www.linkedin.com/in/archil-sharashenidze/
- Franck Pachot on LinkedIn: https://www.linkedin.com/in/franckpachot/