Prisma 5.11.0 — Release Notes & Engineering Impact

Today, we are excited to share the `5.11.0` stable release 🎉 🌟 **Help us spread the word about Prisma by starring the repo ☝️ or [posting on X](https://twitter.com/intent/post?text=Check%20out%20the%20latest%20%40prisma%20release%20v5.11.0%20%F0%9F%9A%80%0D%0A%0D%0Ahttps%3A%2F%2Fgithub.com%2Fprisma%2Fprisma%2Freleases%2Ftag%2F5.11.0) about the release.** ## Highlights ### Edge function support for Cloudflare and Vercel (Preview) We’re thrilled to announce that support for edge function deployments with Prisma ORM is now in Preview 🥳 As of this release, you can deploy your apps that are using Prisma ORM to: - Vercel Edge Functions and Vercel Edge Middleware - Cloudflare Workers and Cloudflare Pages In order to deploy to an edge function, you’ll need to use a compatible database driver (along with its [Prisma driver adapter](https://www.prisma.io/docs/orm/overview/databases/database-drivers#driver-adapters)): - Neon Serverless Driver (for PostgreSQL databases hosted via [Neon](https://neon.tech/)) - PlanetScale Serverless Driver (for MySQL databases hosted via [PlanetScale](https://planetscale.com/)) - `pg` driver (for traditional PostgreSQL databases) - `@libsql/client` driver (for SQLite databases hosted via [Turso](https://turso.tech/)) Check out our [documentation](https://www.prisma.io/docs/orm/prisma-client/deployment/edge/overview) to learn how you can deploy an edge function using any combination of supported edge function provider and database. You can also read more about it in the [announcement blog post](https://pris.ly/b/prisma-edge)! ### Performance improvements in nested `create` operations With Prisma ORM, you can create multiple new records in _nested_ queries, for example: ```ts const user = await prisma.user.update({ where: { id: 9 }, data: { name: 'Elliott', posts: { create: { data: [{ title: 'My first post' }, { title: 'My second post' }], }, }, }, }) ``` 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. These optimizations apply to one-to-many as well as many-to-many relations. With this change, using the nested `create` option to create multiple records effectively becomes equivalent to using a nested `createMany` operation (except that `createMany` _only_ works with one-to-many relations, whereas `create` works both with one-to-many and many-to-many). > **Note**: Only the deepest nested operation is optimized. If a user specified `create (1) -> create (2) -> create (3)` in their query, only `create (3)` will be optimized. ## Fixes and improvements ### Prisma Client - [Prisma errors when not using the major.minor.patch versioning system](https://github.com/prisma/prisma/issues/7317) - [mongodb where condition resulted in combined $ne but should not be $eq](https://github.com/prisma/prisma/issues/15175) - [Node hangs when `console.log(new PrismaClient())`](https://github.com/prisma/prisma/issues/18292) - [Add wolfy linux to supported OS](https://github.com/prisma/prisma/issues/18329) - [Support Linux Gentoo](https://github.com/prisma/prisma/issues/18698) - [Know engines to download for Void Linux](https://github.com/prisma/prisma/issues/20434) - [Engine does not support Linux distro "openeuler"](https://github.com/prisma/prisma/issues/20937) - [Prisma Doesn't Recognize Crystal Linux distro](https://github.com/prisma/prisma/issues/21955) - [Regression: Mapped `enum` throws error (collation `cp1250_czech_cs` or similar)](https://github.com/prisma/prisma/issues/21967) - [`NOT` condition leaks out of its desired bounds](https://github.com/prisma/prisma/issues/22007) - [The column does not exist in the current database.](https://github.com/prisma/prisma/issues/22098) - [Logging `PrismaClient` object is slow](https://github.com/prisma/prisma/issues/22848) - [Running `prisma generate` on Litespeed Web Server cPanel with ssh](https://github.com/prisma/prisma/issues/22857) - [Prisma doesn't know which engines to download for the Linux distro "guttaos"](https://github.com/prisma/prisma/issues/23031) - [Error in driver-adapter-utils with `tsc`: `Cannot find namespace 'debug'.`](https://github.com/prisma/prisma/issues/23091) - [VS Code debugger freeze from time to time, when Prisma Client is involved](https://github.com/prisma/prisma/issues/23181) - [`push` method still unimplemented for scalar lists in CockroachDB](https://github.com/prisma/prisma/issues/23183) - [`Invalid character` error persists on 5.10.1 in Prisma Studio](https://github.com/prisma/prisma/issues/23225) - [Add "Peppermint OS" to list of supported distros](https://github.com/prisma/prisma/issues/23237) - [`runtimeDescription` is not defined error](https://github.com/prisma/prisma/issues/23430) ### Prisma Migrate - [Prisma with UOS or Deepin](https://github.com/prisma/prisma/issues/18374) - [Warning: Linux distro "slackware"](https://github.com/prisma/prisma/issues/18547) - [Error when run `npx prisma db pull` with DeepinOS 20.9GNU/LInux](https://github.com/prisma/prisma/issues/19157) - [Add solus to list of known supported distros](https://github.com/prisma/prisma/issues/21493) - [NixOS not recognised as a Linux distribution](https://github.com/prisma/prisma/issues/22145) - [Prisma Warning on Ubuntu 20.04](https://github.com/prisma/prisma/issues/22347) - [Let Prisma detect Artix Linux distro](https://github.com/prisma/prisma/issues/22522) - [couldn't identify clear-linux-os](https://github.com/prisma/prisma/issues/22539) - [Prisma doesn't know which engines to download with `Linux Mint`](https://github.com/prisma/prisma/issues/23141) - [`Error: Invalid character` when `schema.prisma` includes Chinese/Non-ASCII characters in a comment](https://github.com/prisma/prisma/issues/23201) ### Prisma Engines - [[DA] Planetscale engine tests: aggregations](https://github.com/prisma/prisma-engines/issues/4473) - [[DA] Planetscale engine tests: json filtering](https://github.com/prisma/prisma-engines/issues/4475) - [[DA] Planetscale engine tests: order and pagination](https://github.com/prisma/prisma-engines/issues/4478) - [[DA] Planetscale engine tests: oids](https://github.com/prisma/prisma-engines/issues/4479) - [[DA] Planetscale engine tests: nested_createmany_fail_dups](https://github.com/prisma/prisma-engines/issues/4481) - [[DA] Planetscale engine tests: create_many_error_dups](https://github.com/prisma/prisma-engines/issues/4484) - [[DA] Planetscale engine tests: upsert_fails_if_filter_dont_match](https://github.com/prisma/prisma-engines/issues/4486)