🌐
Prisma
prisma.io › home › transactions and batch queries › transactions and batch queries › transactions and batch queries › transactions and batch queries
Transactions and batch queries (Reference) | Prisma Documentation
Below, we will call this instance tx. Any Prisma Client call invoked on this tx instance is encapsulated into the transaction. In the example below, Alice and Bob each have $100 in their account.
🌐
Medium
medium.com › @moiserushanika2006 › mastering-database-rollbacks-with-prismas-transactional-finesse-9156b8319bb1
Mastering Database Rollbacks with Prisma’s Transactional Finesse | by Moise rushanika | Medium
December 23, 2023 - In this example, we use the $transaction method to define an array of Prisma queries to be executed within the same transaction.
Discussions
postgresql - Prisma: how to write transaction where results from one query are used by another query - Stack Overflow
I'm working on a project with Next.js and Prisma. In one of my API routes, I have a three queries. The results of the first and second queries are used in the third query. I'd like to do all three operations as a transaction and then return the data from the first query in the response. More on stackoverflow.com
🌐 stackoverflow.com
Warning: Think twice before using Prisma in large projects
Hey there, I'm Nikolas from the Prisma team. Thanks a lot for raising these issues, we're always looking to improve so we very much appreciate feedback like this! It sounds like your main issue revolves around the size of the generated index.d.ts file, right? (Since the TS server crashing and the worsened DX are consquences of that)? Thank you as well for already pointing to the open issue for this! I understand that it must be super frustrating to have your editor become slow and autocomplete stop working because of that (and honestly, having an issue open for 4,5 yars sounds equally frustrating to me). I will raise the urgency of this to our Engineering team and hope that we'll get to this soon. We actually recently changed our approach to OSS governance and made it more transparent, exactly because of issues like that one that have been around for so long. In the meantime, could I ask you to add a comment to the issue? Ideally, you can also share your schema (maybe in a GitHub Gist ?) so that our engineers can reproduce it? Regarding JOINs, we released native DB-level joins that are using a mix of LATERAL joins and JSON aggregation about one year ago, so hopefully there shouldn't be any issues around that any more. If you do end up seeing slow queries, please open an issue ! We've invested a lot into performance in the last 1-2 years and are eager to fix any slow query we become aware of. Thanks again for sharing this and please let me know if I can help in any other way! More on reddit.com
🌐 r/nextjs
132
238
January 27, 2025
Extending Prisma Client Methods in NestJS Services While Preserving TypeScript Typings
I think you can try to achieve so with Prisma client extension: https://www.prisma.io/docs/orm/prisma-client/client-extensions More on reddit.com
🌐 r/nestjs
5
4
January 22, 2024
What are the biggest gotchas/weirdnesses of Prisma?
I wanted to use Prisma but reading about how it does joins in the client by performing multiple queries instead of letting the database handle that natively made me choose not to use it. https://github.com/prisma/prisma/discussions/12715 More on reddit.com
🌐 r/typescript
56
23
November 19, 2023
Videos
07:32
🌐 YouTube
Interactive Transactions in Prisma - YouTube
May 16, 2023
🌐 youtube.com
How to Do Database Transactions in Prisma ORM - YouTube
July 21, 2023
06:18
🌐 YouTube
How to Use Transactions in Prisma - YouTube
March 29, 2023
23:37
🌐 YouTube
Transactions + Prisma + Typescript: Como e por que usar? - YouTube
October 19, 2023
2.89K
03:33
🌐 YouTube
How to use transactions in Prisma/Next.js/T3 Stack - YouTube
January 26, 2023
07:33
🌐 YouTube
Why I needed to add prisma transactions to my SaaS - YouTube
February 23, 2023
View all
View all
🌐
Goprisma
goprisma.org › docs › walkthrough › transactions
Transactions – Prisma Client Go
// create two posts at once and run in a transaction firstPost := client.Post.CreateOne( db.Post.Published.Set(true), db.Post.Title.Set("First Post"), ).Tx() secondPost := client.Post.CreateOne( db.Post.Published.Set(false), db.Post.Title.Set("Second Post"), ).Tx() if err := client.Prisma....
🌐
Medium
chaitanyakadu.medium.com › prisma-transactions-and-batch-queries-d0fb932b7fed
Prisma Transactions and Batch Queries | by Chaitanya Kadu | Medium
March 5, 2025 - $transaction Write Execute multiple operations as part of a single transaction to ensure ACID compliance. const [posts, totalPosts] = await prisma.$transaction([ // task #1 prisma.post.findMany({ where: { title: { contains: 'prisma' } } }), ...
🌐
Prisma Client Python
prisma-client-py.readthedocs.io › en › stable › reference › transactions
Transactions - Prisma Client Python
Transactions can be created using the Prisma.tx() method which returns a context manager that when entered returns a separate instance of Prisma that wraps all queries in a transaction.
🌐
DEV Community
dev.to › reyronald › dealing-with-open-database-transactions-in-prisma-3clk
Dealing with open database transactions in Prisma - DEV Community
February 23, 2025 - PrismaClientKnownRequestError: Transaction API error: Transaction already closed: A commit cannot be executed on an expired transaction. The timeout for this transaction was 5000 ms, however 5012 ms passed since the start of the transaction.
🌐
DevSheets
devsheets.io › sheets › prisma › database-transactions
Prisma Database Transactions - Example & Syntax
// Sequential transaction (auto-rollback on error) const result = await prisma.$transaction([ prisma.user.create({ data: { email: 'user@example.com' } }), prisma.post.create({ data: { title: 'Post' } }), ]) // Interactive transaction with custom logic await prisma.$transaction(async (tx) => ...
🌐
DEV Community
dev.to › this-is-learning › its-prisma-time-transactions-ji5
It's Prisma Time - Transactions - DEV Community
February 16, 2023 - In this moment, Prisma handles the transactions in two ways, the first one is the official feature and the second one is in preview. Let's start from the first one. The first method to do a transaction in Prisma is using the $transaction method. This method accepts a list of operations that ...
Find elsewhere
🌐
Prisma
prisma.io › blog › how-prisma-supports-transactions-x45s1d5l0ww1
Learn How Prisma Supports Database Transactions | Prisma
September 8, 2020 - One of the most common use cases for database transactions is when you need to update multiple rows that are related via foreign keys. For example, you might want to create a new "order" along with a related "invoice" in the database.
🌐
Tericcabrel
blog.tericcabrel.com › database-transactions-prisma-orm
Write database transactions in Node.js with Prisma ORM
February 26, 2024 - This post shows you how to write database transactions on MySQL or PostgreSQL using the Prisma ORM in a Node.js application with TypeScript.
🌐
Prisma
prisma.io › dataguide › postgresql › inserting-and-modifying-data › using-transactions
Using Transactions | Inserting and modifying data | PostgreSQL
The basic syntax of a transaction therefore looks like this: ... As a more concrete example, imagine that we are attempting to transfer $1000 from one account to another.
🌐
Medium
medium.com › @fidelwole › database-transactions-in-prisma-4cd0153fed30
Database Transactions in Prisma. I was working on a project and… | by Fidelis Adewoye | Medium
December 9, 2024 - For example: Debit the sender’s account. Credit the recipient’s account. If one operation succeeds and the other fails, the system ends up with inconsistent data. Transactions ensure both operations succeed together or fail together, maintaining the integrity of the system. Prisma provides the $transaction method to group multiple operations into a single atomic transaction.
🌐
Howtoprisma
howtoprisma.com › blog › how-to-use-transactions-in-prisma
Home | Holodeck
March 30, 2023 - Ryan has been teaching full stack web development through screencasts and courses since 2015. He's worked for auth0 and Prisma and is the founder of Elevate Digital, a full-service web application development agency.
🌐
Stack Overflow
stackoverflow.com › questions › 73939849 › prisma-how-to-write-transaction-where-results-from-one-query-are-used-by-anothe
postgresql - Prisma: how to write transaction where results from one query are used by another query - Stack Overflow
Top answer
1 of 1
4

Here you go:

 const { boardId } = req.body;
  const { description, status, title } = req.body.task;

  const [createTask] = await prisma.$transaction(async (prisma) => {
    const createTask = await prisma.task.create({
      data: {
        board: boardId,
        description,
        status,
        title,
      },
    });

    const statusArray = await prisma.board.findUnique({
      where: {
        id: boardId,
      },
      select: {
        [status]: true,
      },
    });

    const updateBoardStatusArray = await prisma.board.update({
      where: {
        id: boardId,
      },
      data: {
        [status]: {
          set: [...statusArray[status], createTask.id],
        },
      },
    });
    
    return [createTask, statusArray, updateBoardStatusArray];
  });

  // return data from first query
  res.status(201).json({ task: createTask });

You can learn more about Interactive Transaction here

🌐
DEV Community
dev.to › ashukr22 › interactive-transactions-in-prisma-a-developers-guide-4mg6
Interactive Transactions in Prisma: A Developer's Guide - DEV Community
July 10, 2025 - const result = await prisma.$transaction(async (tx) => { const user = await tx.user.create({ data: { name: "John", email: "john@example.com" } }); const profile = await tx.profile.create({ data: { userId: user.id, bio: "Software developer" } ...
🌐
GitHub
github.com › prisma › prisma › discussions › 25034
Transactions within Client Extension Example · prisma/prisma · Discussion #25034
Prisma.defineExtension((client) => { return client.$extends({ query: { $allModels: { async $allOperations<T>({ args, query, model, operation, ...rest }: { args: any, query: any, model: any, operation: any }) { const setRLS = async (client: any)=>{ await client.$executeRaw('some rls logic...') } const checkResults = (result: any) => { if(result === 'not-valid'){ throw new Error('This is just a an example check function...') } return result } // check if this query already runs within a transaction if ((rest as any).__internalParams.transaction) { const transaction = (rest as any).__internalPara
Author   prisma
🌐
Wanago
wanago.io › home › api with nestjs #104. writing transactions with prisma
API with NestJS #104. Writing transactions with Prisma
April 17, 2023 - By passing multiple database operations into the prismaService.$transaction, we can run them sequentially in a transaction. For example, if something goes wrong when deleting the category, the posts are not removed from ...
🌐
GitHub
github.com › prisma › prisma › discussions › 20924
Type of transacting prisma (e.g. tx)? · prisma/prisma · Discussion #20924
Apologies for the late reply here. I think the type you are looking for is Prisma.TransactionClient
Author   prisma
🌐
Medium
medium.com › @lim.haowen › how-i-learned-to-stop-worrying-and-use-prisma-transactions-right-d9fa609bbc97
How I Learned to Stop Worrying and Use Prisma Transactions Right | by Lim Hao Wen | Medium
April 21, 2025 - The challenge arose when I needed to perform a transaction that involved multiple CRUD operations from different repositories. With Prisma, we can achieve atomic transactions using the prisma.$transaction() API.
Related queries
prisma transaction rollback
prisma transaction typescript
prisma transaction type
nestjs prisma transaction
prisma update
prisma connect
prisma transaction already closed
prisma transaction timeout