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.

OUTLINE:
00:00 Intro
00:52 Database Evolution
02:10 Databases 20 Years Ago
06:30 How Postgres Stores Data
10:10 How Select Works In Postgres 
13:20 How Select Works With Index
15:15 Atomicity In ACID
19:32 Consistency In ACID
20:46 Isolation In ACID
21:35 Durability In ACID
22:26 ACID Real Example, Optimistic And Pessimistic
25:37 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:30 Multi-Region Distributed Database 
56:50 Architecture Of YugabyteDB
01:01:46 Raft Consensus, Leader Election
01:04:22 Indexes In YugabyteDB
01:09:07 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/