Prisma 2.8.0 — Release Notes & Engineering Impact

Today, we are excited to share the `2.8.0` stable release 🎉 🌟 **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%202.8.0%20%F0%9F%9A%80%0D%0A%0D%0Ahttps://github.com/prisma/prisma/releases/tag/2.8.0) about the release.** ## Major improvements In today's release, we have two new features coming for you! ### `findFirst` While the `findMany` API gives you a powerful API to query your database with different [filters](https://www.prisma.io/docs/reference/tools-and-interfaces/prisma-client/filtering), it's not ideal if you just want to query _a single item_. On the other hand, the `findOne` API returns single items, but it only allows for filtering by _unique_ fields. In version `2.8.0`, we introduce `findFirst` - giving you the full power of `findMany` filters while only returning the first item that matches the filter criteria. So instead of this: ```ts const usersCalledAlice = await prisma.user.findMany({ name: "Alice" }) const firstUserCalledAlice = usersCalledAlice[0] ``` You can now do this: ```ts const firstUserCalledAlice = await prisma.user.findFirst({ name: "Alice" }) ``` All filters available for `findMany` are also available in `findFirst`. ### Case insensitive filters for PostgreSQL are now stable In `2.5.0` we introduced case insensitive filters for PostgreSQL, in today's release we're promoting this feature to stable. This means you don't need to include the `insensitiveFilters` feature flag in the Prisma Client generator any more: ```diff generator client { provider = "prisma-client-js" - previewFeatures = ["insensitiveFilters"] } ``` The new `mode` option you can pass to `findMany` influences the corresponding filter (e.g. `contains` or `startsWith`) but doesn't change the return type of the `findMany` query. `mode` can have two possible values: - `default`: Uses the default filter configured on the database level. If the collation is configured as case insensitive in the database, the default mode will be case insensitive as well. In that case, there's no need to use the `insensitive` mode. - `insensitive`: Uses the case insensitive filter (if possible). ```ts const result = await prisma.user.findMany({ where: { email: { equals: '[email protected]', mode: 'insensitive', }, }, }) ``` Note that this feature will not work if you're using database collations that do not know how to convert between upper- and lowercase letters (e.g. the `C` collation). 📚 **Documentation**: [Case sensitivity](https://www.prisma.io/docs/reference/tools-and-interfaces/prisma-client/case-sensitivity) / [Case-sensitive filtering](https://www.prisma.io/docs/reference/tools-and-interfaces/prisma-client/filtering#case-insensitive-filtering) ### Already existing preview features from previous releases Just a quick reminder: - In version [`2.6.0`](https://github.com/prisma/prisma/releases/tag/2.6.0) we introduced one preview feature, namely `atomicNumberOperations`. - In version [`2.1.0`](https://github.com/prisma/prisma/releases/tag/2.1.0) we introduced two preview features, namely `connectOrCreate` and `transactionApi`. In case they're useful for you, please give them a try and [share your feedback](https://github.com/prisma/prisma/issues/3108)! These features remain in preview in this release. ## Fixes and improvements ### [`prisma`](https://github.com/prisma/prisma) - [Output prepared GitHub issue creation link after reporting error (CLI)](https://github.com/prisma/prisma/issues/2588) - [Prisma Format should enforce opinionation for order of attributes](https://github.com/prisma/prisma/issues/3269) - [Cursor Pagination not returning expected results](https://github.com/prisma/prisma/issues/3505) - [Warn about syntax error in datasource url (with env var) earlier](https://github.com/prisma/prisma/issues/3509) - [Allow setting scalar lists without `set`](https://github.com/prisma/prisma/issues/3529) - [Investigate live reload of Prisma Client with `next dev`](https://github.com/prisma/prisma/issues/3615) - [Output path of schema.prisma file in CLI commands that read it](https://github.com/prisma/prisma/issues/3647) - [Environment variable to trigger crash/panic in Engines](https://github.com/prisma/prisma/issues/3648) - [Unable to connect when connection string contains $](https://github.com/prisma/prisma/issues/3669) - [Implement a `findFirst` API](https://github.com/prisma/prisma/issues/3676) ### [`prisma-client-js`](https://github.com/prisma/prisma-client-js) - [Running into an issue with the connectOrCreate operation. The following query should create an entity for a Winery, and assign a Tag to it.](https://github.com/prisma/prisma-client-js/issues/764) - [Integration Tests, Errors: Writing a signed Int to an unsigned column](https://github.com/prisma/prisma-client-js/issues/820) - [ErrorFormat 'colorless' doesn't work](https://github.com/prisma/prisma-client-js/issues/885) ### [`language-tools`](https://github.com/prisma/language-tools) - [Add option to set the `prisma-fmt` binary path in vscode options](https://github.com/prisma/language-tools/issues/235) - [Warn about syntax error in datasource url (with env var) earlier #3509](https://github.com/prisma/language-tools/issues/448) - [Slack notifications for failing workflows](https://github.com/prisma/language-tools/issues/471) - [Quick Fix adding native Types preview Feature when using native types](https://github.com/prisma/language-tools/issues/472) - [Extension panic because of comments](https://github.com/prisma/language-tools/issues/473) - [Move e2e tests for published extension in this repo instead of in vscode-e2e-tests](https://github.com/prisma/language-tools/issues/477) - [Prisma extension formatting failure and freeze after upgrade 2.7.1 and VS v1.49.1](https://github.com/prisma/language-tools/issues/481) - [Add number of CI step in visible name of workflow](https://github.com/prisma/language-tools/issues/486) ### [`studio`](https://github.com/prisma/studio) - [Can't filter by null values](https://github.com/prisma/studio/issues/549) - [Show *why* a table cell is invalid](https://github.com/prisma/studio/issues/550) - [Improve error modals](https://github.com/prisma/studio/issues/552) ### [`prisma-engines`](https://github.com/prisma/prisma-engines) - [Add tests using Cockroach DB ](https://github.com/prisma/prisma-engines/issues/900) - [Add tests using Yugabyte DB](https://github.com/prisma/prisma-engines/issues/901) - [Add test cases for the DMMF command](https://github.com/prisma/prisma-engines/issues/1048) - [Query Engine: Investigate how we could support union types](https://github.com/prisma/prisma-engines/issues/1088) - [After upload: Download binary builds from S3 again and verify expected checksum](https://github.com/prisma/prisma-engines/issues/1104) - [Incorrect error message on missing native Type previewFeature](https://github.com/prisma/prisma-engines/issues/1127) ## ❓ Are you using Prisma at work? We'd love to know if you're using Prisma at work. Answer with a quick **yes** or **no** in our [poll](https://prisma103696.typeform.com/to/sXYraQzA), it won't take longer than a few seconds! ## Credits Huge thanks to @nohns for some great contributions in this release!