> Canonical URL: https://codingcat.dev/podcast/2-19-enterprise-databases-that-scale

# Enterprise Databases that Scale

🎧 Podcast Episode · S2E19May 11, 2022[![](/logos/tags/prisma-symbol-light.svg)![](/logos/tags/prisma-symbol-dark.svg)Prisma](/topic/prisma)[![](/logos/tags/sql-symbol-light.svg)![](/logos/tags/sql-symbol-dark.svg)SQL](/topic/sql)[![](/logos/tags/aws-symbol-light.svg)![](/logos/tags/aws-symbol-dark.svg)AWS](/topic/aws)[#Serverless](/topic/serverless)[![](/logos/tags/nextjs-symbol-light.svg)![](/logos/tags/nextjs-symbol-dark.svg)Next.js](/topic/nextjs)[![](/logos/tags/python-symbol-light.svg)![](/logos/tags/python-symbol-dark.svg)Python](/topic/python)[![](/logos/tags/builder-io-symbol-light.svg)![](/logos/tags/builder-io-symbol-dark.svg)Builder.io](/topic/builder-io)[![](/logos/tags/svelte-symbol-light.svg)![](/logos/tags/svelte-symbol-dark.svg)Svelte](/topic/svelte)

# Enterprise Databases that Scale

![](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/bc1237eb727c0f9e14f914e6ce24f88d45e2dc40-1920x1080.jpg?w=1920&h=1080&q=82&fit=max&auto=format)[@CodingCatDev62.5K / 100K Subscribers Goal](https://www.youtube.com/@codingcatdev?sub_confirmation=1)[Subscribe on YouTube→](https://www.youtube.com/@codingcatdev?sub_confirmation=1)[Watch on YouTube App ↗](https://www.youtube.com/watch?v=RTFMT9BKDIg&list=UUnKZ8gEb78zXKMi1ns-IQ2g)[![Alex Patterson](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/a606dfaa381aab08ddbe16a33fe1d3e1fb37c927-400x400.jpg?w=96&h=96&q=82&fit=max&auto=format)Alex Patterson](/author/alex-patterson)[![Brittney Postma](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/f25e504779cb6ebb7c0dd7df367f2c7490e17784-735x735.png?w=96&h=96&q=82&fit=max&auto=format)Brittney Postma](/author/brittney-postma)[![James Q Quick](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/bbb504849129a95ed2775009ba78cfc3452d1628-400x400.jpg?w=96&h=96&q=82&fit=max&auto=format)James Q Quick](/guest/james-q-quick)🎧 Listen & Subscribe[Spotify](https://open.spotify.com/episode/1NxZ13uIoifkIKCNSPEKiN)[Apple](https://podcasts.apple.com/us/podcast/2-19-enterprise-databases-that-scale/id1491655542?i=1000566573467)[YouTube](https://www.youtube.com/watch?v=RTFMT9BKDIg&list=PLUKgAjyG9B0ZhUEXp9eVa7h4L__FDW3uV)[Subscribe on YouTube (62.5K / 100K) →](https://www.youtube.com/@codingcatdev?sub_confirmation=1)[Pocket Casts](https://pca.st/episode/0de35b2f-68de-4f79-8b09-36ed4216a20d)[Castbox](https://castbox.fm/episode/id2508485-id505154128)[Castro](https://castro.fm/episode/Tm2HXY)[Overcast](https://overcast.fm/itunes1491655542)[RSS](https://anchor.fm/s/115b203c/podcast/rss)

## Episode Sponsors.

[![CodingCat.dev tutorial cover image](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/e355e7e90e37726637596011069c154ae515da9f-1200x675.png?w=1200&q=82&fit=max&auto=format)Partner & Sponsor

### Builder.io

Empower your entire team to visually create and optimize high-speed experiences on your sites and apps. Provide whole-team autonomy with a platform that is developer approved.](https://www.builder.io/?utm_source=codingcatdev)

**Enterprise Databases that Scale ** is a CodingCat.dev podcast episode featuring James Q Quick alongside Alex Patterson and Brittney Postma focused on SQL, Prisma, AWS. James Q Quick teaches us about how Planetscale's ability to infinitely scale SQL horizontally at the push of a button. Watch the full video breakdown on [**YouTube**](https://www.youtube.com/watch?v=RTFMT9BKDIg) or explore the architectural notes, chapters, and official documentation links below.

## Questions

- Since the last time you were on you have moved from Auth0 to Planet ScaleDid you get any time to spend on yourself, your channel?
- How was the transition? It often take time to learn a whole new team and product.

- What is Planetscale? What does the “scale of open source” mean?
- What is [Vitess](https://vitess.io/)?What does Sharded MySQL mean?

- If this is serverless is it running on AWS or GCP?

- Is Branching of a database just a copy?
- Will running an ALTER for your schema require you to have downtime?
- CLI
- Pricing
- Foreign Key Constraints
- Using Prisma with Planetscale

### Alex Patterson

[Envato Elements](https://elements.envato.com/) [Raycast](https://ray.so/)

## Technical Overview: Enterprise Databases that Scale

2.19 - Enterprise Databases that Scale, with Planetscale: James Q Quick teaches us about how Planetscale's ability to infinitely scale SQL horizontally at the push of a button. https://codingcat.dev/podcast/2-19-enterprise-databases-that-scale Sponsors
https://Builder.io
Empower your entire team to visually create and optimize high-speed experiences on y

When applying the concepts from **Enterprise Databases that Scale**  in a production codebase, teams working with SQL, Prisma, AWS, Serverless should align their implementation with the [**PostgreSQL & SQL Official Documentation**](https://www.postgresql.org/docs/) (Relational data modeling, indexing, joins, and ACID transactions). Structuring your workflow around repeatable patterns, automated verification, and clear separation of concerns helps prevent regressions as your application scales.

### Key Engineering Takeaways

- **Core Topic Focus: ** Practical strategies for SQL, Prisma, AWS, Serverless covered in "Enterprise Databases that Scale" (James Q Quick teaches us about how Planetscale's ability to infinitely scale SQL horizontally at the push of a button.).
- **Production Implementation: ** Combine the architectural patterns demonstrated in this podcast with the official [PostgreSQL & SQL Official Documentation](https://www.postgresql.org/docs/) for type safety, performance, and long-term maintainability.
- **Hands-On Video Walkthrough: ** Follow along with the live coding demos and discussion on [YouTube (Enterprise Databases that Scale)](https://www.youtube.com/watch?v=RTFMT9BKDIg) and subscribe to [CodingCat.dev on YouTube](https://www.youtube.com/@CodingCatDev?sub_confirmation=1) for weekly deep dives.

## Video Chapters & Timestamps

Jump directly to any segment of [**Enterprise Databases that Scale**](https://www.youtube.com/watch?v=RTFMT9BKDIg) on YouTube using the timestamped chapters below:

- [**00:00**](https://www.youtube.com/watch?v=RTFMT9BKDIg&t=0s): AM (EST)
- [**00:00**](https://www.youtube.com/watch?v=RTFMT9BKDIg&t=0s): Intro
- [**00:00**](https://www.youtube.com/watch?v=RTFMT9BKDIg&t=0s): James Q Quick Intro
- [**00:00**](https://www.youtube.com/watch?v=RTFMT9BKDIg&t=0s): Jumping into Database world
- [**00:00**](https://www.youtube.com/watch?v=RTFMT9BKDIg&t=0s): Learn Build Teach
- [**00:00**](https://www.youtube.com/watch?v=RTFMT9BKDIg&t=0s): PlanetScale Homepage
- [**00:00**](https://www.youtube.com/watch?v=RTFMT9BKDIg&t=0s): SQL serverless with PlanetScale
- [**00:00**](https://www.youtube.com/watch?v=RTFMT9BKDIg&t=0s): Vitess
- [**00:00**](https://www.youtube.com/watch?v=RTFMT9BKDIg&t=0s): Pricing
- [**00:00**](https://www.youtube.com/watch?v=RTFMT9BKDIg&t=0s): PlanetScale Demo
- [**00:00**](https://www.youtube.com/watch?v=RTFMT9BKDIg&t=0s): AWS Cloud Provider
- [**00:00**](https://www.youtube.com/watch?v=RTFMT9BKDIg&t=0s): Backup and Branch Strategy
- [**00:00**](https://www.youtube.com/watch?v=RTFMT9BKDIg&t=0s): SQL commands on GUI
- [**00:00**](https://www.youtube.com/watch?v=RTFMT9BKDIg&t=0s): Avoiding SQL breaking changes
- [**00:00**](https://www.youtube.com/watch?v=RTFMT9BKDIg&t=0s): Will PlanetScale support Postgress or other engines
- [**00:00**](https://www.youtube.com/watch?v=RTFMT9BKDIg&t=0s): ORM Object Relational Mapping
- [**00:00**](https://www.youtube.com/watch?v=RTFMT9BKDIg&t=0s): PlanetScale Branching Strategy and Prisma Migration
- [**00:00**](https://www.youtube.com/watch?v=RTFMT9BKDIg&t=0s): Wordpress with PlanetScale
- [**00:00**](https://www.youtube.com/watch?v=RTFMT9BKDIg&t=0s): Arctype SQL Client integration
- [**00:00**](https://www.youtube.com/watch?v=RTFMT9BKDIg&t=0s): Foreign Keys

## Resources, Links & Official Documentation

- **Watch on YouTube: ** [Enterprise Databases that Scale Full Video](https://www.youtube.com/watch?v=RTFMT9BKDIg) (plus [Subscribe to CodingCat.dev](https://www.youtube.com/@CodingCatDev?sub_confirmation=1))
- **builder.io: ** [https://Builder.io](https://builder.io/?utm_source=codingcatdev)
- **Show Pick: ** [Inventing Anna (picked by Brittney Postma)](https://www.netflix.com/title/81008305)
- **Show Pick: ** [Sirens Streams - Planetscale with SvelteKit (picked by Brittney Postma)](https://www.youtube.com/watch?v=iFhDwmI6OL0)
- **Show Pick: ** [Sennheiser Professional MKE 400 (picked by James Q Quick)](https://www.amazon.com/gp/product/B08YS3W16H/ref=ppx_yo_dt_b_asin_title_o00_s00?ie=UTF8&psc=1)
- [**James Q Quick Guest Profile & Episodes on CodingCat.dev**](/guest/james-q-quick)
- [**James Q Quick on GitHub**](https://github.com/jamesqquick)
- [**Episode Sponsor: Builder.io**](https://www.builder.io/?utm_source=codingcatdev)
- [**PostgreSQL & SQL Official Documentation:**](https://www.postgresql.org/docs/) Relational data modeling, indexing, joins, and ACID transactions
- [**Prisma ORM Documentation:**](https://www.prisma.io/docs) Type-safe database client, schema migrations, and query optimization
- [**AWS Documentation & Builder Center:**](https://docs.aws.amazon.com/) Cloud architecture, serverless compute, IAM, and managed services

## Related CodingCat.dev Tutorials & Podcast Episodes

- [**Writing SQL in SQL Connect in Firebase: Web Architecture & Implementation Guide**](/post/firebase-2026-03-fdc-native-sql): Hands-on web engineering breakdown of "Writing SQL in SQL Connect" (2026-03-24). Learn how to integrate Firebase, Google Cloud, Web Dev, SQL in production web a...
- [**Realtime PostgreSQL: From Data Connect to SQL Connect in Firebase: Web Architecture & Implementation Guide**](/post/firebase-2026-04-whats-new-sql-connect): Hands-on web engineering breakdown of "Realtime PostgreSQL: From Data Connect to SQL Connect" (2026-04-29). Learn how to integrate Firebase, Google Cloud, Web D...
- [**2023 Databases for Serverless Applications**](/post/2023-databases-for-serverless): Databases that work well with serverless applications in 2023

## Frequently Asked Questions (FAQ)

### What are the main takeaways from Enterprise Databases that Scale?

James Q Quick teaches us about how Planetscale's ability to infinitely scale SQL horizontally at the push of a button. 2.19 - Enterprise Databases that Scale, with Planetscale: James Q Quick teaches us about how Planetscale's ability to infinitely scale SQL horizontally at the push of a button. https://codingcat.dev/podcast/2-19-enterprise-databases-that-scale Sponsors
https://Builder.io
Empower your entire team to visually create and optimize high-speed experiences on y Throughout this podcast, James Q Quick breaks down real-world implementation details for SQL, Prisma, AWS so developers can apply these patterns directly in production.

### How do you implement SQL best practices in production?

When adopting SQL and Prisma in a production stack, start by validating your configuration against the [**PostgreSQL & SQL Official Documentation**](https://www.postgresql.org/docs/) (Relational data modeling, indexing, joins, and ACID transactions). Focus on incremental adoption, automated testing, and observability so your team can measure performance and developer velocity improvements at each stage.

### Where can I watch the full Enterprise Databases that Scale walkthrough and find related code resources?

You can watch the complete video session for [**Enterprise Databases that Scale**](https://www.youtube.com/watch?v=RTFMT9BKDIg) on the [**CodingCat.dev YouTube channel**](https://www.youtube.com/@CodingCatDev?sub_confirmation=1). For a deeper dive into SQL, check out our related guide: [**Writing SQL in SQL Connect in Firebase: Web Architecture & Implementation Guide**](/post/firebase-2026-03-fdc-native-sql).

## ✏️ Episode Summary

2.19 - Enterprise Databases that Scale, with Planetscale: James Q Quick teaches us about how Planetscale's ability to infinitely scale SQL horizontally at the push of a button.

https://codingcat.dev/podcast/2-19-enterprise-databases-that-scale

Sponsors
https://Builder.io
Empower your entire team to visually create and optimize high-speed experiences on y

✏️ Visual Architecture Diagram

## how this episode connects together.

Follow AJ from first principles to production-ready architecture.

Let’s build it!✏️ Visual Diagram: Enterprise Databases that Scale✓ Good PatternVISUAL DIAGRAM[Diagram Walkthrough]Step-by-step diagram breakdown for Enterprise Databases that Scale: start with James Q Quick, implement Architecture & Patterns, and ship to production.AAA Contrast Verified

## episode picks.

### 🐾 Alex Patterson

- [Envato Elements](https://elements.envato.com/)
- [Raycast](https://ray.so/)

### 🐾 Brittney Postma

- [Inventing Anna](https://www.netflix.com/title/81008305)
- [Sirens Streams - Planetscale with SvelteKit](https://www.youtube.com/watch?v=iFhDwmI6OL0)

### 🐾 James Q Quick

- [Sennheiser Professional MKE 400](https://www.amazon.com/gp/product/B08YS3W16H/ref=ppx_yo_dt_b_asin_title_o00_s00?ie=UTF8&psc=1)

## related episodes.

[All Episodes→](/podcasts)[![The Odin Project 7: Relational Databases, SQL Indexing & Drizzle ORM](https://cdn.sanity.io/images/hfh83o0w/production/7221b834f72684badf77c4365f36061506da9181-1376x768.png?w=1376&q=82&fit=max&auto=format)](/course/odin-databases-and-sql)November 4, 2026[![](/logos/tags/sql-symbol-light.svg)![](/logos/tags/sql-symbol-dark.svg)SQL](/topic/sql)[![](/logos/tags/cloudflare-symbol-light.svg)![](/logos/tags/cloudflare-symbol-dark.svg)Cloudflare](/topic/cloudflare)[![](/logos/tags/typescript-symbol-light.svg)![](/logos/tags/typescript-symbol-dark.svg)TypeScript](/topic/typescript)[+1](/course/odin-databases-and-sql)

### [The Odin Project 7: Relational Databases, SQL Indexing & Drizzle ORM](/course/odin-databases-and-sql)

Master relational schema normalization, Primary/Foreign keys, INNER/LEFT JOINs, B-Tree composite indexes, ACID transactions, and type-safe Drizzle ORM on Cloudflare D1.

[![Alex Patterson](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/a606dfaa381aab08ddbe16a33fe1d3e1fb37c927-400x400.jpg?w=96&h=96&q=82&fit=max&auto=format)Alex Patterson](/author/alex-patterson)[![Dockerless Serverless GPUs: How I Built a Fast, Cheap AI SaaS with RunPod Flash](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/78383c8986667bc1eaa504786488d88f212929a8-1280x720.jpg?w=1280&q=82&fit=max&auto=format)](/post/dockerless-serverless-gpus-fast-cheap-ai-saas-with-runpod-flash)October 6, 2026[#Serverless](/topic/serverless)[![](/logos/tags/cloudflare-symbol-light.svg)![](/logos/tags/cloudflare-symbol-dark.svg)Cloudflare](/topic/cloudflare)[![](/logos/tags/python-symbol-light.svg)![](/logos/tags/python-symbol-dark.svg)Python](/topic/python)[+5](/post/dockerless-serverless-gpus-fast-cheap-ai-saas-with-runpod-flash)

### [Dockerless Serverless GPUs: How I Built a Fast, Cheap AI SaaS with RunPod Flash](/post/dockerless-serverless-gpus-fast-cheap-ai-saas-with-runpod-flash)

Hosted image APIs cost 3 to 4 cents per generation. Using RunPod Flash for dockerless serverless GPUs, FlashFun.dev drops that to a fraction of a cent, turning $1 into 500 to 3,000 images. Here is the full architecture, the benchmarks, and the code.

[![Alex Patterson](https://cdn.sanity.io/media-libraries/mlttp0BZbCpV/images/a606dfaa381aab08ddbe16a33fe1d3e1fb37c927-400x400.jpg?w=96&h=96&q=82&fit=max&auto=format)Alex Patterson](/author/alex-patterson)