Changelog

QueryRaw performance improvements

We’ve changed the response format of queryRaw to decrease its average size, which reduces serialization CPU overhead. Here’s a peek at the results measuring before and after the improvements.

When querying large data sets, we expect you to see improved memory usage and up to 2x performance improvements, as you can clearly see in the graphs. We are very excited to introduce these improvements in our latest 5.17.0 release!

VSCode extension improvements

In 5.17, we introduced some quality of life improvements for our VS Code extension, which makes interacting with it so much better!

Some of the additions were:

• Find references across schema files
• Added context on hover
• Additional quick fixes

Find out more in our latest release notes.

Going beyond Prisma ORM

Already building with Prisma ORM? Explore how Prisma Accelerate and Prisma Pulse help you develop faster, more scalable applications with real-time features your users are looking for in our new docs page: Going Beyond Prisma ORM.

We take a look at common problems that arise as you're building applications, and how Accelerate and Pulse take your application to the next level after the Prisma ORM.

Check how Solin uses Prisma Accelerate to serve 2.5M database queries per day

Solin, a leading fitness marketplace for creators, has improved its platform by integrating Prisma Accelerate. This story highlights how Prisma Accelerate has contributed to Solin's success by enhancing performance and reliability with its scalable connection pool and global database cache.

Check out our blog post and learn more about their architecture and the fantastic results they have obtained with Accelerate!

Cloud connectivity report

As we run on AWS & Cloudflare, we collect extensive latency data between them. We think you'll find this data as interesting as we do, so we’re excited to share our 1st annual Cloud Connectivity report!

Read the report here and dive into all the nitty gritty about latency with us.

Omit model fields globally

In 5.13.0, we introduced Preview support for the omit option within the Prisma Client query options. Now, we’re more than happy to announce that we’re expanding the omitApi Preview feature to also include the ability to omit fields globally.

Here's an example how you’re able to define fields to omit when instantiating Prisma Client either locally or globally:

Read more in our latest blog post.

Changes to prismaSchemaFolder preview feature

To continue improving our multi-file schema support, we have a few breaking changes to the prismaSchemaFolder feature:

When using relative paths in Prisma Schema files with the prismaSchemaFolder feature, a path is now relative to the file it is defined in rather than relative to the prisma/schema folder.

We realized that during migration many people would have prisma/schema as well as prisma/schema.prisma. Our initial implementation looked for a .prisma file first and would ignore the schema folder if it exists. This is now an error.

GitHub or Google... 🤔

With the new Google authentication option, the choice is yours when signing in on http://console.prisma.io.

Stay tuned for more authentication options!

Achievement Unlocked: Compliance for SOC2 Type II, HIPAA, GDPR, and ISO27001

Prisma has successfully implemented processes and controls required for SOC2 Type II, HIPAA, GDPR, and ISO 27001:2022 certifications. These accomplishments demonstrate our commitment to providing secure and reliable software solutions for developers working with databases.

Read more in our blog post.

🚀 Introducing the Prisma Nuxt module

Simplify setting up Prisma ORM in your Nuxt app and explore Prisma Studio in Nuxt Dev tools. Read more in our blog post.

Prisma badges are now available

Built something awesome with Prisma? 🌟 Show it off with these badges, perfect for your readme or website. Learn more about embedding the badges.

Introducing Delivery Guarantees for Database Change Events

Pulse makes it easy to build event-driven apps by letting you react to changes in your database. Thanks to its new event persistence feature, all database change events are now guaranteed to be delivered at least once and in the right order!

Interested in learning more and trying Pulse for yourself? Dive into our blog post and get started!

Organize your Prisma Schema into Multiple Files in v5.15

We are excited to introduce a new Preview feature in Prisma ORM: the ability to organize your Prisma Schema into multiple files. This highly requested feature is now available in our 5.15.0 release!

Learn how it works in our latest blog post, and try it out yourself. Happy coding!

