Programming Throwdown

152: The Future Database with Sam Lambert

Feb 27, 2023

01:33:51

Creator website

Episode guests

Sam Lambert

Highlights

AI Chapters

Episode notes

MySQL - Foreign Key Constraints vs Foreign Keys

03:36

Using a Sharding Scheme in a Database?

02:24

PlanetScale CEO Sam Lambert on the Show

05:13

Introduction

2min

PlanetScale CEO Sam Lambert on the Show

5min

GitHub Outage - What Happened to You?

2min

Elpoint, What Was Your First Time Using a Database?

2min

My First Interaction With Databases

6min

The Problem With Online Schema Changes in Databases

2min

Why You Would Want a Database Transaction

2min

Is It Possible to Roll Back?

2min

Using Old Code to Deploy Databases

2min

10.

The Best Tool for the Job?

4min

11.

How Does MySQL Fail Over?

2min

12.

Postgres JSON Columns - A Great Idea

3min

13.

Is My SQL Really Open Source?

2min

14.

Plant Scowers - What Was It Like?

3min

15.

Scaling a MySQL Cluster?

4min

16.

The Benefits of Sharding

2min

17.

Using a Sharding Scheme in a Database?

2min

18.

DBT

2min

19.

PlanetScale Boost - A New Product Launched in May 2015

2min

20.

Re-Sharding for Tests

2min

21.

Is There a Way to Automate MySQL?

4min

22.

GitHub

4min

23.

PlanetScale

4min

24.

Getting Rid of Staging

2min

25.

MySQL - Foreign Key Constraints vs Foreign Keys

4min

26.

Are Stored Procedures a Good Idea?

3min

27.

XJS and the Stored Procedures

2min

28.

Why DBA's Don't Do What They Shouldn't Be Doing

2min

29.

Plant Scale - I Love It

3min

30.

Working Remote or Working in the Office?

4min

31.

Plant Scale Engineering - What Kind of Skillset Are You Looking For?

3min

32.

The Values of Planet Scale

3min

33.

Planet Scale Database - A Great Segue to Our Shameless Plug for Audible

3min

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 Introductions
00:02:34 Sam’s Github learning lesson
00:07:08 The day after
00:10:57 Getting started with databases
00:14:21 Schema change difficulties
00:19:47 Database transactions
00:31:15 Why data recovery matters
00:38:35 Planetscale
00:49:24 Greetings from the past
01:02:01 How Jason discovered Planetscale
01:06:53 Branching
01:14:00 The vision for Planetscale
01:18:12 The rationale behind Planetscale’s work setup
01:24:29 Careers at Planetscale
01:28:06 Amp It Up
01:33:10 Farewells

Resources mentioned in this episode:
Links:

Sam Lambert:
- Linkedin: https://www.linkedin.com/in/isamlambert/
PlanetScale:
- Website: https://planetscale.com/
- Twitter: https://twitter.com/planetscaledata
- Linkedin: https://www.linkedin.com/company/planetscale/
- Github: https://github.com/planetscale
- Careers: https://planetscale.com/careers
Amp It Up (Amazon):
- Paperback: https://www.amazon.com/Amp-Unlocking-Hypergrowth-Expectations-Intensity/dp/1119836115
- Audiobook: 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: programmingthrowdown@gmail.com

You can also follow Programming Throwdown on

Facebook | Apple Podcasts | Spotify | Player.FM

Join the discussion on our Discord

Help support Programming Throwdown through our Patreon

★ Support this podcast on Patreon ★

Remember Everything You Learn from Podcasts

Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.