Prisma 6: Better Performance, More Flexibility & Type-Safe SQL

submited by

Style Pass

2024-11-28 19:00:06

Today, we are releasing Prisma v6! Since the last major version, we have been hard at work incorporating user feedback, making Prisma ORM faster and more flexible, and adding amazing features like type-safe raw SQL queries.

We are excited to share that we've released another major version increment of Prisma ORM. We want to take this opportunity to recap everything that has happened since Prisma v5.

With our development of Prisma ORM, we have followed the "Make it work, make it right, make it fast" approach. Since the initial release in 2021, we have continuously invested in better query performance and are proud to share that we've been able to significantly improve query speed since last major release.

In principle, there are two different approaches when you need to query data from multiple tables that are related via foreign keys:

Depending on your use case, your database schema, and several other factors, one strategy may be more appropriate than the other. Up until Prisma ORM v5.7.0, Prisma ORM would always use the application-level JOIN strategy.