prisma/prisma (@prisma/client)
### [`v5.11.0`](https://togithub.com/prisma/prisma/releases/tag/5.11.0)
[Compare Source](https://togithub.com/prisma/prisma/compare/5.10.2...5.11.0)
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.
##### 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://togithub.com/prisma/prisma/issues/7317)
- [mongodb where condition resulted in combined $ne but should not be $eq](https://togithub.com/prisma/prisma/issues/15175)
- [Node hangs when `console.log(new PrismaClient())`](https://togithub.com/prisma/prisma/issues/18292)
- [Add wolfy linux to supported OS](https://togithub.com/prisma/prisma/issues/18329)
- [Support Linux Gentoo](https://togithub.com/prisma/prisma/issues/18698)
- [Know engines to download for Void Linux](https://togithub.com/prisma/prisma/issues/20434)
- [Engine does not support Linux distro "openeuler"](https://togithub.com/prisma/prisma/issues/20937)
- [Prisma Doesn't Recognize Crystal Linux distro](https://togithub.com/prisma/prisma/issues/21955)
- [Regression: Mapped `enum` throws error (collation `cp1250_czech_cs` or similar)](https://togithub.com/prisma/prisma/issues/21967)
- [`NOT` condition leaks out of its desired bounds](https://togithub.com/prisma/prisma/issues/22007)
- [The column does not exist in the current database.](https://togithub.com/prisma/prisma/issues/22098)
- [Logging `PrismaClient` object is slow](https://togithub.com/prisma/prisma/issues/22848)
- [Running `prisma generate` on Litespeed Web Server cPanel with ssh](https://togithub.com/prisma/prisma/issues/22857)
- [Prisma doesn't know which engines to download for the Linux distro "guttaos"](https://togithub.com/prisma/prisma/issues/23031)
- [Error in driver-adapter-utils with `tsc`: `Cannot find namespace 'debug'.`](https://togithub.com/prisma/prisma/issues/23091)
- [VS Code debugger freeze from time to time, when Prisma Client is involved](https://togithub.com/prisma/prisma/issues/23181)
- [`push` method still unimplemented for scalar lists in CockroachDB](https://togithub.com/prisma/prisma/issues/23183)
- [`Invalid character` error persists on 5.10.1 in Prisma Studio](https://togithub.com/prisma/prisma/issues/23225)
- [Add "Peppermint OS" to list of supported distros](https://togithub.com/prisma/prisma/issues/23237)
- [`runtimeDescription` is not defined error](https://togithub.com/prisma/prisma/issues/23430)
##### Prisma Migrate
- [Prisma with UOS or Deepin](https://togithub.com/prisma/prisma/issues/18374)
- [Warning: Linux distro "slackware"](https://togithub.com/prisma/prisma/issues/18547)
- [Error when run `npx prisma db pull` with DeepinOS 20.9GNU/LInux](https://togithub.com/prisma/prisma/issues/19157)
- [Add solus to list of known supported distros](https://togithub.com/prisma/prisma/issues/21493)
- [NixOS not recognised as a Linux distribution](https://togithub.com/prisma/prisma/issues/22145)
- [Prisma Warning on Ubuntu 20.04](https://togithub.com/prisma/prisma/issues/22347)
- [Let Prisma detect Artix Linux distro](https://togithub.com/prisma/prisma/issues/22522)
- [couldn't identify clear-linux-os](https://togithub.com/prisma/prisma/issues/22539)
- [Prisma doesn't know which engines to download with `Linux Mint`](https://togithub.com/prisma/prisma/issues/23141)
- [`Error: Invalid character` when `schema.prisma` includes Chinese/Non-ASCII characters in a comment](https://togithub.com/prisma/prisma/issues/23201)
##### Prisma Engines
- [\[DA\] Planetscale engine tests: aggregations](https://togithub.com/prisma/prisma-engines/issues/4473)
- [\[DA\] Planetscale engine tests: json filtering](https://togithub.com/prisma/prisma-engines/issues/4475)
- [\[DA\] Planetscale engine tests: order and pagination](https://togithub.com/prisma/prisma-engines/issues/4478)
- [\[DA\] Planetscale engine tests: oids](https://togithub.com/prisma/prisma-engines/issues/4479)
- [\[DA\] Planetscale engine tests: nested_createmany_fail_dups](https://togithub.com/prisma/prisma-engines/issues/4481)
- [\[DA\] Planetscale engine tests: create_many_error_dups](https://togithub.com/prisma/prisma-engines/issues/4484)
- [\[DA\] Planetscale engine tests: upsert_fails_if_filter_dont_match](https://togithub.com/prisma/prisma-engines/issues/4486)
Configuration
📅 Schedule: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about these updates again.
[ ] If you want to rebase/retry this PR, check this box
This PR has been generated by Mend Renovate. View repository job log here.
This PR contains the following updates:
5.10.2->5.11.05.10.2->5.11.0Release Notes
prisma/prisma (@prisma/client)
### [`v5.11.0`](https://togithub.com/prisma/prisma/releases/tag/5.11.0) [Compare Source](https://togithub.com/prisma/prisma/compare/5.10.2...5.11.0) 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. ##### 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://togithub.com/prisma/prisma/issues/7317) - [mongodb where condition resulted in combined $ne but should not be $eq](https://togithub.com/prisma/prisma/issues/15175) - [Node hangs when `console.log(new PrismaClient())`](https://togithub.com/prisma/prisma/issues/18292) - [Add wolfy linux to supported OS](https://togithub.com/prisma/prisma/issues/18329) - [Support Linux Gentoo](https://togithub.com/prisma/prisma/issues/18698) - [Know engines to download for Void Linux](https://togithub.com/prisma/prisma/issues/20434) - [Engine does not support Linux distro "openeuler"](https://togithub.com/prisma/prisma/issues/20937) - [Prisma Doesn't Recognize Crystal Linux distro](https://togithub.com/prisma/prisma/issues/21955) - [Regression: Mapped `enum` throws error (collation `cp1250_czech_cs` or similar)](https://togithub.com/prisma/prisma/issues/21967) - [`NOT` condition leaks out of its desired bounds](https://togithub.com/prisma/prisma/issues/22007) - [The column does not exist in the current database.](https://togithub.com/prisma/prisma/issues/22098) - [Logging `PrismaClient` object is slow](https://togithub.com/prisma/prisma/issues/22848) - [Running `prisma generate` on Litespeed Web Server cPanel with ssh](https://togithub.com/prisma/prisma/issues/22857) - [Prisma doesn't know which engines to download for the Linux distro "guttaos"](https://togithub.com/prisma/prisma/issues/23031) - [Error in driver-adapter-utils with `tsc`: `Cannot find namespace 'debug'.`](https://togithub.com/prisma/prisma/issues/23091) - [VS Code debugger freeze from time to time, when Prisma Client is involved](https://togithub.com/prisma/prisma/issues/23181) - [`push` method still unimplemented for scalar lists in CockroachDB](https://togithub.com/prisma/prisma/issues/23183) - [`Invalid character` error persists on 5.10.1 in Prisma Studio](https://togithub.com/prisma/prisma/issues/23225) - [Add "Peppermint OS" to list of supported distros](https://togithub.com/prisma/prisma/issues/23237) - [`runtimeDescription` is not defined error](https://togithub.com/prisma/prisma/issues/23430) ##### Prisma Migrate - [Prisma with UOS or Deepin](https://togithub.com/prisma/prisma/issues/18374) - [Warning: Linux distro "slackware"](https://togithub.com/prisma/prisma/issues/18547) - [Error when run `npx prisma db pull` with DeepinOS 20.9GNU/LInux](https://togithub.com/prisma/prisma/issues/19157) - [Add solus to list of known supported distros](https://togithub.com/prisma/prisma/issues/21493) - [NixOS not recognised as a Linux distribution](https://togithub.com/prisma/prisma/issues/22145) - [Prisma Warning on Ubuntu 20.04](https://togithub.com/prisma/prisma/issues/22347) - [Let Prisma detect Artix Linux distro](https://togithub.com/prisma/prisma/issues/22522) - [couldn't identify clear-linux-os](https://togithub.com/prisma/prisma/issues/22539) - [Prisma doesn't know which engines to download with `Linux Mint`](https://togithub.com/prisma/prisma/issues/23141) - [`Error: Invalid character` when `schema.prisma` includes Chinese/Non-ASCII characters in a comment](https://togithub.com/prisma/prisma/issues/23201) ##### Prisma Engines - [\[DA\] Planetscale engine tests: aggregations](https://togithub.com/prisma/prisma-engines/issues/4473) - [\[DA\] Planetscale engine tests: json filtering](https://togithub.com/prisma/prisma-engines/issues/4475) - [\[DA\] Planetscale engine tests: order and pagination](https://togithub.com/prisma/prisma-engines/issues/4478) - [\[DA\] Planetscale engine tests: oids](https://togithub.com/prisma/prisma-engines/issues/4479) - [\[DA\] Planetscale engine tests: nested_createmany_fail_dups](https://togithub.com/prisma/prisma-engines/issues/4481) - [\[DA\] Planetscale engine tests: create_many_error_dups](https://togithub.com/prisma/prisma-engines/issues/4484) - [\[DA\] Planetscale engine tests: upsert_fails_if_filter_dont_match](https://togithub.com/prisma/prisma-engines/issues/4486)Configuration
📅 Schedule: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about these updates again.
This PR has been generated by Mend Renovate. View repository job log here.