Prisma

Latest version: v0.15.0

Safety actively analyzes 687918 Python packages for vulnerabilities to keep your Python projects secure.

Scan your dependencies

Page 5 of 44

5.7.1

Today, we are issuing the `5.7.1` patch release.

This patch fixes multiple small problems in our `relationJoins` preview feature. If you ran into problems when testing `relationJoins` before, please give it another go with 5.7.1 and [share your feedback](https://github.com/prisma/prisma/discussions/22288) or create a [bug report](https://github.com/prisma/prisma/issues/new?assignees=&labels=kind/bug&projects=&template=bug_report.yml) if you encounter any issues.

Fixes in Prisma Client

- [`relationJoins`: Int[] return as null](https://github.com/prisma/prisma/issues/22303)
- [`relationJoins`: fails when filtering includes by isNot: null](https://github.com/prisma/prisma/issues/22311)
- [`relationJoins`: "The table (not available) does not exist in the current database."](https://github.com/prisma/prisma/issues/22299)
- [`relationJoins`: PostgresError { code: "54023", message: "cannot pass more than 100 arguments to a function", severity: "ERROR", detail: None, column: None, hint: None }](https://github.com/prisma/prisma/issues/22298)
- [`relationJoins`: Inconsistent column data: Unexpected conversion failure from String to datetime. Reason: $trailing input](https://github.com/prisma/prisma/issues/22293)

5.7.0

sql
SELECT DISTINCT ON ("public"."User"."role")
"public"."User"."id",
"public"."User"."role"::text
FROM
"public"."User"
WHERE
1 = 1 OFFSET $1


[Share your feedback](https://github.com/prisma/prisma/discussions/22287) and create a [bug report](https://github.com/prisma/prisma/issues/new?assignees=&labels=kind/bug&projects=&template=bug_report.yml) if you encounter any issues.

Improved support for Netlify using Node.js v20

In this release, we improved Prisma support when deploying to Netlify on Node.js v20. Previously, the Prisma Client could not resolve the location of the Query Engine after deploying to Netlify when using Node.js v20. If you run into this issue, we recommend updating to Prisma v5.7.0.

We recommend giving [this comment](https://github.com/prisma/prisma/issues/22244#issuecomment-1842847194) on GitHub a read if you are not yet able to upgrade Prisma, to learn how to get around the error.

Fixes and improvements

Prisma Client

- [Update: `InterpretationError("Unable to convert expression result into a set of selection results", None)` (starting with 5.2.0)](https://github.com/prisma/prisma/issues/21182)
- [Error when inserting record with array enum column after `TRUNCATE`ing the table on CockroachDB: `placeholder $1 already has type string, cannot assign Color`](https://github.com/prisma/prisma/issues/21901)
- [Netlify deployment with Node 20 break Prisma (`Prisma Client could not locate the Query Engine for runtime "rhel-openssl-3.0.x"`)](https://github.com/prisma/prisma/issues/22244)

Prisma

- [Planetscale Driver doesn't work anymore after updating to 5.6.0 ](https://github.com/prisma/prisma/issues/21956)

Prisma Migrate

- [`prisma debug` command does not show env variables declared in `.env` file](https://github.com/prisma/prisma/issues/21968)

Credits

Huge thanks to anuraaga, onichandame, LucianBuzzo, RobertCraigie, fqazi, KhooHaoYit, alencardc, Oreilles, christianledgard, skyzh, alula, AikoRamalho, petradonka for helping!

Company news

💼 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 hiring for the following roles:

- [Manager: Developer Advocacy](https://boards.greenhouse.io/prisma/jobs/7051313002)
- [Software Engineer](https://boards.greenhouse.io/prisma/jobs/7034499002)

5.6.0

🌟 **Help us spread the word about Prisma by starring the repo or [tweeting](https://twitter.com/intent/tweet?text=Check%20out%20the%20latest%20prisma%20release%20v5.6.0%20%F0%9F%9A%80%0D%0A%0D%0Ahttps://github.com/prisma/prisma/releases/tag/5.6.0) about the release.** 🌟

🚀 [Prisma Accelerate](https://pris.ly/accelerate-home-orm-release-1), our connection pool and global edge cache, is now Generally Available! Sign up to [give it a try](https://pris.ly/pdp-console-orm-release-1). 🚀

Highlights

Driver adapters improvements (Preview)

In version [5.4.0](https://github.com/prisma/prisma/releases/tag/5.4.0), we released `driverAdapters` into Preview. The `driverAdapters` feature enables Prisma Client to access your database using JavaScript or Serverless database drivers.

In this release, we fixed many bugs for the existing driver adapters. We appreciate all the community feedback that has helped us improve this feature!

PlanetScale serverless driver adapter improvements

This release also introduces a small breaking change to the `prisma/adapter-planetscale` package to improve its stability and performance. The serverless driver adapter will now use a connection pool instead of a single connection from PlanetScale’s serverless driver.

In case you’re using the `prisma/adapter-planetscale`, update your Prisma Client instance with the following:

diff
-import { connect } from 'planetscale/database'
+import { Client } from 'planetscale/database'
import { PrismaPlanetScale } from 'prisma/adapter-planetscale'
import { PrismaClient } from 'prisma/client'
import { fetch as undiciFetch } from 'undici';

-const connection = connect({ url: connectionString, fetch: undiciFetch })
+const client = new Client({ url: connectionString, fetch: undiciFetch })

-const adapter = new PrismaPlanetScale(connection)
+const adapter = new PrismaPlanetScale(client)

const prisma = new PrismaClient({ adapter })


If you run into the following error: ` [TypeError]: PrismaPlanetScale must be initialized with an instance of Client.`, you can use the following snippet when defining your Prisma Client instance:

ts
import { createRequire } from "node:module";
import { PrismaPlanetScale } from "prisma/adapter-planetscale";
import { fetch as undiciFetch } from 'undici';

const require = createRequire(import.meta.url);
const { Client } = require("planetscale/database");

const client = new Client({ url: process.env.DATABASE_URL , fetch: undiciFetch })
const adapter = new PrismaPlanetScale(client);


Request for feedback

We encourage you to try out the driver adapters and share your feedback to help us move it to General Availability in either of the following GitHub discussions:

- [Neon](https://github.com/prisma/prisma/discussions/21346)
- [PlanetScale](https://github.com/prisma/prisma/discussions/21347)
- [Turso](https://github.com/prisma/prisma/releases#:~:text=Let%20us%20know%20what%20you%20think)

Refer to [our docs](https://www.prisma.io/docs/concepts/components/database-drivers#driver-adapters) to learn more about driver adapters.

New `prisma debug` command

This release introduces a new command: `prisma debug`. The command provides debugging information such as environment variables that Prisma Client, Prisma Migrate, Prisma CLI, and Prisma Studio use. The command is also useful when creating a bug report as the information complements the output of the `prisma -v` command.

You can learn more about the command in our [docs](https://www.prisma.io/docs/reference/api-reference/command-reference#debug).

Read replicas extension improvements

We also released [version 0.3.0](https://github.com/prisma/extension-read-replicas/releases/tag/v0.3.0) of the `prisma/extension-read-replicas` package that contains the following improvements:

- A new `$replica()` method that explicitly enables you to use a replica for your query.

For example, by default, the `queryRaw` and `executeRaw` methods are forwarded to the primary database, as they could try to write to the database. You can use the `$replica()` method with either of the `*Raw` methods to explicitly execute your query against a replica instead of your primary database.

- Validation for when there’s an empty list of replicas.
- Webpack bundling fixes

We want to thank you, our community members, for your contributions! 🙏

You can find additional information on the changes in the [extension’s release](https://github.com/prisma/extension-read-replicas/releases/tag/v0.3.0). You can learn more about the extension in the [announcement blog post](https://www.prisma.io/blog/read-replicas-prisma-client-extension-f66prwk56wow).

Package provenance

npm has introduced [provenance statements](https://docs.npmjs.com/generating-provenance-statements) to improve supply-chain security and transparency of packages. This allows developers to verify where and how packages are built.

Starting with the 5.6.0 release, all npm packages for Prisma ORM will be published with provenance statements. If you maintain a Prisma Client extension or generator, we encourage you to enable provenance statements when publishing to npm.

Fixes and improvements

Prisma Migrate

- [Weird error message on `db push` with invalid connection string: Connection string redacted, weird grammar](https://github.com/prisma/prisma/issues/20230)
- [Regression for MongoDB introspection in 5.4.0](https://github.com/prisma/prisma/issues/21441)
- [Inconsistent datetime column data importing to Turso](https://github.com/prisma/prisma/issues/21552)
- [`db pull --url=...` logs full connection string on `P4001 The introspected database was empty`](https://github.com/prisma/prisma/issues/21733)

Prisma Client

- [`prisma_pool_connections_idle` reports misleading number](https://github.com/prisma/prisma/issues/21221)
- [Update and read issues with `prisma/adapter-planetscale`](https://github.com/prisma/prisma/issues/21592)
- [5.5.0 regression: typescript error when trying to pass `PrismaPlanetScale` adapter to the constructor](https://github.com/prisma/prisma/issues/21613)
- [5.5.0/1: `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://github.com/prisma/prisma/issues/21616)

Prisma CLI

- [`prisma debug`](https://github.com/prisma/prisma/issues/21619)

Credits

Huge thanks to onichandame, LucianBuzzo, RobertCraigie, fqazi, KhooHaoYit, alencardc, Oreilles, christianledgard, skyzh, alula, luxaritas, Nasfame, lukahartwig, steebchen, icanipa for helping!

Company news

Prisma Accelerate is now Generally Available

We're excited to share that [Prisma Accelerate](https://pris.ly/accelerate-home-orm-release) is now Generally Available. Prisma Accelerate is a global database cache that's available in over 280 locations and provides scalable connection pooling for serverless and edge applications.

Learn more in the [announcement blog post](https://pris.ly/accelerate-ga-post-orm-release). Sign up and try out Prisma Accelerate [here](https://pris.ly/pdp-console-orm-release).

💼 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 hiring for an [Engineering Manager: Prisma Data Platform](https://boards.greenhouse.io/prisma/jobs/7009408002).

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://github.com/prisma/prisma/issues/21616)

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://github.com/prisma/prisma/issues/21613)

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%20prisma%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://github.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://github.com/prisma/prisma/discussions/21346)
- [PlanetScale](https://github.com/prisma/prisma/discussions/21347)
- [Turso](https://github.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://github.com/prisma/prisma/issues/17737)

Prisma Client

- [`prisma.model.count` does not type `distinct` correctly](https://github.com/prisma/prisma/issues/19598)
- [Generate fails on 5.2 with unsupported type](https://github.com/prisma/prisma/issues/20993)
- [Invalid `….findMany()` invocation: The column `j1.id` does not exist in the current database.](https://github.com/prisma/prisma/issues/21352)
- [5.4.0 subquery has too many columns](https://github.com/prisma/prisma/issues/21356)
- [One-to-Many relationship does not join on the specified field](https://github.com/prisma/prisma/issues/21366)
- [Planetscale driver: unsupported column type NULL](https://github.com/prisma/prisma/issues/21369)

Credits

Huge thanks to onichandame, fqazi, KhooHaoYit, alencardc, Oreilles, christianledgard, skyzh, alula, michaelpoellath, lukahartwig, steebchen, icanipa, jiashengguo, 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)

Page 5 of 44

Links

Releases

Has known vulnerabilities

© 2024 Safety CLI Cybersecurity Inc. All Rights Reserved.