Prisma: 2.28.0 Release

Today, we are excited to share the 2.28.0 stable release 🎉

🌟 Help us spread the word about Prisma by starring the repo ☝️ or tweeting about the release. 🌟 

MongoDB improvements 🚀

Thanks to your feedback, we fixed a handful of bugs reported on the MongoDB connector (Preview):

• Concurrent findUnique queries leading to an error #8276
• Filtering by relations wasn't working properly #7057
• Filtering on an array of IDs #6998

Please keep reporting issues to our team and help to bring MongoDB support closer to GA!

Create new Prisma projects in under 3 minutes ⏳

The latest release of the Application Data Platform enables you to create new Prisma projects and provision a database in under 3 minutes.

The Application Data Platform already allows you to: - Explore data in the database using the data browser. - Add other users to it, such as your teammates or your clients. - Assign users one of four roles: Admin, Developer, Collaborator, Viewer. - View and edit your data collaboratively online.

The new onboarding flow makes it possible to get started with Prisma quickly for new Prisma projects! 🚀

When creating a new Prisma project, the Application Data Platform allows you to: - Choose a Prisma schema from a selection of our templates. - Create a free PostgreSQL database on Heroku. - Populate the database with seed data.

If you already have a Prisma project, you can continue to import it from GitHub and connect it to your database.

This whole process now takes less than 3 minutes to set up, so we’re looking forward to seeing how you will use this feature for your prototyping and production needs.

If you have any issues or questions, let us know by opening a GitHub issue.

Quick overview

If you have a Heroku account, we can create a free Postgres database for you:

Start your project with a schema from our templates:

Interested in Prisma’s upcoming Data Proxy for serverless backends? Get notified! 👀

Database connection management in serverless backends is challenging: taming the number of database connections, additional query latencies for setting up connections, etc.

At Prisma, we are working on a Prisma Data Proxy that makes integrating traditional relational and NoSQL databases in serverless Prisma-backed applications a breeze. If you are interested, you can sign up to get notified of our upcoming Early Access Program here:

https://pris.ly/prisma-data-proxy

Fixes and improvements

Prisma Client

• PANIC in query-engine/connectors/mongodb-query-connector/src/value.rs:100:24 not yet implemented: (ObjectId, List([String("609675d400e7693e0090e48c")]))
• MongoDB: Filtering by relation returns no results
• MongoDB: 2 queries for findUnique lead to error

Prisma Migrate

• Using render.com database for migrate dev leads to error message ERROR: cannot drop view pg_buffercache because extension pg_buffercache requires it HINT: You can drop extension pg_buffercache instead.

Prisma Studio

• Can't open Prisma Studio from WSL 2
• Unable to get DMMF from Prisma Client
• Prisma Studio fails to add or update record in database when it contains ".
• Scrolling & searching in initial schema list not working
• Fatal error on latest version (0.410.0) on Windows
• Ability to remove invalid/unused schemes
• fields with @updatedAt are not behaving as expected
• Error starting Prisma Client: { "message": "\n Error: spawn typegraphql-prisma ENOENT\n at notFoundError
• prisma studio error after installing latest version
• Sort models alphabetically (or allow multiple sorting options)

Credits

Huge thanks to @ShubhankarKG, @hehex9 for helping!

📺 Join us for another "What's new in Prisma" livestream

Learn about the latest release and other news from the Prisma community by joining us for another "What's new in Prisma" livestream.

The stream takes place on Youtube on Thursday, July 15 at 5pm Berlin | 8am San Francisco.