Prisma 2.7.0 — Release Notes & Engineering Impact

Today we are excited to share the `2.7.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.7.0%20%F0%9F%9A%80%0D%0A%0D%0Ahttps://github.com/prisma/prisma/releases/tag/2.7.0) about the release.** ## Major improvements ### Prisma Studio is stable 🎉 We are more than excited to share that Prisma Studio has moved out of its experimental state and is promoted to stable with today's release! Prisma Studio is the perfect companion for developers who work with databases in their daily workflows, to quickly get an overview of the state of their database as well as to view and modify the data in it. An announcement blog post will be coming soon! To use Prisma Studio in your Prisma project, you can now run the `prisma studio` command without the previously required `--experimental` flag: ``` npx prisma studio ``` Join the [#prisma-studio](https://app.slack.com/client/T0MQBS8JG/C01ACF1DJ1M) channel in the [Prisma Slack](https://slack.prisma.io/) and let us know how you like Prisma Studio! 🙌 ### Configure Prisma schema location via `package.json` for more flexibility Previously, your `schema.prisma` file needed to be available at a specific location when running Prisma CLI commands or provided via the `--schema` option when invoking a Prisma CLI command. With this release, you can configure the location of your Prisma schema via a `prisma` property in your `package.json`: ```json { "prisma": { "schema": "path/to/schema.prisma" } } ``` The provided location in `package.json` will be the default location of the Prisma schema file for any Prisma CLI command you invoke. Note that you can still override this default location by manually specifying the `--schema` option when invoking a Prisma CLI command. 📚 **Documentation:** [Prisma schema file location](https://www.prisma.io/docs/reference/tools-and-interfaces/prisma-schema#prisma-schema-file-location) ### 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.5.0`](https://github.com/prisma/prisma/releases/tag/2.5.0) we introduced one preview feature, namely `insensitiveFilters`. - 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. ## Feedback wanted: How does introspection work for you? In the last few releases we improved Prisma's database introspection, most notably with ["More robust introspection by keeping manual changes in the Prisma schema file"](https://github.com/prisma/prisma/releases/tag/2.6.0) but also many smaller bug fixes. We think it is pretty stable now, and would love to hear from you, our users, how you have been using prisma introspect recently! If you have used introspection in the past, whether it worked well or not so well with your database, [**please let us know**](https://github.com/prisma/prisma/issues/3659) by sharing your feedback on GitHub! ## 🌟 Help us spread the word about Prisma To help spread the word about Prisma, we'd very much appreciate if you would **star this repo** 🌟 And if you're excited about the features in this week's release, then help us and [share it on Twitter](https://twitter.com/intent/tweet?text=Check%20out%20the%20latest%20Prisma%20release%202.7.0%20%F0%9F%9A%80%0D%0A%0D%0Ahttps://github.com/prisma/prisma/releases/tag/2.7.0). ## Fixes and improvements ### [`prisma`](https://github.com/prisma/prisma) - [Add ability to configure custom schema location instead of requiring `--schema` arg](https://github.com/prisma/prisma/issues/3144) - [Running `prisma init` with unknown parameter just outputs `null`](https://github.com/prisma/prisma/issues/3172) - [Use dotenv-expand instead of dotenv package to allow variable expressions in the env file](https://github.com/prisma/prisma/issues/3310) - [Update denylist in engines and client](https://github.com/prisma/prisma/issues/3338) - [Engine panics when schema.prisma is empty, we could make it an error.](https://github.com/prisma/prisma/issues/3376) - [Schema parser errors shouldn't be reported to error reporting](https://github.com/prisma/prisma/issues/3377) - [Loss of precision on Float fields with many digits](https://github.com/prisma/prisma/issues/3479) - [2.6.0 Broke some of my update queries](https://github.com/prisma/prisma/issues/3497) - [Log Prisma client version being generated](https://github.com/prisma/prisma/issues/3500) - [Broken `set` on nested update on 2.6.0](https://github.com/prisma/prisma/issues/3503) - [Multiple many-many relationships appears to cause an introspection failure.](https://github.com/prisma/prisma/issues/3507) - [Query validation error updating Date field](https://github.com/prisma/prisma/issues/3512) - [Error: [libs/datamodel/core/src/dml/model.rs:166:14] We assume an internally valid datamodel before mutating. ](https://github.com/prisma/prisma/issues/3516) - [While using PM2 on a prisma related project popus up prisma client cmd terminal on windows ](https://github.com/prisma/prisma/issues/3521) - [Separate command and GH action workflow to run integration tests ](https://github.com/prisma/prisma/issues/3524) - [The `introspect` command in v2.6.x does not remember `cuid()` defaults for a field and user-defined @relation `name` property](https://github.com/prisma/prisma/issues/3526) - [Do not run GitHub Action Workflows on fork of example repository](https://github.com/prisma/prisma/issues/3539) - [Do not build binaries for FreeBSD 12 any more](https://github.com/prisma/prisma/issues/3558) - [`introspect --force` does not work](https://github.com/prisma/prisma/issues/3591) ### [`prisma-client-js`](https://github.com/prisma/prisma-client-js) - [PANIC: invalid or out-of-range date](https://github.com/prisma/prisma-client-js/issues/849) - [aggregateApi and sum returns null if no record](https://github.com/prisma/prisma-client-js/issues/855) ### [`migrate`](https://github.com/prisma/migrate) - [Unable to run prisma migrate with dotenv-cli](https://github.com/prisma/migrate/issues/570) - [Error when running initial migration with a schema in DATABASE_URL](https://github.com/prisma/migrate/issues/572) ### [`language-tools`](https://github.com/prisma/language-tools) - [Add vsix bundle to releases](https://github.com/prisma/language-tools/issues/366) - [Create a local release with .vsix file and publish from that](https://github.com/prisma/language-tools/issues/408) - [E2E tests run on every PR should use local LSP](https://github.com/prisma/language-tools/issues/440) - [Abnormal CPU usage](https://github.com/prisma/language-tools/issues/447) - [Change of `client/index.d.ts` should not show a notification](https://github.com/prisma/language-tools/issues/451) - [This version is built from commit undefined. This is for Prisma CLI ...](https://github.com/prisma/language-tools/issues/457) - [Reorganize READMEs](https://github.com/prisma/language-tools/issues/458) ### [`studio`](https://github.com/prisma/studio) - [Stuck at "Getting things ready" when Studio is open in multiple places](https://github.com/prisma/studio/issues/454) - [Filtering issue (not/equals/contains/startsWith) when "" empty string field Value ](https://github.com/prisma/studio/issues/528) - [Error when opening certain relations](https://github.com/prisma/studio/issues/530) - [Tab dirtyness should be cancelled out when it is returned to its original state](https://github.com/prisma/studio/issues/531) - [Cannot edit a relation that is `null`](https://github.com/prisma/studio/issues/532) - [Allow typing in partial dates in table cells](https://github.com/prisma/studio/issues/534) - [Allow typing in partial dates in filters](https://github.com/prisma/studio/issues/535) - [Very slow to load for large Postgres schemas](https://github.com/prisma/studio/issues/536) - [When changing a relation, the scalar that constitutes it does not change](https://github.com/prisma/studio/issues/538) - [Unable to change relations & relation lists in an uncommitted record](https://github.com/prisma/studio/issues/539) - [If you type in an arbitrary id in a scalar that is part of a relation, `Save Changes` will always fail](https://github.com/prisma/studio/issues/540) - [Oopsies: filter UI is broken](https://github.com/prisma/studio/issues/543) - [Deleting a model with unsaved changes open in a tab might result in a fatal error](https://github.com/prisma/studio/issues/545) ### [`prisma-engines`](https://github.com/prisma/prisma-engines) - [Improve error for nonexistent column in SQLite](https://github.com/prisma/prisma-engines/issues/874) - [Native types: allow specifying unsigned integer types on MySQL](https://github.com/prisma/prisma-engines/issues/1068) - [Validate that prisma enums have at least one variant/value](https://github.com/prisma/prisma-engines/issues/1070) - [Parser must error if native types are used but feature flag is not enabled](https://github.com/prisma/prisma-engines/issues/1085) - [Trigger binary builds via square brackets in commit message](https://github.com/prisma/prisma-engines/issues/1103) ## Credits Huge thanks to @bre7, @rahul3v, @jasonkuhrt and @Weakky for helping!