Hey <!everyone> :v: :prisma-cool: Weโ€™re back from...
# prisma-whats-new
Hey <!everyone> โœŒ๏ธ prisma cool Weโ€™re back from the holidays with a special treat for you. We just released Prisma
prisma rainbow ๐Ÿ” Full-text search support for MySQL is now in Preview Prisma now supports full-text search in MySQL. You can enable full-text support by adding the
Preview flags in your Prisma schema and defining
index on fields youโ€™d like to use full-text search on.
Copy code
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
prisma db push
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.
Copy code
// search for titles that contain cat, but not fox
await prisma.post.findMany({
  where: {
    title: {
      search: "+cat -fox",
Learn more in our documentation. ๐Ÿšง
are now mutually exclusive
Before Prisma
, Prisma queries would fail whenever the Data Proxy and interactive transactions Preview features were used together. The interactiveTransactions and dataProxy Preview flags cannot be used together in this release. Generating the Prisma Client when both Preview features are enabled will throw an error. ๐Ÿ”ง Fixed support for
when adding an element to an array in MongoDB
support for `ObjectId`s on MongoDB. Given the following schema:
Copy code
model Course {
  id          String   @id @default(dbgenerated()) @map("_id") @db.ObjectId
  title       String
  students    String[] @db.Array(ObjectId)
You can now run the following query:
Copy code
// Add a new student to the course
await prisma.course.update({
  where: {
    id: 1
  data: {
    students: {
      push: new ObjectID("...")
๐Ÿ“š 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 it 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 This week, I will discuss the latest release and other news from the Prisma ecosystem in a

livestream on YouTubeโ–พ

on Thursday at 5 pm Berlin | 8 am San Francisco
๐Ÿ™Œ๐Ÿผ 1
๐Ÿ™Œ๐Ÿฝ 1
prisma cool 21
๐Ÿณ๏ธโ€๐ŸŒˆ 7
prisma rainbow 21
prisma xmas 3
๐Ÿ‡ต๐Ÿ‡ฑ 10
๐ŸŽ‰ 16
fast parrot 22
github icon 10
๐Ÿ‡ฌ๐Ÿ‡ง 1
๐Ÿ™Œ๐Ÿฟ 1
๐Ÿ‡บ๐Ÿ‡ฌ 2
๐Ÿ‡ป๐Ÿ‡ช 3
๐Ÿ‡ฐ๐Ÿ‡ช 3
๐Ÿ˜Ž 5
๐Ÿ‡ณ๐Ÿ‡ฑ 4
๐Ÿ“ฃ 4
๐Ÿฅฐ 10
prisma green 11
โœจ 5
๐Ÿ‡ต๐Ÿ‡ช 1
๐Ÿ‡ฟ๐Ÿ‡ผ 1
๐Ÿ‡ฒ๐Ÿ‡ป 1
๐Ÿ‡ฌ๐Ÿ‡ช 1
southafrica parrot 1
๐Ÿ‡ฏ๐Ÿ‡ฒ 1
๐Ÿ‡ต๐Ÿ‡ฐ 3
๐Ÿ™‚ 3
๐Ÿ”ฅ 8
๐ŸŒถ๏ธ 2
๐Ÿ‡ท๐Ÿ‡ผ 1
๐ŸŽฌ 3
๐Ÿ’ฏ 8
๐Ÿ‡ฉ๐Ÿ‡ฏ 1
๐Ÿ‡ง๐Ÿ‡ด 2
๐Ÿ‡ฎ๐Ÿ‡น 1
๐Ÿ‡ณ๐Ÿ‡ด 1
๐Ÿ‡ซ๐Ÿ‡ท 4
๐Ÿ‡ณ๐Ÿ‡ฌ 5
๐Ÿ‡ฎ๐Ÿ‡ณ 7
๐Ÿ‡ธ๐Ÿ‡ฆ 1
catjam 6
๐Ÿคฉ 4
๐Ÿš€ 9
๐Ÿ‡ฐ๐Ÿ‡ท 11
๐Ÿ™Œ 67
๐Ÿ‡ฏ๐Ÿ‡ต 1
๐Ÿ‡ช๐Ÿ‡น 1
๐Ÿ‡ฟ๐Ÿ‡ฒ 1