3.1.1

[Jolg42]

Today, we are excited to share the 3.1.1 stable release 🎉

🌟 Help us spread the word about Prisma by starring the repo ☝️ or tweeting about the release.

Major improvements

New referentialIntegrity setting in Preview 🚀

Relational databases typically ensure integrity between relations with foreign key constraints, for example, given a 1:n relation between User:Post, you can configure the deletion of a user to cascade to posts so that no posts are left pointing to a User that doesn't exist. In Prisma, these constraints are defined in the Prisma schema with the @relation() attribute.

However, databases like PlanetScale do not support defining foreign keys. To work around this limitation so that you can use Prisma with PlanetScale, we're introducing a new referentialIntegrity setting in Preview.

This was initially introduced in version 2.24.0 of Prisma with the planetScaleMode preview feature and setting. Starting with this release both have been renamed to referentialIntegrity.

The setting lets you control whether referential integrity is enforced by the database with foreign keys (default), or by Prisma, by setting referentialIntegrity = "prisma".

Setting Referential Integrity to prisma has the following implications:

• Prisma Migrate will generate SQL migrations without any foreign key constraints.
• Prisma Client will emulate foreign key constraints and referential actions on a best-effort basis.

You can give it a try in version 3.1.1 by enabling the referentialIntegrity preview flag:

datasource db {
  provider             = "mysql"
  url                  = env("DATABASE_URL")
  referentialIntegrity = "prisma"
}

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["referentialIntegrity"]
}

Note that this feature is not applicable to MongoDB.

Learn more about it in our documentation.

Full-Text Search for the Go Client

In an earlier release, we added Full-Text Search (for PostgreSQL) to the Typescript Client. This was released as a Preview feature.

In this release, we've added that Preview feature to the Go Client. Enable it in your Go project by adding the fullTextSearch preview feature.

Here's an example:

// Fetch all drafts with a title that contains the words fox or dog
posts, _ := client.Post.FindMany(
  db.Post.Title.Search("fox | dog"),
  db.Post.Status.Equals("Draft"),
).Exec(context.Background())

// Loop over the posts and print the title
for _, post := range posts {
  fmt.Println(post.Title)
}

You can get started with the Go Client using our Quick Start Guide. Learn more about Full-Text Search in our documentation.

Interested in Prisma’s upcoming Data Proxy for serverless backends? Get notified! 👀

Database connection management in serverless backends is challenging: taming the number of database connections, additional query latencies for setting up connections, etc.

At Prisma, we are working on a Prisma Data Proxy that makes integrating traditional relational and NoSQL databases in serverless Prisma-backed applications a breeze. If you are interested, you can sign up to get notified of our upcoming Early Access Program here:

https://pris.ly/prisma-data-proxy

📺 Join us for another "What's new in Prisma" livestream

Learn about the latest 3.1.1 release and other news from the Prisma community by joining Daniel Norman from the Prisma team for another What's new in Prisma livestream.

The stream takes place on Youtube on Thursday, September 23 at 5pm Berlin | 8am San Francisco.

Fixes and improvements

Prisma Migrate

• Support databases without foreign keys
• How Can I Disable Foreign Key?
• Re-introspection should not remove relations when foreign keys are not allowed
• Validation error points to an invalid location in the PSL
• planetScaleMode = true is not preserved during db pull

Prisma Client

• PANIC in query-engine\core\src\response_ir\internal.rs:334:86called Option::unwrap() on a None value
• Internal GraphQL schema marks JsonFilter types as DateTime
• nApi preview feature is still allowed and suggested

Prisma

• prisma 3.0.1 warns about breaking changes.
• Add warnings if introspected without foreign keys
• Forbid using onUpdate with prisma level integrity

Credits

Huge thanks to @saintmalik, @benkenawell, @ShubhankarKG, @hehex9 for helping!

---

This discussion was created from the release 3.1.1.

[bigint]

Even after updating I'm getting this 🤔

[bigint]

BTW I'm using with PlanetScale 🙇🏻

[janpio]

What version of the VSCode extension are you using? That needs to be updated as well for these to show up there.

[janpio]

Just checked and confirmed, with the VSCode extension version 3.0.3 (the current one) this definitely works.

[bigint]

Also with onCascade: Delete is not working 🤔

post         Post?          @relation(fields: [postId], references: [id], onDelete: Cascade)

Reg this 🤔

[bigint]

Just checked and confirmed, with the VSCode extension version 3.0.3 (the current one) this definitely works.

It works 😻