Prisma ORM v6.9.0: no Rust engines for PostgreSQL and SQLite

If you've been excited about our work of removing the Rust engines from Prisma ORM but hesitated trying it out because it was in an Early Access (EA) phase, now is a great time for you to get your hands on the Rust-free Prisma ORM version.

This major architectural change has moved from EA into Preview in this release, meaning there are no more know major issues. If you want to try it out, add the queryCompiler and driverAdapters preview feature flags to your generator, install the driver adapter for your database, and get going:

generator client {
  provider        = "prisma-client-js"  
  previewFeatures = ["queryCompiler", "driverAdapters"]  
  output          = "../generated/prisma"
}

No more hassle with query engines, binary targets and an even smoother experience in serverless and edge environments! Learn more in the docs.

🎨 Connect to Prisma Postgres with any ORM (Preview)

Since its GA release, you could only interact with Prisma Postgres using Prisma ORM via a custom connection string.

This has changed now: When setting up a new Prisma Postgres instance, you receive a regular PostgreSQL direct TCP connection string (starting with postgres://...) that lets you connect to it using your favorite tool or database library, including Drizzle, Kysely, TypeORM, and others.

If you want to access Prisma Postgres from a serverless environment, you can also use our new serverless driver (Early Access). Learn more about this in the docs.

🪄 Automated backup & restore for Prisma Postgres

Prisma Postgres' backup and restore mechanism has seen a major upgrade recently: You can now easily restore any previous backup via the UI in the Prisma Console.

image (16).png

Find the new Backups tab when viewing your database and select any backup from the list to restore its state to a previous point in time. Learn more in the docs.

🤯 Prisma's VS Code extension now has a UI to manage Prisma Postgres

If you're using Prisma ORM, chances are that you're using our VS Code extension too. In its latest release, we've added a major new capability to it: A UI for managing databases.

updated (1).png

With this new UI, you can:

Authenticate with the Prisma Console
Create and delete remote Prisma Postgres instances
View local Prisma Postgres instances
View and edit data via an embedded Prisma Studio
Visualize your database schema

To use the new features, make sure to have the latest version of the Prisma VS Code extension installed and look out for the new Prisma logo in VS Code's Activity Bar. Learn more in the docs.

🏡 Major improvements for local Prisma Postgres (Preview)

In the last release, we enabled you to spin up a Prisma Postgres instance locally via the new prisma dev command. Local Prisma Postgres uses PGlite under the hood and gives you an identical experience as you get with a remote Prisma Postgres instance.

This release brings major improvements to this feature:

Persists your databases across prisma dev invocations.
Enables you to have multiple local Prisma Postgres instances running at the same time.
Running prisma init now uses local Prisma Postgres by default.

Try it out and let us know what you think. Learn more about this feature in the docs.

🌎 New region for Prisma Postgres: San Francisco (`us-west-1`)

We keep expanding Prisma Postgres availability across the globe! After having added Singapore just a few weeks ago, we're now adding San Francisco based on another poll we ran on X. Here are all the regions where you can spin up Prisma Postgres instances today:

us-west-1: San Francisco (new!)
us-east-1: North Virginia
eu-west-3: Paris
ap-northeast-1: Tokyo
ap-southeast-1: Singapore

Keep an eye on our X account to take part in the poll and vote for the next availability zone of Prisma Postgres!

Prisma ORM v6.9.0: no Rust engines for PostgreSQL and SQLite