Programming Throwdown
Programming Throwdown
Patrick Wheeler and Jason Gauci
152: The Future Database with Sam Lambert
1 hour 33 minutes Posted Feb 27, 2023 at 4:00 pm.
Introductions00:02:34 Sam’s Github learning lesson00:07:08 The day after00:10:57 Getting started with databases00:14:21 Schema change difficulties00:19:47 Database transactions00:31:15 Why data recovery matters00:38:35 Planetscale00:49:24 Greetings from the past01:02:01 How Jason discovered Planetscale01:06:53 Branching01:14:00 The vision for Planetscale01:18:12 The rationale behind Planetscale’s work setup01:24:29 Careers at Planetscale01:28:06 Amp It Up01:33:10 FarewellsResources mentioned in this episode:Links:Sam Lambert:Linkedin: https://www.linkedin.com/in/isamlambert/PlanetScale:Website: https://planetscale.com/Twitter: https://twitter.com/planetscaledataLinkedin: https://www.linkedin.com/company/planetscale/Github: https://github.com/planetscaleCareers: https://planetscale.com/careersAmp It Up (Amazon):Paperback: https://www.amazon.com/Amp-Unlocking-Hypergrowth-Expectations-Intensity/dp/1119836115Audiobook: https://www.amazon.com/Amp-Hypergrowth-Expectations-Increasing-Elevating/dp/B09QBRBKFB/If you’ve enjoyed this episode, you can listen to more on Programming Throwdown’s website: https://www.programmingthrowdown.com/Reach out to us via email: [email protected] You can also follow Programming Throwdown on Facebook | Apple Podcasts | Spotify | Player.FM  Join the discussion on our DiscordHelp support Programming Throwdown through our Patreon
Database Horror Stories
Moving Beyond Blame
Sam's Career Journey
The Challenge of Schema Changes
The Open Source Status of MySQL
The Role of Database Locking
Why Data Recovery Matters
The Maturity of MySQL
Career Path from GitHub to PlanetScale
The Mechanics of Sharding
Overcoming Query Complexity with Materialization
dbt and PlanetScale Boost
The technology behind Boost
The inevitability of sharding
The power of database branching
Branching as a Tool for Data Seeding
The Value of Schema Design
Introduction to Stored Procedures
The Vision for PlanetScale
The Nuances of Remote vs. In-Office Work
Careers at PlanetScale
Closing Remarks and PlanetScale Promotion
0:00
1:33:51
Download MP3
Show notes
Databases are key to almost any project, large or small.  Most database systems in the cloud are designed for heavy use and the costs can get expensive quickly, but database-as-a-service is a rapidly growing area, where many databases can share the same hardware for a much reduced rate, or even for free!  Sam Lambert, CEO of PlanetScale, joins Jason and Patrick to discuss database-as-a-service.00:01:41 Introductions00:02:34 Sam’s Github learning lesson00:07:08 The day after00:10:57 Getting started with databases00:14:21 Schema change difficulties00:19:47 Database transactions00:31:15 Why data recovery matters00:38:35 Planetscale00:49:24 Greetings from the past01:02:01 How Jason discovered Planetscale01:06:53 Branching01:14:00 The vision for Planetscale01:18:12 The rationale behind Planetscale’s work setup01:24:29 Careers at Planetscale01:28:06 Amp It Up01:33:10 FarewellsResources mentioned in this episode:Links:Sam Lambert:Linkedin: https://www.linkedin.com/in/isamlambert/PlanetScale:Website: https://planetscale.com/Twitter: https://twitter.com/planetscaledataLinkedin: https://www.linkedin.com/company/planetscale/Github: https://github.com/planetscaleCareers: https://planetscale.com/careersAmp It Up (Amazon):Paperback: https://www.amazon.com/Amp-Unlocking-Hypergrowth-Expectations-Intensity/dp/1119836115Audiobook: https://www.amazon.com/Amp-Hypergrowth-Expectations-Increasing-Elevating/dp/B09QBRBKFB/If you’ve enjoyed this episode, you can listen to more on Programming Throwdown’s website: https://www.programmingthrowdown.com/Reach out to us via email: [email protected] You can also follow Programming Throwdown on Facebook | Apple Podcasts | Spotify | Player.FM  Join the discussion on our DiscordHelp support Programming Throwdown through our Patreon
★ Support this podcast on Patreon ★