Prisma 3.2.0 — Release Notes & Engineering Impact

Today, we are excited to share the `3.2.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%20@prisma%20release%20v3.2.0%20%F0%9F%9A%80%0D%0A%0D%0Ahttps://github.com/prisma/prisma/releases/tag/3.2.0) about the release.** 🌟  ## Major improvements & new features ### MongoDB introspection support is now in Preview 🚀 In this version, we introduce support for introspecting MongoDB databases. If adding Prisma to an existing project, running `prisma db pull` against a MongoDB database with _existing data_ will sample the data and create a Prisma data model based on the stored documents. This comes with a few caveats: - The preview feature `mongoDb` must be enabled on the `generator` block in the Prisma schema. - The MongoDB instance must have at least one collection with at least one document. - To introspect indices, there must be at least one document in the collection with the indexed fields. - If any fields have conflicting types, the most common type is chosen and the other types are written to a comment above the field in the Prisma schema. - Relations must be added manually after introspection. - Running `prisma db pull` multiple times will overwrite any manual changes to the data model for now. We're constantly iterating on this feature, so please provide [feedback](https://github.com/prisma/prisma/issues/8241) for introspecting MongoDB databases! ### Get the count of a relation in MongoDB This release, we're giving MongoDB developers the ability to query the count of a relation. In the example below, we're getting the number of posts each user wrote: ```js const userWithPostsCount = await prisma.user.findMany({ include: { _count: { select: { posts: true }, }, }, }) // => [ // { // email: "[email protected]", // _count: { posts: 3 } // } // ] ``` This feature was previously available for SQL databases and now it's also available in MongoDB. Learn more in [our documentation](https://www.prisma.io/docs/concepts/components/prisma-client/aggregation-grouping-summarizing/#count). ## Fixes and improvements ### Prisma Migrate - [MongoDB: Support introspection](https://github.com/prisma/prisma/issues/6787) - [Inconsistent errors with different commands](https://github.com/prisma/prisma/issues/8013) - [Drift detection makes CLI output where bold](https://github.com/prisma/prisma/issues/8063) - [Unable to specify a double quote in a string default value](https://github.com/prisma/prisma/issues/8902) - [On database reset in a new project, I get a seeding configuration warning](https://github.com/prisma/prisma/issues/9203) - [Seeding seems to swallow errors](https://github.com/prisma/prisma/issues/9286) - [Hit an unwrap() panic in datamodel-connector](https://github.com/prisma/prisma/issues/9308) - [Running db pull after upgrading to 3.x removed name from @@unique](https://github.com/prisma/prisma/issues/9318) - [`prisma db -h` still mentions `seed` as a preview feature](https://github.com/prisma/prisma/issues/9401) - [MDBI: Show a helpful error message when developers try to re-introspect a MongoDB database](https://github.com/prisma/prisma/issues/9557) - [(migrate) Print migration names as they are being applied](https://github.com/prisma/prisma/issues/9580) ### Prisma Client - [.gitignore is being overwrittern by `prisma init`](https://github.com/prisma/prisma/issues/8496) - [CFW: Create a prototype of the generated Prisma Client that runs inside Cloudflare Workers](https://github.com/prisma/prisma/issues/8884) - [Make engineType configurable via an environment variable](https://github.com/prisma/prisma/issues/9411) ### Prisma - [MongoDB: `selectRelationCount` (since 2.20.0)](https://github.com/prisma/prisma/issues/9159) ### Prisma Studio - [Studio should pin prisma dependencies to avoid problems during `prisma` patch releases.](https://github.com/prisma/studio/issues/766) ## Credits Huge thanks to @otan, @cbuchacher for helping out in this release! ## CTA ## 📺 Join us for another "What's new in Prisma" livestream Learn about the latest release and other news from the Prisma community by joining us for another ["What's new in Prisma"](https://www.youtube.com/watch?v=2TLyIvaiSCg&ab_channel=Prisma) livestream. The stream takes place [on Youtube](https://www.youtube.com/watch?v=2TLyIvaiSCg&ab_channel=Prisma) on **Thursday, October 07** at **5pm Berlin | 8am San Francisco**.