Bringing Prisma ORM to React Native and Expo

Have you considered building React Native apps using Prisma and Expo? Well, Prisma ORM now provides Early Access support for React Native and Expo, fulfilling a popular community request!

Check out our blog post and public repo to get started!

Prisma Insider Program

We are happy to announce the launch of the Prisma Insider Program! Get early access to features, provide invaluable feedback, and play a key role in the development of Prisma’s commercial products.

👉 Check the details in our blog post. Follow this link to apply and tell us why you’d be a great fit for the Prisma Insider Program.

Connection Pooling for High-Traffic Apps

Connection pooling is crucial to ensure your data-driven app can handle massive loads without failure. Our blog post explores how connection pooling can save your e‑commerce platform during peak traffic, such as Black Friday.

How Per-Query Caching Keeps your App Fast

Find out how caching database queries can save you time and complexity and make your app run smoother and faster.

📚 Learn about the benefits of caching, when to use it, and how easy it is to set up with Prisma Accelerate in our blog post.

New product announcement: Prisma Optimize 🔍

Ever wondered what SQL the Prisma ORM generates under the hood? Want to understand the performance of your app and deliver a better and faster experience for your users? With Prisma Optimize you can!

🎥 Watch our video walkthrough using dub.co as a case study.

Read the announcement blog post for instructions on how to get started and optimize your own application.

Introducing new Prisma client query: createManyAndReturn()

In our 5.14.0 release, we made available a new, top-level Prisma Client query: createManyAndReturn(). It works similarly to createMany() but uses a RETURNING clause in the SQL query to retrieve the records that were just created.

Here’s an example of creating multiple posts and then immediately returning those posts.

Read more in our release notes

MongoDB performance improvements

Previously, Prisma ORM suffered from performance issues when using the in operator or when including related models in queries against a MongoDB database.

With 5.14.0, Prisma ORM now rewrites queries to use a combination of $or and $eq operators, leading to dramatic performance increases for queries that include in operators or relation loading.

See the closed public issues in our release notes.

Prisma ORM Benchmark

Curious to see how Prisma ORM performs with popular DB providers?

We’ve worked with Vercel to add ORMs to their open-source database latency benchmarks.

🚀 Run the test and see for yourself!

Documentation Updates

Explore Pulse’s features and use cases in our updated documentation and follow our get-started guide to set up Pulse in minutes.

In our Platform docs, we’ve refined the descriptions of Workspaces, Projects, and Environments and our billing information to make managing your projects and understanding your costs even easier.

Introducing our Build, Fortify, Grow Framework

Learn how Prisma products interoperate at each stage to enhance your data-driven application development process.

👉 Read up on the Prisma BFG framework

Discord is where it’s at! 🤖

As of 1 May 2024, we've transitioned from our community Slack to our Discord server. Join us over there to showcase your projects, get community support, or simply meet & chat with your fellow devs.

See you on Discord!

Introducing Static IP Support in Prisma Accelerate

Prisma Accelerate introduces Static IP support, enabling secure connections to your database with predictable IPs for controlled access and minimized exposure. This allows connections from Accelerate to databases requiring trusted IP access.

Learn more in our blog post, and try it out.

omit Fields From Prisma Client Queries (In Preview)

We’re excited to announce Preview support for the omit option within the Prisma Client query options. The highly-requested omit feature now allows you to exclude fields that you don’t want to retrieve from the database on a per-query basis.

Here is an example of using omit:

Many users have requested a global implementation of omit. This request will be accommodated in the future. In the meantime, you can follow the issue here.

Read more in our latest release notes

Doc Updates

The same docs that you know and love, but now built with Docusaurus! 🦖

👉 Enjoy an improved dark/light mode, search, layout, and Kapa AI experience.

Visit our Docs or peek under the hood at https://github.com/prisma/docs

Introducing Cloudflare D1 (Preview)

Exciting news! 5.12.0 release brings Preview support for Cloudflare D1 with Prisma ORM 🥳

