Hey <!everyone> ✌️ prisma cool We just released Prisma 3.5.0 prisma rainbow Here is what’s new! 🐘 Order by relevance in full text search (PostgreSQL) In 

3.5.0

, we’ve added support for ordering full text search results by relevance. Ordering by relevance gives you a way to order search results by the best match. While this feature is useful standalone, it’s most commonly used in combination with the full text 

search

 field in the 

where

 clause:

const query = "node.js developer"
const developers = await prisma.people.findMany({
  where: {
    bio: {
      // Only select people whose bio's contain "node.js developer"
      search: query,
    },
  },
  orderBy: {
    // Order that selection by query relevance.
    _relevance: {
      fields: ["bio"],
      search: query,
      sort: "desc",
    },
  },
})

Learn more in our documentation and if you run into any issues or have feedback for us, you can reach us in this issue. ⚙️ More configuration options for indexes and constraints in the Prisma schema (Preview) We are extending the syntax in the Prisma schema to add support for configuration of length and sort order for: • indexes • unique constraints • primary key constraints The following example demonstrates the use of the 

sort

 and 

length

 arguments:

model Post {
    title       String @db.VarChar(300)
    abstract    String @db.VarChar(3000)
    slug        String @db.VarChar(3000) @unique(sort: Desc, length: 42)
    author      String
    created_at  DateTime

    @@id([title(length: 100, sort: Desc), abstract(length: 10)])
    @@index([author, created_at(sort: Desc)])
}

⚠️ Warning: This might be a breaking change for some users. To learn how to mitigate that, please read the documentation linked below. Learn more in the documentation on index configuration. 🦦 Case insensitive filtering for Prisma Client Go We’ve had this feature in the Prisma Client JS for a while, but in this release, we’ve added case-insensitive query support to the Go Client as well. Now you can worry a bit less about what kind of data the user is going to send your way.

users, err := client.User.FindMany(
    User.Email.Equals("prisMa"),
    User.Email.Mode(QueryModeInsensitive), // sets case insensitivity
).Exec(ctx)

Learn more in our documentation and share your feedback in the #prisma-client-go channel here on Slack! 📚 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. 🌐 The Prisma Serverless Data Conference is happening on Thursday (Nov 18) Make sure to claim your ticket for our free Prisma Serverless Data Conference about all things databases and serverless with fantastic speakers from companies like PlanetScale, MongoDB, Vercel, Netlify, Cloudflare and CockroachDB. 📰 Join us on Wednesday(!!!) for the “What’s new in Prisma” livestream This week, my colleague @Daniel Norman and I will discuss the latest release and other news from the Prisma ecosystem in a  on Wednesday at 5pm Berlin | 8am San Francisco.