Hey <!everyone> ✌️ prisma cool We just released Prisma

3.13.0

prisma rainbow 🔍

migrate diff

and

db execute

are now Generally Available! We’re proud to announce that the commands are now Generally Available and can now be used without the

--preview-feature

flag. 🎉 The

prisma migrate diff

and

prisma db execute

commands make it possible to build many new workflows such as forward and down migrations with some automation tooling. Take a look at our documentation to learn some of the popular workflows these commands unlock: • Fixing failed migrations • Squashing migrations • Generating down migrations Let us know what tools, automation, and scripts you build using these commands. 🔮 SQL Server index clustering(Preview) In version

3.5.0

, we introduced the

extendedIndexes

Preview feature which we have constantly been adding new configuration options for indexes. In this release, we added support for enabling or disabling index/constraint clustering in SQL Server. By default, indexes will be clustered by default. You can update this in your schema as follows to disable index clustering:

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

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

model Post {
  id      Int     @default(autoincrement()) @id(clustered: false)
  title   String
  content String?
}

The following SQL will be generated in your migration when you run

prisma migrate dev

CREATE TABLE [Post] (
  id INT NOT NULL,
  [title] VARCHAR(255) NOT NULL,
  [content] NVARCHAR(1000),
  CONSTRAINT [Post_pkey] PRIMARY KEY NONCLUSTERED (id)
)

If you’ve enabled the

extendedIndexes

Preview feature, this is potentially a breaking change. Refer to our documentation to learn how you can upgrade from a previous version. 🦦 Updated native types for CockroachDB (Preview) We have revamped the native types available in the CockroachDB connector. We initially re-used the PostgreSQL native types because they were close enough, but we have now adapted our list of the supported native types to match what CockroachDB supports. If you are already using CockroachDB in your project, you can run

prisma db pull

to update all the native types in your Prisma schema. Refer to our documentation for the complete list of all CockroachDB native types. OpenSSL 3.0 support We’re excited to announce that version

3.13.0

now supports OpenSSL 3.0. 📚 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, @nikolasburk, @Sabin Adams, and I will discuss the latest release and other news from the Prisma ecosystem in a this Thursday at 5 pm Berlin | 8 am San Francisco.