Enterprise Databases that Scale

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

▶ Watch on YouTube & Subscribe to CodingCat.dev

**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 or explore the architectural notes, chapters, and official documentation links below.

Questions

1. Since the last time you were on you have moved from Auth0 to Planet Scale
   1. Did you get any time to spend on yourself, your channel?
   2. How was the transition? It often take time to learn a whole new team and product.
2. What is Planetscale?
   1. What does the “scale of open source” mean?
   2. What is Vitess?
      1. What does Sharded MySQL mean?
   3. If this is serverless is it running on AWS or GCP?
3. Is Branching of a database just a copy?
4. Will running an ALTER for your schema require you to have downtime?
5. CLI
6. Pricing
7. Foreign Key Constraints
8. Using Prisma with Planetscale

Alex Patterson

Envato Elements Raycast

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 (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 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) and subscribe to CodingCat.dev on YouTube for weekly deep dives.

Video Chapters & Timestamps

Jump directly to any segment of Enterprise Databases that Scale on YouTube using the timestamped chapters below:

• 00:00: AM (EST)
• 00:00: Intro
• 00:00: James Q Quick Intro
• 00:00: Jumping into Database world
• 00:00: Learn Build Teach
• 00:00: PlanetScale Homepage
• 00:00: SQL serverless with PlanetScale
• 00:00: Vitess
• 00:00: Pricing
• 00:00: PlanetScale Demo
• 00:00: AWS Cloud Provider
• 00:00: Backup and Branch Strategy
• 00:00: SQL commands on GUI
• 00:00: Avoiding SQL breaking changes
• 00:00: Will PlanetScale support Postgress or other engines
• 00:00: ORM Object Relational Mapping
• 00:00: PlanetScale Branching Strategy and Prisma Migration
• 00:00: Wordpress with PlanetScale
• 00:00: Arctype SQL Client integration
• 00:00: Foreign Keys

Resources, Links & Official Documentation

• *Watch on YouTube: *Enterprise Databases that Scale Full Video (plus Subscribe to CodingCat.dev)
• *builder.io: *https://Builder.io
• *Show Pick: *Inventing Anna (picked by Brittney Postma)
• *Show Pick: *Sirens Streams - Planetscale with SvelteKit (picked by Brittney Postma)
• *Show Pick: *Sennheiser Professional MKE 400 (picked by James Q Quick)
• James Q Quick Guest Profile & Episodes on CodingCat.dev
• James Q Quick on GitHub
• Episode Sponsor: Builder.io
• PostgreSQL & SQL Official Documentation: Relational data modeling, indexing, joins, and ACID transactions
• Prisma ORM Documentation: Type-safe database client, schema migrations, and query optimization
• AWS Documentation & Builder Center: 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: 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: 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: 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 (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 on the CodingCat.dev YouTube channel. For a deeper dive into SQL, check out our related guide: Writing SQL in SQL Connect in Firebase: Web Architecture & Implementation Guide.