200 | Creating Databases as Easily as Notion Pages with Prisma Postgres

Join Amy, Brad, and special guest Ryan Chenkie as they unpack Prisma's expanding ecosystem of database tools. Ryan explains why Prisma launched their own hosted Postgres service and what sets it apart from competitors in the space. The trio examines Prisma's comprehensive feature set including Accelerate for connection pooling, Pulse for real-time events, and optimization tools that help identify performance bottlenecks. They also discuss the upcoming transition from Rust to TypeScript for Prisma's core engine, making it lighter and faster. If you've been curious about modern approaches to database management or wondering which ORM is right for your next project, this conversation provides practical insights and expert perspectives.

Show Notes

0:00 - Intro

1:12 - Working with Prisma and Supabase

2:29 - Prisma Postgres Introduction

4:17 - Why Choose Postgres

6:36 - Prisma's Database Adapter Flexibility

8:14 - Serverless Database Architecture

11:13 - Connection Pooling with Accelerate

14:13 - Pulse for Real-time Database Events

16:54 - Studio Integration in Prisma Console

18:01 - Database Optimization Tools

20:00 - Benefits of Prisma Schema Language

22:10 - Prisma Schema vs SQL Definitions

23:01 - Comparing Prisma and Drizzle

26:24 - Future Improvements to Prisma

28:52 - Ryan's History with Prisma

32:05 - Learning Resources for Prisma

33:37 - Picks and Plugs

Links and Resources

Prisma Resources

• Prisma Website
• Prisma Twitter/X
• Prisma YouTube Channel
• Prisma Postgres Documentation
• Prisma Console
• Prisma VS Code Extension
• Prisma Accelerate
• Prisma Pulse
• Prisma Optimize
• Prisma Studio

Ryan Chenkie Resources

• Ryan's Website: https://holodeck.run
• Ryan's YouTube Channel: https://youtube.com/@holodeck_run
• Ryan on Twitter/X

Framework and Technologies Mentioned

• Remix
• Redwood JS
• Supabase
• PlanetScale
• Drizzle ORM
• Postgres
• MySQL
• MongoDB

Brad's Resources

• YouTube Channel: https://youtube.com/@bradgarropy
• Remix Starter: https://github.com/bradgarropy/remix-app

Amy's Resources

• Build12 Projects: https://buildtwelve.com

Other Resources Mentioned

• Skylight Frame
• Aura Frame
• Netflix Show: "Making Fun"
• Netflix Show: "Is It Cake"