Syntax - Tasty Web Development Treats 839: Prisma ORM: Local First, Typed SQL Queries and Serverless with Søren Bramer Schmidt
7 snips
Oct 25, 2024 
Søren Bramer Schmidt, Founder and CEO of Prisma, shares fascinating insights into database management. He discusses the transition of Prisma from a GraphQL tool to a powerful ORM, emphasizing best practices for serverless setups. Søren delves into the importance of type safety with Typed SQL and the challenges of local-first development, illustrating how it enhances user experience. He explores the potential of Cloudflare against AWS, and the need for better database performance in distributed systems. Get ready for a deep dive into the future of database tools!
AI Snips
Chapters
Transcript
Episode notes
GraphQL's Role
- GraphQL brought standardization and tooling improvements to data querying.
- It's helpful for large organizations but can be heavyweight for simpler projects.
Missing Index Anecdote
- Syntax.fm forgot an index on their show number field, causing slow queries.
- Prisma's linter later highlighted the missing index.
Retailer's Missing Index
- A major US retailer experienced site crashes during traffic spikes.
- The issue was a missing index on their sessions table.