Prisma 4.14.0 — Release Notes & Engineering Impact

🌟 **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%20v4.14.0%20%F0%9F%9A%80%0D%0A%0D%0Ahttps://github.com/prisma/prisma/releases/tag/4.14.0) about the release.** 🌟 ## Request for feedback for Preview features We would appreciate your feedback on a handful of [Preview features](https://www.prisma.io/docs/about/prisma/releases#preview) to help us move them to [General Availability](https://www.prisma.io/docs/about/prisma/releases#generally-available-ga) soon. The Preview features include: - [PostgreSQL extensions](https://github.com/prisma/prisma/issues/15835) - [Extended where unique](https://github.com/prisma/prisma/issues/15837) - [Field reference support](https://github.com/prisma/prisma/issues/15068) - [Order by Nulls](https://github.com/prisma/prisma/issues/14377) - [Count by filtered relation](https://github.com/prisma/prisma/issues/15069) You can test them by enabling the Preview feature in your Prisma schema and giving them a try already in your Prisma schema, e.g., PostgreSQL extensions, or regenerating Prisma Client and trying them in your queries. ## Highlights ### Improved Prisma Client startup performance For the last couple of months, we've been working hard to improve the performance of Prisma Client. We also published a blog post on how [How We Sped Up Serverless Cold Starts with Prisma by 9x](https://www.prisma.io/blog/prisma-and-serverless-73hbgKnZ6t), which we recommend you give it a read. This release continues with the same theme by making the size of the generated Prisma Client smaller. We have roughly halved the size of Prisma Client's dependencies. ### More Introspection warnings for unsupported features In [4.13.0](https://github.com/prisma/prisma/releases/tag/4.13.0), we introduced the first 6 introspection warnings that surface the existence of these features in your database and link to our documentation on how to manually work around the Prisma Schema with unsupported database features. In this release, we added 3 more introspection warnings for the following features: - [Check Constraints](https://github.com/prisma/prisma/issues/3388) (MySQL + PostgreSQL) - [Exclusion Constraints](https://github.com/prisma/prisma/issues/17514) - [MongoDB $jsonSchema](https://github.com/prisma/prisma/issues/8135) On introspecting a database using any of these features, you will get a warning from the Prisma CLI and a comment in your Prisma schema where the feature is being used. The warning will also contain a link to instructions on how to manually use the feature. ## Fixes and improvements ### Prisma Client - [Generator output `client` leads to `Error: ENOENT: no such file or directory, open '.../node_modules/@prisma/client/schema.prisma'`](https://github.com/prisma/prisma/issues/12295) - [DeprecationWarning: Implicit coercion to integer for exit code is deprecated](https://github.com/prisma/prisma/issues/17127) - [`thread 'tokio-runtime-worker' panicked at 'internal error: entered unreachable code: No unsupported field should reach that path', query-engine\connectors\sql-query-connector\src\model_extensions\scalar_field.rs:70:44`](https://github.com/prisma/prisma/issues/18517) - [jsonProtocol: `in` argument of filter types does not accept scalars](https://github.com/prisma/prisma/issues/18549) - [`jsonProtocol` should report errors as nicely as before](https://github.com/prisma/prisma/issues/18876) - [Generated client with custom path containing string `client`: `ENOENT: no such file or directory, open 'D:\<projectpath>\node_modules\.prisma\client\schema.prisma`](https://github.com/prisma/prisma/issues/12719) - [Can't find the schema when the project path contains the same name as the generated client folder](https://github.com/prisma/prisma/issues/11206) ### Prisma Migrate - [Build all glibc Linux binaries with CentOS 7](https://github.com/prisma/prisma/issues/16772) - [Remove `Please create an issue ...` in `MigrateEngine.ts`](https://github.com/prisma/prisma/issues/17268) - [Do not introspect exclusion constraints as Gist indexes](https://github.com/prisma/prisma/issues/17515) - [Introspection warnings: move rendering from `DbPull.ts` to the engine ](https://github.com/prisma/prisma/issues/17582) - [views: don't create local `views` folder on introspection if no views are found](https://github.com/prisma/prisma/issues/18611) - [RelationMode autocomplete uses incorrect casing](https://github.com/prisma/prisma/issues/18983) ### Language tools (e.g. VS Code) - [Support for VSCode Region Marker Folding](https://github.com/prisma/language-tools/issues/1382) ## Credits Huge thanks to @RobertCraigie, @KhooHaoYit, @art049, @luxaritas, @mrazauskas for helping! ## 📺 Join us for another "What's new in Prisma" live stream Learn about the latest release and other news from the Prisma community by joining us for another ["What's new in Prisma"](https://youtube.com/playlist?list=PLn2e1F9Rfr6l1B9RP0A9NdX7i7QIWfBa7) live stream. The stream takes place [on YouTube](https://youtu.be/JvLTpSINZdA) on **Thursday, May 11** at **5 pm Berlin | 8 am San Francisco**.