PackageTrack

npm · #3659 most downloaded on npm

@prisma/client

7.10.0prisma/prisma ↗

Prisma Client is an auto-generated, type-safe and modern JavaScript/TypeScript ORM for Node.js that's tailored to your data. Supports PostgreSQL, CockroachDB, MySQL, MariaDB, SQL Server, SQLite & MongoDB databases.

Release timeline

10653 releases since 2020
20202026

Releases

  1. 5.21.0-integration-engines-5-21-0-37-integration-itx-refactor-17b7e562a6221b365600e9c7fa310770aa23800a.215 Oct 2024pre-release

    Nothing published for this version

  2. 5.21.0-integration-engines-5-21-0-37-integration-itx-refactor-17b7e562a6221b365600e9c7fa310770aa23800a.115 Oct 2024pre-release

    Nothing published for this version

  3. 5.21.0-integration-engines-5-21-0-35-mobc-and-metrics-up-32af6fa52346dd9c35de00aad9c66abe577c8822.114 Oct 2024pre-release

    Nothing published for this version

  4. 5.21.0-integration-engines-5-21-0-34-integration-itx-refactor-ff4016d5bf29b443876eaf3717671bae3e66572b.210 Oct 2024pre-release

    Nothing published for this version

  5. 5.21.0-integration-engines-5-21-0-34-integration-itx-refactor-ff4016d5bf29b443876eaf3717671bae3e66572b.110 Oct 2024pre-release

    Nothing published for this version

  6. 5.21.0-integration-engines-5-21-0-30-integration-mongodb-aggregate-tracing-3d4b90e67bb5d48bbedf382a8f95a61c63d31c47.27 Oct 2024pre-release

    Nothing published for this version

  7. 5.21.0-integration-engines-5-21-0-30-integration-mongodb-aggregate-tracing-3d4b90e67bb5d48bbedf382a8f95a61c63d31c47.17 Oct 2024pre-release

    Nothing published for this version

  8. 5.21.0-integration-engines-5-21-0-29-integration-itx-refactor-d9c03d983fd548ce3b272f8d3bd21029b1cbdf31.27 Oct 2024pre-release

    Nothing published for this version

  9. 5.21.0-integration-engines-5-21-0-29-integration-itx-refactor-d9c03d983fd548ce3b272f8d3bd21029b1cbdf31.17 Oct 2024pre-release

    Nothing published for this version

  10. 5.21.0-integration-engines-5-21-0-28-integration-itx-refactor-0ffdf7cc92f918047a9e01115a75ae60f1c0f010.27 Oct 2024pre-release

    Nothing published for this version

  11. 5.21.0-integration-engines-5-21-0-28-integration-itx-refactor-0ffdf7cc92f918047a9e01115a75ae60f1c0f010.17 Oct 2024pre-release

    Nothing published for this version

  12. 5.21.0-integration-engines-5-21-0-27-integration-itx-refactor-dffe32bba8f22a19a90b49c250f83df08deca7bc.27 Oct 2024pre-release

    Nothing published for this version

  13. 5.21.0-integration-engines-5-21-0-27-integration-itx-refactor-dffe32bba8f22a19a90b49c250f83df08deca7bc.17 Oct 2024pre-release

    Nothing published for this version

  14. 5.21.0-integration-engines-5-21-0-26-integration-itx-refactor-585e6fd6cee6f51127f2ff79bcfea5c385e19dae.26 Oct 2024pre-release

    Nothing published for this version

  15. 5.21.0-integration-engines-5-21-0-26-integration-itx-refactor-585e6fd6cee6f51127f2ff79bcfea5c385e19dae.16 Oct 2024pre-release

    Nothing published for this version

  16. 5.21.0-integration-engines-5-21-0-25-integration-itx-refactor-34fd61cc127f54e6375cdc19ed445ca6e52e6ca7.24 Oct 2024pre-release

    Nothing published for this version

  17. 5.21.0-integration-engines-5-21-0-25-integration-itx-refactor-34fd61cc127f54e6375cdc19ed445ca6e52e6ca7.14 Oct 2024pre-release

    Nothing published for this version

  18. 5.21.0-integration-engines-5-21-0-24-accelerate-migration-77f7447c3b0e63f746dfee904785fce4b7149543.14 Oct 2024pre-release

    Nothing published for this version

  19. 5.21.0-integration-engines-5-21-0-23-integration-itx-refactor-1b14d69c4ed350ab8a088cfb8a8cc582d8ab7eab.24 Oct 2024pre-release

    Nothing published for this version

  20. 5.21.0-integration-engines-5-21-0-22-accelerate-migration-55d3efd72e46de282f8415aa332b1882180d62b8.14 Oct 2024pre-release

    Nothing published for this version

  21. 5.21.0-integration-engines-5-21-0-20-integration-itx-refactor-4c3d81888c1061f682f4be20a2dafa2126e6af1f.227 Sept 2024pre-release

    Nothing published for this version

  22. 5.21.0-integration-engines-5-21-0-20-integration-itx-refactor-4c3d81888c1061f682f4be20a2dafa2126e6af1f.127 Sept 2024pre-release

    Nothing published for this version

  23. 5.21.0-integration-engines-5-21-0-2-integration-itx-refactor-aa413b54d4893760c84635debe7d5ea6e54326cb.225 Sept 2024pre-release

    Nothing published for this version

  24. 5.21.0-integration-engines-5-21-0-2-integration-itx-refactor-aa413b54d4893760c84635debe7d5ea6e54326cb.125 Sept 2024pre-release

    Nothing published for this version

  25. 5.21.0-integration-engines-5-21-0-19-integration-itx-refactor-104354e8a9def55d4f413f31d16799330e3ef7d3.227 Sept 2024pre-release

    Nothing published for this version

  26. 5.21.0-integration-engines-5-21-0-19-integration-itx-refactor-104354e8a9def55d4f413f31d16799330e3ef7d3.127 Sept 2024pre-release

    Nothing published for this version

  27. 5.21.0-integration-engines-5-21-0-18-integration-itx-refactor-60fff8e2a18dd630661a945ec54241303111de17.226 Sept 2024pre-release

    Nothing published for this version

  28. 5.21.0-integration-engines-5-21-0-18-integration-itx-refactor-60fff8e2a18dd630661a945ec54241303111de17.126 Sept 2024pre-release

    Nothing published for this version

  29. 5.21.0-integration-engines-5-21-0-17-integration-itx-refactor-758897863fcf14f0008c5a2e4a0f083f302b68f7.226 Sept 2024pre-release

    Nothing published for this version

  30. 5.21.0-integration-engines-5-21-0-17-integration-itx-refactor-758897863fcf14f0008c5a2e4a0f083f302b68f7.126 Sept 2024pre-release

    Nothing published for this version

  31. 5.21.0-integration-engines-5-21-0-16-integration-itx-refactor-c90c063bcee736c037b80640d08b62aec265d1e0.226 Sept 2024pre-release

    Nothing published for this version

  32. 5.21.0-integration-engines-5-21-0-16-integration-itx-refactor-c90c063bcee736c037b80640d08b62aec265d1e0.126 Sept 2024pre-release

    Nothing published for this version

  33. 5.21.0-integration-engines-5-21-0-15-integration-itx-refactor-0e688c08010939456f897a5a2b2300625028f8b0.226 Sept 2024pre-release

    Nothing published for this version

  34. 5.21.0-integration-engines-5-21-0-15-integration-itx-refactor-0e688c08010939456f897a5a2b2300625028f8b0.126 Sept 2024pre-release

    Nothing published for this version

  35. 5.21.0-integration-engines-5-21-0-14-integration-itx-refactor-0014c6b321b67e8d77a98443eb4389c66549adee.226 Sept 2024pre-release

    Nothing published for this version

  36. 5.21.0-integration-engines-5-21-0-14-integration-itx-refactor-0014c6b321b67e8d77a98443eb4389c66549adee.126 Sept 2024pre-release

    Nothing published for this version

  37. 5.21.0-integration-engines-5-21-0-13-integration-itx-refactor-21703fdfdb97895d83034d69ffa77bef5a946b6d.226 Sept 2024pre-release

    Nothing published for this version

  38. 5.21.0-integration-engines-5-21-0-13-integration-itx-refactor-21703fdfdb97895d83034d69ffa77bef5a946b6d.126 Sept 2024pre-release

    Nothing published for this version

  39. 5.21.0-integration-engines-5-21-0-12-integration-itx-refactor-b2048e62b2d197d818c71d913a19d56ab7ee4361.226 Sept 2024pre-release

    Nothing published for this version

  40. 5.21.0-integration-engines-5-21-0-12-integration-itx-refactor-b2048e62b2d197d818c71d913a19d56ab7ee4361.126 Sept 2024pre-release

    Nothing published for this version

  41. 5.21.0-integration-engines-5-21-0-11-integration-itx-refactor-123024dbffa4e26814bc0b4ce921317c3bbd451f.226 Sept 2024pre-release

    Nothing published for this version

  42. 5.21.0-integration-engines-5-21-0-11-integration-itx-refactor-123024dbffa4e26814bc0b4ce921317c3bbd451f.126 Sept 2024pre-release

    Nothing published for this version

  43. 5.21.0-integration-engines-5-21-0-10-integration-itx-refactor-6c3c8b6657befa0cefc9e1276cfb23d2a4921b11.226 Sept 2024pre-release

    Nothing published for this version

  44. 5.21.0-integration-engines-5-21-0-10-integration-itx-refactor-6c3c8b6657befa0cefc9e1276cfb23d2a4921b11.126 Sept 2024pre-release

    Nothing published for this version

  45. 5.21.0-integration-25129.126 Sept 2024pre-release

    Nothing published for this version

  46. 5.21.0-dev.1115 Oct 2024pre-release

    Nothing published for this version

  47. 5.21.0-dev.1015 Oct 2024pre-release

    Nothing published for this version

  48. 5.21.0-dev.910 Oct 2024pre-release

    Nothing published for this version

  49. 5.21.0-dev.810 Oct 2024pre-release

    Nothing published for this version

  50. 5.21.0-dev.710 Oct 2024pre-release

    Nothing published for this version

  51. 5.21.0-dev.69 Oct 2024pre-release

    Nothing published for this version

  52. 5.21.0-dev.58 Oct 2024pre-release

    Nothing published for this version

  53. 5.21.0-dev.47 Oct 2024pre-release

    Nothing published for this version

  54. 5.21.0-dev.32 Oct 2024pre-release

    Nothing published for this version

  55. 5.21.0-dev.22 Oct 2024pre-release

    Nothing published for this version

  56. 5.21.0-dev.126 Sept 2024pre-release

    Nothing published for this version

  57. 5.20.024 Sept 2024
    Release notes

    🌟 Help us spread the word about Prisma by starring the repo or posting on X about the release. 🌟

    Highlights

    strictUndefinedChecks in Preview

    With Prisma ORM 5.20.0, the Preview feature strictUndefinedChecks will disallow any value that is explicitly undefined and will be a runtime error. This change is direct feedback from this GitHub issue and follows our latest proposal on the same issue.

    To demonstrate the change, take the following code snippet:

    prisma.table.deleteMany({
  where: {
    // If `nullableThing` is nullish, this query will remove all data.
    email: nullableThing?.property,
  }
})

    In Prisma ORM 5.19.0 and below, this could result in unintended behavior. In Prisma ORM 5.20.0, if the strictUndefinedChecks Preview feature is enabled, you will get a runtime error instead:

    Invalid \`prisma.user.findMany()\` invocation in
/client/tests/functional/strictUndefinedChecks/test.ts:0:0
  XX })
  XX 
  XX test('throws on undefined input field', async () => {
→ XX   const result = prisma.user.deleteMany({
         where: {
           email: undefined
                  ~~~~~~~~~
         }
       })
Invalid value for argument \`where\`: explicitly \`undefined\` values are not allowed."

    We have also introduced the Prisma.skip symbol, which will allow you to get the previous behavior if desired.

    prisma.table.findMany({
  where: {
    // Use Prisma.skip to skip parts of the query
    email: nullableEmail ?? Prisma.skip
  }
})

    From Prisma ORM 5.20.0 onward, we recommend enabling strictUndefinedChecks, along with the TypeScript compiler option exactOptionalPropertyTypes, which will help catch cases of undefined values at compile time. Together, these two changes will help protect your Prisma queries from potentially destructive behavior.

    strictUndefinedChecks will be a valid Preview feature for the remainder of Prisma ORM 5. With our next major version, this behavior will become the default and the Preview feature will be “graduated” to Generally Available.

    If you have any questions or feedback about strictUndefinedChecks, please ask/comment in our dedicated Preview feature GitHub discussion.

    typedSql bug fix

    Thank you to everyone who has tried out our typedSql Preview feature and provided feedback! This release has a quick fix for typescript files generated when Prisma Schema enums had hyphens.

    Fixes and improvements

    Prisma

    Prisma Engines

    Credits

    Huge thanks to @mcuelenaere, @pagewang0, @key-moon, @pranayat, @yubrot, @thijmenjk, @mydea, @HRM, @haaawk, @baileywickham, @brian-dlee, @nickcarnival, @eruditmorina, @nzakas, and @gutyerrez for helping!

    Open source →
  58. 5.20.0-integration-otel-peer-deps.26 Sept 2024pre-release

    Nothing published for this version

  59. 5.20.0-integration-otel-peer-deps.15 Sept 2024pre-release

    Nothing published for this version

  60. 5.20.0-integration-fix-driver-adapters-breaking.124 Sept 2024pre-release

    Nothing published for this version