Hey <!everyone> ✌️ prisma cool We just released Prisma 2.30.0 prisma rainbow 🚀 Full-Text Search for PostgreSQL is now in Preview We’re excited to announce that Prisma Client now has preview support for Full-Text Search on PostgreSQL. You can give this a try in 2.30.0 by enabling the

fullTextSearch

preview flag:

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

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

After you regenerate your client, you’ll see a new

search

field on your

String

fields that you can query on. Here’s an example:

// returns all posts that contain the words cat *or* dog.
const result = await prisma.post.findMany({
  where: {
    body: {
      search: 'cat | dog',
    },
  },
})

You can learn more about how the query format works in our documentation. We would love to know your feedback! If you have any comments or run into any problems we’re available in this in this Github issue. ℹ️ Validation errors for referential action cycles on Microsoft SQL Server Prisma now checks for referential cycle actions when it validates your schema file and shows you the exact location of the cycle in your schema when using Microsoft SQL Server. 👋🏻

prisma introspect

is being deprecated in favor of

prisma db pull

The

prisma introspect

command is an alias for

prisma db pull

, which allows you to pull the schema from the database into your local

schema.prisma

file. Starting with this release, you will get a warning that encourages you to use

prisma db pull

instead of

prisma introspect

. 📚 Learn more in the release notes For more info and links to documentation, you can read the release notes. 🌟 Help us spread the word about Prisma🌟 To help spread the word about Prisma, we’d very much appreciate if you would star the repo 🌟 And if you’re excited about the features in this week’s release, then help us and share your excitement on Twitter. 📰 Join us on Thursday for the “What’s new in Prisma” livestream @Mahmoud will discuss the latest release and other news from the Prisma ecosystem in a on Thursday at 5pm Berlin | 8am San Francisco.