Prisma 3.15.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%20v3.15.0%20%F0%9F%9A%80%0D%0A%0D%0Ahttps://github.com/prisma/prisma/releases/tag/3.15.0) about the release.** 🌟 ## Major improvements ### Improvements to Prisma Client for Data Proxy In this release, we're shipping a couple of improvements to Prisma Client for Data Proxy. The [Prisma Data Proxy](https://www.prisma.io/docs/concepts/data-platform/data-proxy) provides connection management and pooling for database connections for efficiently scaling database connections in serverless environments. The Prisma Client for Data Proxy provides support for connecting to the Prisma Data Proxy using HTTP. We introduced this feature in version [`3.3.0`](https://github.com/prisma/prisma/releases/tag/3.3.0) and constantly shipped features, fixes, and improvements. One of the changes in this release is improving the Prisma Client for the Data Proxy generation step. ```diff datasource db { provider = "postgresql" url = env("DATABASE_URL") } generator client { provider = "prisma-client-js" - previewFeatures = ["dataProxy"] } ``` You can generate Prisma Client for the Data Proxy it by using the `--data-proxy` flag: ```bash npx prisma generate --data-proxy ``` We also updated how you can run Prisma Client using the Data Proxy in [Cloudflare Workers and Edge](https://www.prisma.io/docs/guides/deployment/deployment-guides/deploying-to-cloudflare-workers) environments. You can now use `@prisma/client/edge` instead of `@prisma/client` in your application. ```ts import { PrismaClient } from '@prisma/client/edge' ``` To learn more, check out our [documentation](https://www.prisma.io/docs/concepts/data-platform/data-proxy). ### Prisma Client Metrics is now in Preview Metrics is a new Preview feature that allows you to monitor how Prisma Client interacts with your database. Metrics expose a set of counters, gauges, and histograms that can be labeled and piped into an external monitoring system like [Prometheus](https://prometheus.io/) or [StatsD](https://github.com/statsd/statsd). You can use metrics in your project to help diagnose how your application's number of idle and active connections changes with counters, gauges, and histograms. To get started using metrics in your project, enable the Preview feature flag in your Prisma schema: ```prisma generator client { provider = "prisma-client-js" previewFeatures = ["metrics"] } ``` You can then get started using metrics in your project: ```ts import { PrismaClient } from '@prisma/client' const prisma = new PrismaClient() const metrics = await prisma.$metrics.json() console.log(metrics) ``` To learn more, check out the metrics [documentation](https://www.prisma.io/docs/guides/performance-and-optimization/metrics). Give it a try and [let us know what you think](https://github.com/prisma/prisma/issues/13579). ## Regression ### Azure SQL on MacOS This release includes a known regression when connecting to Azure SQL from MacOS only and will be resolved soon. Follow [this issue for updates and resolution](https://github.com/prisma/prisma/issues/13673). ## Fixes and improvements ### `migrate reset` returns with a non-0 exit code if the seed script returns with a non-0 exit code This will help user scripts know more about the success of the command, but might break existing scripts. ### Prisma - [Schema validation does not accept absolute Windows style paths for SQLite database](https://github.com/prisma/prisma/issues/6472) - [`introspect --url` throws error if existing schema file only contains `generator`](https://github.com/prisma/prisma/issues/8317) - [`prisma migrate reset` always exits with `0`, needs to exit with `1` on errors](https://github.com/prisma/prisma/issues/9786) - [Error: Error in migration engine. Reason: [migration-engine/connectors/sql-migration-connector/src/sql_schema_differ/differ_database.rs:111:9] no entry found for key ](https://github.com/prisma/prisma/issues/10557) - [Error: Error in migration engine. Reason: [migration-engine/connectors/sql-migration-connector/src/sql_schema_differ/differ_database.rs:111:9] no entry found for key ](https://github.com/prisma/prisma/issues/10558) - [Error: Error in migration engine. Reason: [migration-engine/connectors/sql-migration-connector/src/sql_schema_differ/differ_database.rs:111:9] no entry found for key ](https://github.com/prisma/prisma/issues/11011) - [`Would you like to create a Github issue? » Yes` does nothing in terminal on Windows](https://github.com/prisma/prisma/issues/11373) - [Error: [/rustc/f1edd0429582dd29cccacaf50fd134b05593bd9c/library/core/src/str/mod.rs:580:13] byte index 59 is not a char boundary; it is inside '....' (bytes 57..60) of `患者ID` ](https://github.com/prisma/prisma/issues/11456) - [Schema Parsing/Validation error should include CLI version](https://github.com/prisma/prisma/issues/11908) - [Prisma panic on invalid int](https://github.com/prisma/prisma/issues/12526) - [Error: [/rustc/9d1b2106e23b1abd32fce1f17267604a5102f57a/library/core/src/str/mod.rs:584:13] byte index 47 is not a char boundary; it is inside '点' (bytes 46..49) of `AirbyteRawYuriPagesAirbyteDataProperties推荐点RichText` ](https://github.com/prisma/prisma/issues/12727) - [Introspection: Make SQL in tests more advanced so that Introspection results will include native types, not just scalar types](https://github.com/prisma/prisma/issues/13180) - [Add more integration tests for CockroachDB for `db` and `migrate` commands](https://github.com/prisma/prisma/issues/13268) - [MongoDB - prisma db pull](https://github.com/prisma/prisma/issues/13294) - [Multi-byte character truncation bug in mongo introspection connector](https://github.com/prisma/prisma/issues/13351) - [MSSQL Docker Run Migration "The Trust Settings Record was corrupted"](https://github.com/prisma/prisma/issues/13371) - [Running DB Pull on Remote MSSQL database](https://github.com/prisma/prisma/issues/13372) - [Error: Error in migration engine. Reason: [libs/sql-schema-describer/src/postgres.rs:1039:28] no entry found for key ](https://github.com/prisma/prisma/issues/13520) - [Error: [libs\sql-schema-describer\src\postgres.rs:1039:28] no entry found for key ](https://github.com/prisma/prisma/issues/13521) - [prisma migrate deploy error](https://github.com/prisma/prisma/issues/13603) ### Prisma Client - [Support Bytes on SQLite](https://github.com/prisma/prisma/issues/6666) - [PANIC: called `Option::unwrap()` on a `None` value in query-engine/core/src/query_document/parser.rs:250:87](https://github.com/prisma/prisma/issues/9896) - [Huge Int value in `upsert` causes: "PANIC: called `Option::unwrap()` on a `None` value in query-engine/core/src/query_document/parser.rs:250:87"](https://github.com/prisma/prisma/issues/10049) - [Data Proxy Client should't need to be re-generated after modifying `.env` files](https://github.com/prisma/prisma/issues/10187) - [Data Proxy Client stopped working in Vercel Edge Functions / Next 12.0.4](https://github.com/prisma/prisma/issues/10305) - [PANIC: called `Option::unwrap()` on a `None` value in query-engine\core\src\query_document\parser.rs:250:87](https://github.com/prisma/prisma/issues/10586) - [Data Proxy: `prisma generate` errors with `Error: Error: ENOENT: no such file or directory, open '/[...]/prisma/schema.prisma'` when using a custom name for the Prisma schema file](https://github.com/prisma/prisma/issues/10936) - [PANIC: called `Option::unwrap()` on a `None` value in query-engine/core/src/query_document/parser.rs:250:87](https://github.com/prisma/prisma/issues/11263) - [DATABASE_URL is baked in Dataproxy client proxy.js ](https://github.com/prisma/prisma/issues/11458) - [PANIC: called `Option::unwrap()` on a `None` value in query-engine/core/src/query_document/parser.rs:250:87](https://github.com/prisma/prisma/issues/11467) - [Can't save string to Decimals list](https://github.com/prisma/prisma/issues/11674) - [Sveltekit + Cloudflare adapter - "PrismaClient is unable to be run in the browser."](https://github.com/prisma/prisma/issues/11712) - [`TypeError: at normalizeAndValidateHeaderValue` with data proxy in cloudflare workers/miniflare](https://github.com/prisma/prisma/issues/12356) - [PANIC: called `Option::unwrap()` on a `None` value in query-engine/core/src/query_document/parser.rs:250:87](https://github.com/prisma/prisma/issues/12491) - [Implement "CLI engine crash reporting" for Formatter Engine and `getConfig` and `getDmmf` of Query Engine](https://github.com/prisma/prisma/issues/12495) - [Add test for internal engine port](https://github.com/prisma/prisma/issues/12507) - [PANIC: called `Option::unwrap()` on a `None` value in query-engine/core/src/query_document/parser.rs:250:87](https://github.com/prisma/prisma/issues/12654) - [DataProxy Client only works if I instantiate a normal Client first](https://github.com/prisma/prisma/issues/12682) - [PANIC: called `Option::unwrap()` on a `None` value in query-engine/core/src/query_document/parser.rs:250:87](https://github.com/prisma/prisma/issues/12737) - [Engine hard crashes on id values exceeding the Number.MAX_SAFE_INTEGER](https://github.com/prisma/prisma/issues/12841) - [dbgenerated function cause Null constraint error in MySQL](https://github.com/prisma/prisma/issues/12850) - [Expose Metrics in Prisma Client](https://github.com/prisma/prisma/issues/12875) - [Improve the DX for enabling the data proxy](https://github.com/prisma/prisma/issues/12904) - [Client crash on out-of-range integer update using Postgres](https://github.com/prisma/prisma/issues/12969) - [Prisma Client has stopped working on Vercel Edge Functions](https://github.com/prisma/prisma/issues/13059) - [PANIC: called `Option::unwrap()` on a `None` value in query-engine/core/src/query_document/parser.rs:250:87](https://github.com/prisma/prisma/issues/13293) - [`InvalidDatasourceError` of Data Proxy Client outputs a code snippet](https://github.com/prisma/prisma/issues/13337) - [A few small typos in the repo (unkown)](https://github.com/prisma/prisma/issues/13394) - [Cloudflare Workers with PlanetScale db](https://github.com/prisma/prisma/issues/13474) ## Credits Huge thanks to @shian15810, @zifeo, @ever0de, @rushabhhere for helping! ## Prisma Day [Prisma Day](https://prisma.io/day) is back this year, and it'll be on June 15 - 16 at the James June Sommergarten in Berlin. Join us in-person or online for talks and workshops on modern application development and databases. Come and meet and chat with the team behind the Prisma ORM and Prisma Data Platform. ## 💼 We're hiring! If you're interested in joining our growing team to help empower developers to build data-intensive applications, Prisma is the place for you. We're looking for a [Technical Support Engineer](https://grnh.se/ff0d8a702us) and [Back-end Engineer: Prisma Data Platform](https://grnh.se/45afe7982us). Feel free to read through the job descriptions and apply using the links provided. ## 📺 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://youtu.be/B3Mh3yGRZ5U) livestream. The stream takes place [on YouTube](https://youtu.be/B3Mh3yGRZ5U) on **Thursday, June 9** at **5 pm Berlin | 8 am San Francisco**.