Traceary

Catalog / Prisma

7.5.0

6 months agosecurityaddedfixedOriginal notes

Today, we are excited to share theĀ 7.5.0Ā stable releaseĀ šŸŽ‰

šŸŒŸĀ Star this repo for notifications about new releases, bug fixes & features ā€” orĀ follow us on X!

Highlights

ORM

Features

  • Added support for nested transaction rollbacks via savepoints (#21678)

    Adds support forĀ nested transaction rollback behaviorĀ for SQL databases: if an outer transaction fails, the inner nested transaction is rolled back as well. Implements this by trackingĀ transaction ID + nesting depthĀ so Prisma can reuse an existing open transaction in the underlying engine, and it also enables usingĀ $transactionĀ from an interactive transaction client.

Bug fixes

Driver Adapters

  • Made the adapter-mariadb use the binary MySQL protocol to fix an issue with lossy number conversions (#29285)
  • Made @types/pg a direct dependency of adapter-pg for better TypeScript experience out-of-the-box (#29277)

Prisma Client

  • Resolved Prisma.DbNull serializing as empty object in some bundled environments like Next.js (#29286)
  • Fixed DateTime fields returning Invalid Date with unixepoch-ms timestamps in some cases (#29274)
  • Fixed a cursor-based pagination issue with @db.Date columns (#29327)

Schema Engine

  • Manual partial indexes are now preserved when partialIndexes preview feature is disabled, preventing unnecessary drops and additions in migrations (#5790, #5795)
  • Enhanced partial index predicate comparison to handle quoted vs unquoted identifiers correctly, eliminating needless recreate cycles (#5788)
  • Excluded partial unique indexes from DMMF uniqueFields and uniqueIndexes to prevent incorrect findUnique input type generation (#5792)

Studio

With the launch of Prisma ORM v7, we also introduced a rebuilt version of Prisma Studio. With the feedback weā€™ve gathered since the release, weā€™ve added some high requested features to help make Studio a better experience.

Multi-cell Selection & Full Table Search

This release brings the ability to select multiple cells when viewing your database. In addition to being able to select multiple cells, you can also search across your database. You can search for a specific table or for specific cells within that table.

More intuitive filtering

Filtering is now easier to use, and includes an option for raw SQL filters.

And if you are using Studio in Console, you can use ai generated filters:

Cmd+k Command Palette

You can now use the keyboard to perform most actions in Studio with the new cmd+k command palette

Run raw SQL queries

Another feature weā€™ve included in Prisma Studio is the ability to run raw SQL queries against your data. Thereā€™s a new ā€œSQLā€ tab in the sidebar that will bring you to page where you can perform any queries against your data. Below, weā€™re getting all the rows in the ā€œTodoā€ table.

Open roles at Prisma

Interested in joining Prisma? Weā€™re growing and have several exciting opportunities across the company for developers who are passionate about building with Prisma. Explore our open positions on ourĀ [Careers page](https://www.prisma.io/careers#current)Ā and find the role thatā€™s right for you.

Enterprise support

Thousands of teams use Prisma and many of them already tap into our Enterprise & Agency Support Program for hands-on help with everything from schema integrations and performance tuning to security and compliance.

With this program you also get priority issue triage and bug fixes, expert scalability advice, and custom training so that your Prisma-powered apps stay rock-solid at any scale. Learn more or join:Ā https://prisma.io/enterprise.