Prisma: Modern Database Tooling with Johannes Schickling

A frontend developer issuing a query to a backend server typically requires the developer to issue that query through an ORM or a raw database query. Prisma is an alternative to both of these data access patterns, allowing for easier database access through auto-generated, type-safe query building tailored to an existing database schema.

By integrating with Prisma, the developer gets a database client that has query autocompletion, and an API server with less boilerplate code. Prisma also has a system called Prisma Migrate, which simplifies database and schema migrations.

Johannes Schickling is CEO of Prisma, and he joins the show to talk about the developments of Prisma that have occurred since we last spoke, and where the company is headed.

Sponsorship inquiries: sponsor@softwareengineeringdaily.com

Transcript

Transcript provided by We Edit Podcasts. Software Engineering Daily listeners can go to weeditpodcasts.com/sed to get 20% off the first two months of audio editing and transcription services. Thanks to We Edit Podcasts for partnering with SE Daily. Please click here to view this show’s transcript.


Sponsors

CockroachDB is a distributed SQL database that makes it simple to build resilient, scalable applications quickly. CockroachDB is Postgres compatible, giving the same familiar SQL interface database developers have used for years. Host it on prem, run it in a hybrid cloud, and even deploy it across multiple clouds. Sign up for a free 30-day trial and get a free t-shirt at cockroachlabs.com/sedaily.

O’Reilly lets you learn through high quality books, videos, courses, and interactive experiences. If you are an individual leveling up on your own, you can use O’Reilly to chart a course for your career goals. And if you manage a team or a company, you can get access to O’Reilly’s career development resources for your whole organization. Go to softwareengineeringdaily.com/oreilly to explore O’Reilly e-learning.

JFrog swampUP is an online user conference with 30+ sessions from cross-industry experts, including Google, Microsoft, Capital One, Adobe, and more. There will be tracks for Cloud-Native DevOps, Enterprise DevOps, DevSecOps, and Digital Transformation. Participate in expert DevOps training classes across DevOps tools, security, CI/CD, and more. Join from two time zones – June 23-24 for the Americas and June 30-July 1 for EMEA and APAC to suit daylight hours across the globe. Go to softwareengineeringdaily.com/swampUP to learn more and sign up. 

It’s hard to get engineering resources to build back-office apps, and even harder to get engineers excited about maintaining them. The idea is that all internal tools kinda look the same – they’re made of tables, dropdowns, buttons, text inputs, etc. Retool gives you a drag and drop interface so engineers can build these internal UIs in hours, not days, and spend more time building features customers will see. Visit retool.com/sedaily to learn more.