Prisma 3.3.0 — Release Notes & Engineering Impact

Today, we are excited to share the `3.3.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.3.0%20%F0%9F%9A%80%0D%0A%0D%0Ahttps://github.com/prisma/prisma/releases/tag/3.3.0) about the release.** 🌟  ## Major improvements & new features ### Prisma **Data Proxy support in Prisma Client in Early Access, now with support for Cloudflare Workers** In `3.3.0`, we're releasing [Early Access](https://www.prisma.io/docs/about/prisma/releases#early-access) support for Prisma Client connection pooling using Prisma Data Proxy. The Data Proxy feature of the Prisma Data Platform is now accessible to all users of the Prisma Data Platform (no need to request access). #### Solving connection management for serverless environments Prisma Data Proxy is an intermediary between your app and your database. It manages connection pooling, so you can reliably use traditional databases in Serverless environments. Users can configure a Data Proxy for free on the Prisma Data Platform and connect their Prisma applications to the proxy by enabling the feature flag for it in their code. For detailed documentation and instructions please refer to [pris.ly/data-proxy](https://pris.ly/data-proxy). #### Running Prisma applications in Cloudflare Workers Using this new feature in Prisma Client and leveraging the ~~Prisma~~ Data Proxy, developers can now deploy Prisma applications on [Cloudflare Workers](https://workers.cloudflare.com/). Here's what it looks like to use Prisma Client inside of this environment: ```ts import { PrismaClient } from '@prisma/client' const prisma = new PrismaClient() addEventListener('fetch', (event) => { event.respondWith(handleRequest(event.request)) }) async function handleRequest(request: Request): Promise<Response> { await prisma.log.create({ data: { level: 'Info', message: `${request.method} ${request.url}`, }, }) return new Response(`request method: ${request.method}!`) } ``` Follow [this deployment guide](https://www.prisma.io/docs/guides/deployment/deployment-guides/deploying-to-cloudflare-workers) to learn how to use Prisma Client with your own Cloudflare Workers. If you run into any problems, you can reach us in [this issue](https://github.com/prisma/prisma/issues/9841)! ### MongoDB #### Support for ordering by relation fields In [`2.16.0`](https://github.com/prisma/prisma/releases/2.16.0), we first introduced ordering by a relation for relational databases. As of today's release, you can now order by a relation field in MongoDB as well: ```ts // Return a list of posts ordered by the author's email address // in ascending order. await prisma.post.findMany({ orderBy: { author: { email: "asc", }, }, }) ``` Learn more in [our documentation](https://www.prisma.io/docs/concepts/components/prisma-client/filtering-and-sorting#sort-by-relation). #### MongoDB 5 is now supported Prisma now supports connecting to MongoDB 5 databases. Take advantage of the latest and greatest from the fine folks at MongoDB HQ! ### Fixed optional timestamp column creation for MySQL in Prisma Migrate When working with optional timestamp fields in MySQL, there were cases where the database implicitly set the column to `NOT NULL`. To fix this behavior, we are now explicitly creating the columns as nullable. You can find the full details about this change [on GitHub](https://github.com/prisma/prisma/issues/9438). ### Prisma Client Go now supports scalar list operations With `3.3.0`, you can now filter and atomically update scalar lists with Prisma Client Go. Given the following Prisma schema: ```prisma model User { id Int @id @default(autoincrement()) name String pets String[] } ``` You can filter pets with the following code: ```go user, err := client.User.FindFirst( db.User.Pets.HasSome([]string{"Fido", "Scooby"}), ).Exec(ctx) ``` And when you add a new furry addition to your family, you can update your list with `Push`: ```go user, err := client.User.FindUnique( db.User.Name.Equals(1), ).Update( db.User.Items.Push([]string{"Charlemagne"}), ).Exec(ctx) ``` Learn more about how to use this new feature in [our documentation](https://github.com/prisma/prisma-client-go/blob/main/docs/reference/12-scalar-lists.md). To dive deeper into the concept of scalar lists, you can read the guide on [Working with scalar lists](https://www.prisma.io/docs/concepts/components/prisma-client/working-with-fields/working-with-scalar-lists-arrays). ## Fixes and improvements ### Prisma Migrate - [Error: [libs/datamodel/connectors/dml/src/model.rs:161:64] Could not find relation field clubs_clubsTousers on model User. ](https://github.com/prisma/prisma/issues/6737) - [Error: [libs/datamodel/connectors/dml/src/model.rs:161:64] Could not find relation field Trade_OrderToTrade on model Order. ](https://github.com/prisma/prisma/issues/7600) - [Support for application_name argument in connection URL for postgres](https://github.com/prisma/prisma/issues/7804) - [Revise CONTRIBUTING.md](https://github.com/prisma/prisma/issues/8457) - [MDBE: Adjust the parser to support the new complex `type` construct](https://github.com/prisma/prisma/issues/8603) - [Constraint names are not validated against different constraint types](https://github.com/prisma/prisma/issues/8760) - [Patch releases: Creation of tags on prisma-engines fails](https://github.com/prisma/prisma/issues/9013) - [thread '<unnamed>' panicked at 'Every RelationInfo should have a complementary RelationInfo on the opposite relation field.'](https://github.com/prisma/prisma/issues/9141) - [Add ESM compatible TypeScript command for db seed help output](https://github.com/prisma/prisma/issues/9142) - [Re-Introspection changes order of blocks in schema (e.g. in default `schema.prisma` from `prisma init`)](https://github.com/prisma/prisma/issues/9261) - [Different drift/reset handling on first Migration/no migration table](https://github.com/prisma/prisma/issues/9310) - [Constraint identifiers created by `prisma migrate dev` exceeding 63 characters causing errors due to truncating](https://github.com/prisma/prisma/issues/9415) - ['DateTime?' does NOT create nullable field](https://github.com/prisma/prisma/issues/9438) - [Remove SQL Server preview from `prisma init`](https://github.com/prisma/prisma/issues/9441) - [Panicked on invalid Relation ](https://github.com/prisma/prisma/issues/9536) - [MDBI: Update the inconsistent data warning to include an issue where people can discuss what they need](https://github.com/prisma/prisma/issues/9558) - [Prisma generate started throwing that libssl.so.3 is missing (alpine 3.14, node 14)](https://github.com/prisma/prisma/issues/9624) ### Prisma Client - [`init --url ...` logs full connection URL when .env already exists](https://github.com/prisma/prisma/issues/7718) - [JSON field can not query for "not equals"](https://github.com/prisma/prisma/issues/7836) - [MBDGA: Support Order By Relations in MongoDB ](https://github.com/prisma/prisma/issues/9158) - [Support MongoDB 5.0](https://github.com/prisma/prisma/issues/9230) - [CFW: Add a preview feature guard in the Prisma CLI](https://github.com/prisma/prisma/issues/9618) ### Language tools (e.g. VS Code) - [Extension for 3.2.0 did not successfully get published](https://github.com/prisma/language-tools/issues/904) ## 📺 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://www.youtube.com/watch?v=Ufe_tI_jJs8) live stream. The stream takes place [on Youtube](https://www.youtube.com/watch?v=Ufe_tI_jJs8) on **Thursday, October 21** at **5pm Berlin | 8am San Francisco**. ## Credits Huge thanks to @otan for helping!