Limitations

Overview

This page describes features that are currently not supported by Prisma and are not planned to be supported.

Long-running transactions

Databases often offer "long-running transactions" as a feature. A transaction generally refers to a sequence of read/write operations that are guaranteed to either succeed or fail as a whole.

Prisma offers a limited set of transactions in the form of nested writes. There currently is no plan to provide an API to allow a transaction API for long-running transactions.

✍ Read more about How Prisma supports transactions on our blog.

Records must be uniquely identifiable

Prisma currently only supports models that have at least one unique field or combination of fields. In practice, this means that every Prisma model must have either at least one of the following attributes:

• @id or @@id for a single- or multi-field primary key constraint (max one per model)
• @unique or @@unique for a single- or multi-field unique constraint

Manual database connection handling

When using Prisma, the database connections are handled on an engine-level. This means they're not exposed to the developer and it's not possible to manually access them.