D1 is Cloudflare's native serverless database and was initially launched in 2022. It's based on SQLite and can be used when deploying applications with Cloudflare. Cloudflare has recently announced launching D1 in GA and we couldn't be happier to be adding support and working with them on this new milestone.

Read more in our latest blog post.

Implementing createMany() for SQLite

Bringing support for createMany() in SQLite has been a long-awaited and highly requested feature ⭐

createMany() is a method on Prisma Client, released back in version 2.16.0, that lets you insert multiple records into your database at once. This can be really useful when seeding your database or inserting bulk data.

Read more in our latest release notes.

Platform Console Updates

We have refined our subscription management for a better UX experience.

Here are some cool new additions and improvements:

• We've added support for more payment methods and you can now manage your Tax Ids

• You can now see your invoice history and download past invoices.

Try it out at console.prisma.io

📚 Documentation

• Improved our getting started docs for Prisma Pulse and Railway

• Improved our troubleshooting guide for Prisma Accelerate, so you can more easily resolve common issues you might run into.

Stay in the Loop 🔍

• We’ll be at Epic Web Conference on April 11th, find us if you’re there!

• Plus, you can now follow our updates on our brand new WhatsApp channel. Join and get the Changelog news delivered straight to you.

Pulse in General Availability

We're thrilled to announce that Pulse has reached General Availability! This marks a significant milestone in our journey to redefine how developers interact with database-event driven compute.

Pulse is managed database-event infrastructure that simplifies database-event driven compute, making it easy to power real-time functionality, like chat, notifications, data broadcast, and more.

Pricing? Start for free with our usage-based pricing, designed to scale flexibly with your project.

👉 Check out our announcement blog post and documentation to learn more and get started.

Introducing Platform Environments

Platform Environments is a new feature of the Prisma Data Platform that lets users create different setups within one project. This helps smoothen out the app development process, from testing to going live.

Also, now you can access the Prisma Data Platform using the Prisma CLI, making it easier to manage your resources and workflow (currently in Early Access).

👉 Learn more in our blog post, and take it for a spin.

Prisma ORM Edge Functions Support in Preview

Prisma ORM now supports edge functions, allowing developers to access their databases using Prisma ORM from platforms such as Vercel Edge Functions, Vercel Edge Middleware, Cloudflare Workers, and Cloudflare Pages.

Edge functions improve app performance by reducing request latency and improving response times.

With the release of Prisma v5.11.0, developers can now use Prisma ORM with their favorite Node.js database drivers in edge functions, and the query engine's size has been reduced to fit the limited runtime environment.

If you want to understand what this exciting functionality brings as a whole, take a look at our blog post and go try it.

👉 Share your feedback with us via Twitter or Discord

Performance improvements in nested create operations

With Prisma ORM, you can create multiple new records in nested queries, for example:

In previous versions, Prisma ORM would translate this into multiple SQL INSERT queries, each requiring its own roundtrip to the database. As of this release, these nested create queries are optimized and the INSERT queries are sent to the database in bulk in a single roundtrip.

👉 Read more in our 5.11.0 release notes.

Join the Prisma Partner Network

At Prisma, we deeply value the talented creators, educators, and builders in our community and we’ve long wanted to reward their contributions.

We’re excited to launch the Prisma Partner Network with tailored opportunities for affiliates, tech partners, and resellers.

👉 prisma.io/partners

Made with Prisma

In our real-world interview series, we talk with founders who developed OSS projects using Prisma. Explore our recent chats:

🎥 Umami - The open source Google Analytics alternative

Did you ever feel that Google Analytics is too bloated and that its UI and workflows are too complex? Discover how Umami offers a simple yet powerful alternative analytics tool.

🎥 Dub.co: Aiming for a billion with Prisma

Steven Tey shares his journey from leaving Vercel to launching his startup. Learn how Dub.co began as a passion project, its technology stack, and an in-depth look at its codebase.