⬆️ deps(dev): Bump prisma from 3.5.0 to 3.9.0

Bumps prisma from 3.5.0 to 3.9.0.

Release notes

Sourced from prisma's releases.

3.8.1

Today, we are issuing the 3.8.1 patch release.

Fixes

• @​prisma/sdk v3.8.0: Cannot find module 'fs-jetpack'

3.8.0

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

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

Major improvements and new features

Full-text search support for MySQL is now in Preview 🚀

We're back from the holidays with a special treat for you.

Prisma now supports full-text search in MySQL. You can enable full-text support by adding the fullTextIndex and fullTextSearch Preview flags in your Prisma schema and defining @@fulltext() indexes on fields you'd like to use full-text search on.

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["fullTextIndex", "fullTextSearch"]
}
datasource db {
provider = "mysql"
url      = env("DATABASE_URL")
}
model Post {
id     Int    @​id @​default(autoincrement())
title  String @​unique
@@​fulltext([title])
}

Run prisma db push or prisma migrate dev to update your database schema. Prisma Client will also be re-generated, enabling you to use full-text search in your application.

// search for titles that contain cat, but not fox
await prisma.post.findMany({
  where: {
    title: {
      search: "+cat -fox",
    },
  },
})

... (truncated)

Commits

• See full diff in compare view