[Live Migration] PostgresSQL compatible DistributedSQL databases with Denis Magda

Hey Everyone, In this episode of The GeekNarrator podcast, I am joined by Denis Magda from YugabyteDB, who has vast experience in the world of Distributed databases. He has explained Postgres compatibility and its types in depth. More interestingly, we have demonstrated how applications can be migrated from a vanilla Postgres to a PostgresSQL compatible distributed database. We have taken 4 databases for the demo Google Spanner, Amazon Aurora, CockroachDB and YugabyteDB. Here is the agenda: 00:00 Introduction 04:20 Why is PostgresSQL so popular? 12:45 What does PostgresSQL compatibility mean? 16:20 What are the different compatibility levels? 26:30 How does the migration work at a high level? 34:30 Demo time : Google Spanner, CockroachDB, Amazon Aurora and YugabyteDB 01:12:15 When should you use PostgresSQL vs Postgres compatible databases? References: Denis Magda: https://www.linkedin.com/in/dmagda/ Book recommendations from Denis to understand Database Internals Designing Data-Intensive Applications: https://www.amazon.com/Designing-Data-Intensive-Applications-Reliable-Maintainable/dp/1449373321 Database Internals: https://www.amazon.com/Database-Internals-Deep-Distributed-Systems/dp/1492040347 Architecting for scale: https://www.amazon.com/Architecting-Scale-Maintain-Availability-Manage/dp/1492057177/ Please don't forget to hit the like button if you liked this video and please subscribe to the channel. Cheers, The GeekNarrator