Prisma ORM v6.14.0: SQL views get @unique, relationships, and cursor pagination
Prisma ORM v6.14.0: SQL views get @unique, relationships, and cursor pagination
Last release, we improved the robustness of SQL views defined in the Prisma schema. Views are virtual tables that don’t allow for defining foreign keys in the underlying database.
However, as an application developer, it can be convenient to also define relations across them. We’ve received this feedback from several people who had been using views in that way with Prisma ORM, so in this release we’re re-introducing the @unique attribute for views. This attribute enables:
- relationships involving views in the Prisma schema
findUniquequeries, cursor-based pagination and implicit ordering for views in the Prisma Client API
💪 Increased robustness of Management API (Early Access)
We recently released an API for programmatically managing Prisma Postgres instances that’s perfect for CI/CD workflows and scripting.
In this release, we made it more robust and are bringing it closer to its General Availability release.
✅ Revoke OAuth tokens in Prisma Console
If you use OAuth to authorize third-party applications to act on your behalf in the Prisma Console, you can now revoke any app’s access at any time. The Prisma Console shows a list of your authorized (connected) apps, and you can easily remove one to immediately block further access.
🌟 How MasterBoard simplified CI/CD testing with Prisma Postgres
MasterBoard, a startup building software for hydraulics repair shops, switched from AWS to Prisma Postgres to simplify their CI/CD workflows. The move reduced infrastructure overhead, simplified testing and deployment, and gave both developers and testers faster, hassle-free workflows.