railway-app[bot]
commented
12 months ago This PR was not deployed automatically as @renovate[bot] does not have access to the Railway project.
In order to get automatic PR deploys, please add @renovate[bot] to the project inside the project settings page.
This PR contains the following updates:
5.3.1->5.5.2Release Notes
prisma/prisma (@prisma/internals)
### [`v5.5.2`](https://togithub.com/prisma/prisma/releases/tag/5.5.2) [Compare Source](https://togithub.com/prisma/prisma/compare/5.5.1...5.5.2) Today, we are issuing the `5.5.2` patch release. #### Fix in Prisma CLI - [Error: sha256 checksum of https://binaries.prisma.sh/all_commits/475c616176945d72f4330c92801f0c5e6398dc0f/windows/query_en gine.dll.node.gz (zipped) should be 748d039badd0919d022fff7d554b66b6937b79035861a6ae9a80c5a95eee76f5 but is b867ad335ee6f58c6a38f665dd641c95e6adff3061f92b7613c62cae1c3362bb](https://togithub.com/prisma/prisma/issues/21616) ### [`v5.5.1`](https://togithub.com/prisma/prisma/releases/tag/5.5.1) [Compare Source](https://togithub.com/prisma/prisma/compare/5.5.0...5.5.1) Today, we are issuing the `5.5.1` patch release. #### Fix in Prisma Client - [5.5.0 regression: typescript error when trying to pass PrismaPlanetScale adapter to the constructor](https://togithub.com/prisma/prisma/issues/21613) ### [`v5.5.0`](https://togithub.com/prisma/prisma/releases/tag/5.5.0) [Compare Source](https://togithub.com/prisma/prisma/compare/5.4.2...5.5.0) 🌟 **Help us spread the word about Prisma by starring the repo or [tweeting](https://twitter.com/intent/tweet?text=Check%20out%20the%20latest%20@prisma%20release%20v5.5.0%20%F0%9F%9A%80%0D%0A%0D%0Ahttps://github.com/prisma/prisma/releases/tag/5.5.0) about the release.** 🌟 ### Highlights #### Serverless database drivers improvements and request for feedback (Preview) In version [5.4.0](https://togithub.com/prisma/prisma/releases/tag/5.4.0), we released `driverAdapters` into Preview. The `driverAdapter` feature enables Prisma Client to access your database using other JavaScript or Serverless database drivers such as Neon, PlanetScale, and Turso. The driver adapters allow Prisma Client to connect to your database using protocols besides TCP, such as HTTP (PlanetScale and Turso) and WebSockets (Neon). You can learn more about the Preview feature from the [announcement blog post](https://www.prisma.io/blog/serverless-database-drivers-KML1ehXORxZV). In this release, we focused our efforts on fixing bugs and improving the stability of the Preview feature. We encourage you to try it out and share your feedback to help us move it to General Availability in either of the following GitHub discussions: - [Neon](https://togithub.com/prisma/prisma/discussions/21346) - [PlanetScale](https://togithub.com/prisma/prisma/discussions/21347) - [Turso](https://togithub.com/prisma/prisma/discussions/21345) #### New flags for the `prisma init` command This release introduces 3 new flags you can provide when initializing Prisma in your project using the [`prisma init`](https://www.prisma.io/docs/reference/api-reference/command-reference#init) command: - `--generator-provider`: Defines the default generator to use - `--preview-features`: Specifies the default Preview features to use in your project - `--output`: Specifies the default output location for the generated client #### Fixes and improvements ##### Prisma CLI - [Prisma init: allow setting generator provider value](https://togithub.com/prisma/prisma/issues/17737) ##### Prisma Client - [`prisma.model.count` does not type `distinct` correctly](https://togithub.com/prisma/prisma/issues/19598) - [Generate fails on 5.2 with unsupported type](https://togithub.com/prisma/prisma/issues/20993) - [Invalid `….findMany()` invocation: The column `j1.id` does not exist in the current database.](https://togithub.com/prisma/prisma/issues/21352) - [5.4.0 subquery has too many columns](https://togithub.com/prisma/prisma/issues/21356) - [One-to-Many relationship does not join on the specified field](https://togithub.com/prisma/prisma/issues/21366) - [Planetscale driver: unsupported column type NULL](https://togithub.com/prisma/prisma/issues/21369) #### Credits Huge thanks to [@onichandame](https://togithub.com/onichandame), [@fqazi](https://togithub.com/fqazi), [@KhooHaoYit](https://togithub.com/KhooHaoYit), [@alencardc](https://togithub.com/alencardc), [@Oreilles](https://togithub.com/Oreilles), [@christianledgard](https://togithub.com/christianledgard), [@skyzh](https://togithub.com/skyzh), [@alula](https://togithub.com/alula), [@michaelpoellath](https://togithub.com/michaelpoellath), [@lukahartwig](https://togithub.com/lukahartwig), [@steebchen](https://togithub.com/steebchen), [@icanipa](https://togithub.com/icanipa), [@jiashengguo](https://togithub.com/jiashengguo), [@stephenwade](https://togithub.com/stephenwade) for helping! #### 💼 We're hiring! If you're interested in joining our growing team to help empower developers to build data-intensive applications, Prisma is the place for you. We're currently hiring for the following roles: - [Software Engineer](https://boards.greenhouse.io/prisma/jobs/6948042002) - [Senior Software Engineer (Rust)](https://boards.greenhouse.io/prisma/jobs/6940273002) - [Engineering Manager: Prisma Data Platform](https://boards.greenhouse.io/prisma/jobs/6927046002) ### [`v5.4.2`](https://togithub.com/prisma/prisma/releases/tag/5.4.2) [Compare Source](https://togithub.com/prisma/prisma/compare/5.4.1...5.4.2) Today, we are issuing the `5.4.2` patch release. #### Fix in Prisma Client - [5.4.0 subquery has too many columns](https://togithub.com/prisma/prisma/issues/21356) - [One-to-Many relationship does not join on the specified field](https://togithub.com/prisma/prisma/issues/21366) ### [`v5.4.1`](https://togithub.com/prisma/prisma/releases/tag/5.4.1) [Compare Source](https://togithub.com/prisma/prisma/compare/5.4.0...5.4.1) Today, we are issuing the `5.4.1` patch release. #### Fix in Prisma Client - [Invalid `….findMany()` invocation: The column `j1.id` does not exist in the current database.](https://togithub.com/prisma/prisma/issues/21352) #### Fix in `@prisma/adapter-planetscale` - [Planetscale driver: unsupported column type NULL](https://togithub.com/prisma/prisma/issues/21369) ### [`v5.4.0`](https://togithub.com/prisma/prisma/releases/tag/5.4.0) [Compare Source](https://togithub.com/prisma/prisma/compare/5.3.1...5.4.0) 🌟 **Help us spread the word about Prisma by starring the repo or [tweeting](https://twitter.com/intent/tweet?text=Check%20out%20the%20latest%20@prisma%20release%20v5.4.0%20%F0%9F%9A%80%0D%0A%0D%0Ahttps://github.com/prisma/prisma/releases/tag/5.4.0) about the release.** 🌟 ### **Highlights** #### Preview support for PlanetScale and Neon serverless database drivers We’re excited to announce [Preview](https://www.prisma.io/docs/about/prisma/releases#preview) support for the Neon and PlanetScale serverless database drivers. The PlanetScale and Neon serverless database drivers allow Prisma to connect to your database using protocols besides TCP — HTTP (PlanetScale) or WebSockets (Neon). To get started with the serverless database drivers, first enable the `driverAdapters` Preview feature flag in your Prisma schema: ```prisma // schema.prisma generator client { provider = "prisma-client-js" previewFeatures = ["driverAdapters"] } ``` Next, to set up Prisma Client to use the serverless database drivers: ##### **PlanetScale** Install the Prisma adapter for PlanetScale and [PlanetScale serverless database driver](https://togithub.com/planetscale/database-js), and undici: ```bash npm install @prisma/adapter-planetscale @planetscale/database undici ``` > Prisma ORM supports Node 16 and up. In Node 18 and up, `undici` is not needed. Ensure you update the host value in your connection string to `aws.connect.psdb.cloud`. You can learn more about this [here](https://planetscale.com/docs/tutorials/planetscale-serverless-driver#add-and-use-the-planetscale-serverless-driver-for-javascript-to-your-project). ```bash DATABASE_URL='mysql://johndoe:strongpassword@aws.connect.psdb.cloud/clear_nightsky?sslaccept=strict' ``` Update your Prisma Client instance to use the PlanetScale database driver: ```tsx // Import required dependencies import { connect } from '@planetscale/database'; import { PrismaPlanetScale } from '@prisma/adapter-planetscale'; import { PrismaClient } from '@prisma/client'; import { fetch as undiciFetch } from 'undici'; // Initialize Prisma Client with the PlanetScale serverless database driver const connection = connect({ url: connectionString, fetch: undiciFetch }); const adapter = new PrismaPlanetScale(connection); const prisma = new PrismaClient({ adapter }); ``` ##### **Neon** Install the Prisma adapter for Neon, [Neon serverless database driver](https://togithub.com/neondatabase/serverless) and undici (WebSockets): ```bash npm install @prisma/adapter-neon @neondatabase/serverless undici ``` Update your Prisma Client instance to use the Neon serverless database driver: ```tsx // Import required dependencies import { Pool, neonConfig } from '@neondatabase/serverless'; import { PrismaNeon } from '@prisma/adapter-neon'; import { PrismaClient } from '@prisma/client'; import { WebSocket } from 'undici' neonConfig.webSocketConstructor = WebSocket; // Initialize Prisma Client with the Neon serverless database driver const pool = new Pool({ connectionString: process.env.DATABASE_URL }); const adapter = new PrismaNeon(pool); const prisma = new PrismaClient({ adapter }); ``` Let us know your feedback about the [Neon](https://togithub.com/prisma/prisma/discussions/21346) or [Planetscale](https://togithub.com/prisma/prisma/discussions/21347) serverless database drivers in the linked GitHub discussions. Create a [bug report](https://togithub.com/prisma/prisma/issues/new?assignees=\&labels=kind/bug\&projects=\&template=bug_report.yml) if you run into any issues. #### Early Access support for Turso [Turso](https://turso.tech/) is an edge-hosted, distributed database that's based on [libSQL](https://turso.tech/libsql), an open-source and open-contribution fork of SQLite, enabling you to bring data closer to your application and minimize query latency. Since support for Turso is in Early Access, there may be some rough edges which we’re still working on it to improve the API and overall support. Additionally, it is behind the `driverAdapters` Preview feature flag. Enable it to get started using Turso in your project: ```groovy // schema.prisma generator client { provider = "prisma-client-js" previewFeatures = ["driverAdapters"] } ``` Next, install the Prisma Client adapter for Turso and the `libSQL` database client ```bash npm install @prisma/adapter-libsql @libsql/client ``` Update your Prisma Client instance: ```tsx // Import required dependencies import { PrismaClient } from '@prisma/client' import { PrismaLibSQL } from '@prisma/adapter-libsql' import { createClient } from '@libsql/client' // Create a new instance of the libSQL database client const libsql = createClient({ // @ts-expect-error url: process.env.TURSO_DATABASE_URL, authToken: process.env.TURSO_AUTH_TOKEN }) // Create a Prisma "adapter" for libSQL const adapter = new PrismaLibSQL(libsql) // Pass the adapter option to the Prisma Client instance const prisma = new PrismaClient({ adapter }) ``` You can learn more on how to use Prisma together with Turso in the [announcement blog post](https://www.prisma.io/blog/prisma-turso-ea-support-rXGd_Tmy3UXX). Try it out! [Let us know what you think](https://togithub.com/prisma/prisma/discussions/21345) and create a [bug report](https://togithub.com/prisma/prisma/issues/new?assignees=\&labels=kind/bug\&projects=\&template=bug_report.yml) if you run into any issues. #### Query performance improvements In our continued efforts to make Prisma Client faster, we identified and improved the performance of different types of queries. ##### Relation filters improvements We made the following improvements to relation filters: - Removed an unnecessary `INNER JOIN` used in relation filter queries (Big thank you to [@KhooHaoYit](https://togithub.com/KhooHaoYit) for helping out) - Use of `LEFT JOIN`'s for to-one relations. Previously, Prisma made use of sub-queries to fetch data. **Example Prisma Client query** ```tsx prisma.comment.findMany({ where: { post: { author: { name: "John" } } } }) ``` **Before 5.4.0** ```sql SELECT "Comment"."id" FROM "Comment" WHERE ("Comment"."id") IN ( SELECT "t0"."id" FROM "Comment" AS "t0" INNER JOIN "Post" AS "j0" ON ("j0"."id") = ("t0"."postId") WHERE ( ("j0"."id") IN ( SELECT "t1"."id" FROM "Post" AS "t1" INNER JOIN "User" AS "j1" ON ("j1"."id") = ("t1"."userId") WHERE ( "j1"."name" = $ 1 AND "t1"."id" IS NOT NULL ) ) AND "t0"."id" IS NOT NULL ) ); ``` **After 5.4.0** ```sql SELECT "Comment"."id" FROM "Comment" LEFT JOIN "Post" AS "j1" ON ("j1"."id") = ("Comment"."postId") LEFT JOIN "User" AS "j2" ON ("j2"."id") = ("j1"."userId") WHERE ( "j2"."name" = $ 1 AND ("j2"."id" IS NOT NULL) AND ("j1"."id" IS NOT NULL) ); ``` If you’re interested in more details on the relation query filter improvements, you can take a look at [this pull request](https://togithub.com/prisma/prisma-engines/pull/4235). ##### Enum improvements on PostgreSQL and CockroachDB Previously, when an enum value was used in a query, our Postgres driver would make additional queries to resolve the enum types that were used. In this release, we’re making improvements by casting enums to `TEXT` to avoid the additional roundtrips when resolving the types. This change should have the most impact if you’re using `pgBouncer` or if you’re running Prisma in a serverless environment, where our Postgres driver can’t cache enum types information. **Prisma schema** ```groovy model User { id Int @id @default(cuid()) role Role } enum Role { User Admin } ``` **Prisma Client query** ```tsx await prisma.user.findMany({ where: { role: "Admin" } }) ``` **Before 5.4.0** ```sql -- Internal driver query SELECT t.typname, t.typtype, t.typelem, r.rngsubtype, t.typbasetype, n.nspname, t.typrelid FROM pg_catalog.pg_type t LEFT OUTER JOIN pg_catalog.pg_range r ON r.rngtypid = t.oid INNER JOIN pg_catalog.pg_namespace n ON t.typnamespace = n.oid WHERE t.oid = $1; -- Internal driver query SELECT enumlabel FROM pg_catalog.pg_enum WHERE enumtypid = $1 ORDER BY enumsortorder; -- Prisma Client query SELECT id, role FROM "User" WHERE role = $1; ``` **After 5.4.0** ```sql -- Prisma Client query SELECT id, role::text FROM "User" WHERE role = CAST($1::text AS "Role); ``` ##### Bulk delete improvements We optimized the `deleteMany` operation by: - Removing all `SELECT` queries used to fetch data that would be used as input for the `DELETE` operation. In some cases, this also improves index usage. - Removing the transaction previously used as it’s now a single atomic operation. **Prisma Client query** ```tsx await prisma.post.deleteMany({ where: { id: { gt: 1, lt: 10, } } }) ``` **Before 5.4.0** ```sql BEGIN SELECT id FROM "Post" WHERE id > 1 AND id < 10; SELECT id FROM "Post" WHERE id > 1 AND id < 10 AND id IN (<...select ids>); DELETE FROM "Post" WHERE id IN (<...select ids>) AND id > 1 AND id < 10; COMMIT ``` **After 5.4.0** ```sql DELETE FROM "Post" WHERE id > 1 AND id < 10; ``` ##### Upsert improvements We improved the `upsert` operation ([non-native database upsert](https://www.prisma.io/docs/reference/api-reference/prisma-client-reference#database-upserts)) by removing a redundant `SELECT` query: **Prisma Client query** ```tsx await prisma.user.upsert({ where: { email: "john@doe.com" }, create: { email: "john@doe.com", firstName: "John" }, update: { firstName: "Johnny" }, }) ``` **Before 5.4.0** ```sql SELECT `User`.`id` FROM `User` WHERE `User`.`email` = ?; SELECT `User`.`id` FROM `User` WHERE `User`.`email` = ?; UPDATE `prisma`.`User` SET `firstName` = ? WHERE `prisma`.`User`.`id` IN (?) AND `prisma`.`User`.`email` = ?; SELECT `User`.`id` FROM `User` WHERE `User`.`id` = ?; ``` **After 5.4.0** ```sql SELECT `User`.`id` FROM `User` WHERE `User`.`email` = ?; UPDATE `prisma`.`User` SET `firstName` = ? WHERE `prisma`.`User`.`id` IN (?) AND `prisma`.`User`.`email` = ?; SELECT `User`.`id` FROM `User` WHERE `User`.`id` = ?; ``` #### Fixes and improvements ##### Prisma Client - [Unnecessary `SELECT` may be generated by `upsert()`](https://togithub.com/prisma/prisma/issues/5686) - [Inefficient deleteMany query generation](https://togithub.com/prisma/prisma/issues/7232) - [Prisma can generate an overly complex and inefficient query in some cases](https://togithub.com/prisma/prisma/issues/7894) - [`deleteMany` optimisation](https://togithub.com/prisma/prisma/issues/8239) - [CockroachDB: Highly Variable Query Response Times](https://togithub.com/prisma/prisma/issues/11317) - [Extremely poor relation where clause query](https://togithub.com/prisma/prisma/issues/14688) - [Enums loaded as part of transaction after `UPDATE`, slowing down transaction.](https://togithub.com/prisma/prisma/issues/14955) - [ MongoDB `deleteMany` seems to send 2 identical read queries first before triggering the actual delete](https://togithub.com/prisma/prisma/issues/15085) - [Query validation messages reference color output even if colors are not enabled](https://togithub.com/prisma/prisma/issues/17706) - [Prisma generates unnecessary subquery, which is inefficient](https://togithub.com/prisma/prisma/issues/17879) - [Unnecessary INNER JOIN when doing nested queries](https://togithub.com/prisma/prisma/issues/18343) - [Semver checks for yarn and typescript could potentially fail](https://togithub.com/prisma/prisma/issues/18751) - [Prisma overrides type caching when in PGBouncer mode, causing 9,000 enum queries per second on a production system](https://togithub.com/prisma/prisma/issues/19325) - [deleteMany generates double WHERE filter](https://togithub.com/prisma/prisma/issues/19950) - [Prisma generate command crashes with `RustPanic: RuntimeError: panicked at 'internal error: entered unreachable code', query-engine/prisma-models/src/field/scalar.rs:93:50`](https://togithub.com/prisma/prisma/issues/20037) - [Duplicated keys in `metrics` properties](https://togithub.com/prisma/prisma/issues/21069) - [Prisma Client extension with method override and `jest-mock-extended` or `vitest-mock-extended` expects `never` input ](https://togithub.com/prisma/prisma/issues/21136) ##### Language tools (e.g. VS Code) - [Auto-completion suggests attributes already present ](https://togithub.com/prisma/language-tools/issues/1326) - [Quick Fix: when `@@schema` is defined in a block without the `schemas` attribute](https://togithub.com/prisma/language-tools/issues/1333) ##### Prisma Engines - [CockroachDB: get_columns can hit inefficiency inside pg_class](https://togithub.com/prisma/prisma-engines/issues/4250) #### Credits Huge thanks to [@onichandame](https://togithub.com/onichandame), [@fqazi](https://togithub.com/fqazi), [@KhooHaoYit](https://togithub.com/KhooHaoYit), [@alencardc](https://togithub.com/alencardc), [@Oreilles](https://togithub.com/Oreilles), [@christianledgard](https://togithub.com/christianledgard), [@skyzh](https://togithub.com/skyzh), [@alula](https://togithub.com/alula), [@michaelpoellath](https://togithub.com/michaelpoellath), [@RobertCraigie](https://togithub.com/RobertCraigie), [@icanipa](https://togithub.com/icanipa), [@jiashengguo](https://togithub.com/jiashengguo), [@stephenwade](https://togithub.com/stephenwade), [@darthmaim](https://togithub.com/darthmaim), [@ludralph](https://togithub.com/ludralph), [@Gerschtli](https://togithub.com/Gerschtli), [@andyjy](https://togithub.com/andyjy) for helping! #### 💼 We're hiring! If you're interested in joining our growing team to help empower developers to build data-intensive applications, Prisma is the place for you. We're currently hiring for the following roles: - [Software Engineer](https://boards.greenhouse.io/prisma/jobs/6948042002) - [Senior Software Engineer (Rust)](https://boards.greenhouse.io/prisma/jobs/6940273002) - [Engineering Manager: Prisma Data Platform](https://boards.greenhouse.io/prisma/jobs/6927046002) Feel free to read the job descriptions and apply using the links provided.Configuration
📅 Schedule: Branch creation - "every weekend" in timezone Australia/Melbourne, Automerge - At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
♻ Rebasing: Whenever PR is behind base branch, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.
This PR has been generated by Mend Renovate. View repository job log here.