Prisma 6.4.0 — Release Notes & Engineering Impact

Today, we are excited to share the `6.4.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%20v6.4.0%20%F0%9F%9A%80%0D%0A%0D%0Ahttps://github.com/prisma/prisma/releases/tag/6.4.0) about the release.** 🌟 ## Highlights ### TypeScript-based configuration with `prisma.config.ts` (Early Access) In this release, we're introducing an Early Access version of a TypeScript-based configuration file for Prisma ORM: `prisma.config.ts`. This file will serve as a central configuration point for Prisma ORM: ```ts import path from 'node:path' export default { earlyAccess: true, // required while in Early Access schema: { kind: 'single', // use 'multi' if you're using the `prismaSchemaFolder` preview feature filePath: path.join('custom', 'prisma', 'schema.prisma') } }) ``` With this file you are able to run any arbitrary code needed to get values required by Prisma ORM, such as database URLs from a secret store or fine-grained control of settings. It needs to live in the current working directory from where you're executing Prisma CLI commands (typically, the root of your project). > **Note**: If you're using `prisma.config.ts`, the Prisma CLI will not load environment variables from `.env` files. If you want to use a `.env` file with `prisma.config.ts`, you'll need to load the environment variables manually using the [`dotenv`](https://github.com/motdotla/dotenv) package (see [here](https://www.prisma.io/docs/orm/reference/prisma-config-reference)). Learn more about the new `prisma.config.ts` file in the [docs](https://prisma.io/docs/orm/reference/prisma-config-reference). ### Case-insensitive mode in JSON filters You can now do case-insensitive filtering on JSON data. Just use the new `mode` option when filtering using `string_contains`, `string_starts_with` or `string_ends_with` in a JSON object and set it to `"insensitive"`: ```ts await prisma.user.findMany({ where: { pets: { path: ['favorites', 'catBreed'], string_contains: 'Van', mode: "insensitive", }, }, }); ``` The above query returns all users where the `favorites.catBreed` value contains `"Van"` or `"van"`. Thanks to [@lubosmato](https://github.com/lubosmato) who [implemented](https://github.com/prisma/prisma-engines/pull/4977) this feature 🎉 ### Improved CockroachDB migration speed In this release we found some inefficiencies in our migration engine that was impacting CockroachDB migrations. In 6.4.0, CockroachDB migrations should be significantly faster. ## Calling all devs: Give us your feedback! Prisma ORM's community keeps us going. To make sure that we're focused on what the community needs, we would like to get your feedback via our online [feedback form](https://pris.ly/orm/survey/release-6-4). ## Credits Huge thanks to @lubosmato, @notomo, @Mayureshd-18, @mydea, @omar-dulaimi and @Hazmi35 for helping out with this release!