Prisma 2.27.0 — Release Notes & Engineering Impact

Today, we are excited to share the `2.27.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%20v2.27.0%20%F0%9F%9A%80%0D%0A%0D%0Ahttps://github.com/prisma/prisma/releases/tag/2.27.0) about the release.** 🌟  ## Major improvements & new features ### MongoDB is Now in Preview 🎉 We're thrilled to announce that Prisma now has [Preview support](https://www.prisma.io/docs/about/releases/#preview) for [MongoDB](https://mongodb.com). Here's how to get started: Inside your `schema.prisma` file, you'll need to set the database provider to `mongodb`. You'll also need to add `mongoDb` to the `previewFeatures` property in the `generator` block: ```prisma // Set the database provider to "mongodb" datasource db { provider = "mongodb" url = env("DATABASE_URL") } // We want to generate a Prisma Client // Since mongodb is a preview feature, we need to enable it. generator client { provider = "prisma-client-js" previewFeatures = ["mongoDb"] } // Create our Post model which will be mapped to a collection in the database. // All posts have a required `title`, `slug` and `body` fields. // The id attributes tell Prisma it's a primary key and to generate // object ids by default when inserting posts. model Post { id String @id @default(dbgenerated()) @map("_id") @db.ObjectId slug String @unique title String body String } ``` Next, you'll need to add a database connection string to your `.env` file. We recommend using [MongoDB Atlas](https://www.mongodb.com/cloud/atlas) to spin up a MongoDB database for free. Set the `DATABASE_URL` to the connection string you got from MongoDB Atlas, it should be similar to the following string: ```env DATABASE_URL="mongodb+srv://admin:<password>@cluster0.quvqo.mongodb.net/myFirstDatabase?retryWrites=true&w=majority" ``` > ❗️ Don't forget to include the username and password you set while creating the database in the connection string, otherwise you won't be able to connect to it. Then you can run `npx prisma generate` to generate a MongoDB-compatible Prisma Client. The Prisma Client API is the same for Mongo as it is for other supported relational databases (PostgreSQL, MySQL, SQLite and Microsoft SQL Server). To test that everything works, you can run the following script: ```js import { PrismaClient } from "@prisma/client" const prisma = new PrismaClient() async function main() { // Create the first post await prisma.post.create({ data: { title: "Prisma <3 MongoDB", slug: "prisma-loves-mongodb", body: "This is my first post. Isn't MongoDB + Prisma awesome?!", }, }) // Log our posts showing nested structures console.dir(posts, { depth: Infinity }) } main() .catch(console.error) .finally(() => prisma.$disconnect()) ``` You should see a new post created and added to your database! You can use [Prisma Studio](https://prisma.io/studio) to view the record you just added by running `npx prisma studio`. This is just the tip of the iceberg. Learn more in our [Getting Started Guide](https://prisma.io/docs/getting-started/setup-prisma/start-from-scratch/mongodb-typescript-mongodb). We would love to know your feedback! If you have any comments or run into any problems we're available in [this issue](https://github.com/prisma/prisma/issues/8241). You can also browse existing issues that have the [MongoDB label](https://github.com/prisma/prisma/issues?q=is%3Aissue+is%3Aopen+sort%3Aupdated-desc+label%3A%22topic%3A+mongodb%22). ### Prisma native support for M1 Macs 🚀 This one's for our Mac users. Prisma now runs natively on the new M1 chips. Best of all, there's nothing to configure, it just works. Enjoy the speed bump! ## Fixes and improvements ### Prisma Client - [Provide precompiled binaries for Mac's M1 ARM architecture](https://github.com/prisma/prisma/issues/5245) - [Prisma Format: Fill in native type attributes on foreign key relations](https://github.com/prisma/prisma/issues/6717) - [Entity types cannot be resolved in PNPM monorepo](https://github.com/prisma/prisma/issues/7484) - [2.26.0 and `pnpm` do not play well together](https://github.com/prisma/prisma/issues/7934) - [LRT: Break down the design into discrete tasks](https://github.com/prisma/prisma/issues/7957) ### Prisma Migrate - [Handle error `ERROR 70100 (1317): foreign key constraints are not allowed, see https://code.openark.org/blog/mysql/the-problem-with-mysql-foreign-key-constraints-in-online-schema-changes`](https://github.com/prisma/prisma/issues/7384) - [Handle error `ERROR HY000 (1105): direct DDL is disabled`](https://github.com/prisma/prisma/issues/7385) - [db push --force-reset is not creating database if it doesn't exist](https://github.com/prisma/prisma/issues/7440) - [Migrate tries to drop + recreate column when changing type from TEXT -> CITEXT (Postgres)](https://github.com/prisma/prisma/issues/7536) - [SQL Server Introspection lists XML indices which are then rejected by schema validation](https://github.com/prisma/prisma/issues/7571) - [`migrate dev` and PostGis Views](https://github.com/prisma/prisma/issues/7764) - [DB pull & migration doesn't work for MongoDB](https://github.com/prisma/prisma/issues/7849) - [`prisma init` for datasource providers in Preview/EarlyAccess](https://github.com/prisma/prisma/issues/7900) - [referentialActions: Only underline offending part of line when using referential actions, but not having preview feature enabled](https://github.com/prisma/prisma/issues/7947) - [Better error when introspecting MongoDB](https://github.com/prisma/prisma/issues/8012) ## 📺 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=Z_EcSt_0U0o) livestream. The stream takes place [on Youtube](https://www.youtube.com/watch?v=Z_EcSt_0U0o) on **Thursday, July 15** at **5pm Berlin | 8am San Francisco**.