839: Prisma ORM: Local First, Typed SQL Queries and Serverless with Søren Bramer Schmidt

Key takeaways

Prisma has evolved from a GraphQL-centric tool to a robust, fully typed JavaScript ORM.
Understanding fundamental database practices is crucial to avoid common mistakes.
Serverless architectures present unique challenges with database interactions, which tools like Prisma's Accelerate can help address.
Typed SQL enhances the developer experience, combining raw SQL capabilities with type safety and schema-based autocompletion.
Prisma aims to make local first development mainstream, ensuring developers can utilize local databases with easy synchronization.
The upcoming hosted PostgreSQL service aims to provide a simpler database management experience for developers.

Summary

Prisma Overview and Evolution

Søren Bramer Schmidt discusses Prisma's journey from its early days as a GraphQL-first tool to its current status as a fully typed JavaScript ORM. He highlights the evolution of Prisma, mentioning the influence of GraphQL on its syntax while clarifying that Prisma has moved away from being solely a GraphQL-centric tool.

Common Database Mistakes and Best Practices

The conversation delves into prevalent mistakes developers make with databases, especially those unfamiliar with SQL principles. Common issues include omitting indexes and crafting overly complex queries that the database struggles to optimize. Søren emphasizes the importance of understanding fundamental database interactions to avoid such pitfalls.

Serverless Architecture Challenges

The discussion transitions to the challenges developers face when deploying applications using serverless architectures. In particular, issues related to database interactions emerge, including connection management and latency concerns. Solutions like Prisma’s Accelerate are proposed to mitigate some of these challenges.

Typed SQL and Developer Experience

Søren introduces the new Typed SQL feature, which provides enhanced safety and a better developer experience when crafting raw SQL queries. The feature supports autocompletion based on the schema, making it easier for developers to work with SQL while ensuring type safety.

Local First Development Paradigm

The concept of local first development surfaces in the latter part of the discussion where Søren outlines Prisma's objective to enable seamless, offline-first capabilities. By utilizing a sync engine, developers can create applications that rely on local data storage yet still maintain the ability to sync data across devices.

Future Directions for Prisma

Søren shares insights into Prisma’s roadmap, including the upcoming hosted PostgreSQL service, emphasizing the goal of simplifying database management for developers. He anticipates a shift towards local-first development and better tools for managing local databases.

Show notes

Scott and Wes talk with Søren Bramer Schmidt, Founder and CEO of Prisma, about database best practices, including the latest developments in serverless, local-first, and typed SQL solutions.
Show Notes 00:00 Welcome to Syntax!
02:55 Søren’s thoughts on GraphQL
03:53 Brought to you by Sentry.io

06:57 Common database mistakes
08:52 Prisma’s stability and user experience
10:42 Typed SQL and advanced querying Announcing TypedSQL: Make your raw SQL queries type-safe with Prisma ORM

Prisma Optimize

20:47 Serverless challenges and solutions Prisma Accelerate

27:11 Cloudflare’s potential to dethrone AWS
29:13 Prisma and local-first development Prisma & Expo: A Better Path to Local-First Apps | App.js Conf 2024

35:30 Making local-first development mainstream
40:10 Challenges with async
42:43 Søren’s thoughts on Drizzle

43:41 Søren’s favorite database
47:21 The read your writes problem
48:58 Prisma hosted Postgres
51:44 Sick Picks & Shameless Plugs
Sick Picks Søren: Cursor

Shameless Plugs Søren: 1: Prisma Optimize

2: Prisma Postgres (coming soon)

Hit us up on Socials! Syntax: X Instagram Tiktok LinkedIn Threads
Wes: X Instagram Tiktok LinkedIn Threads
Scott: X Instagram Tiktok LinkedIn Threads
Randy: X Instagram YouTube Threads