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.17.0-dev.2410 Jul 2024pre-release

    Nothing published for this version

  2. 5.17.0-dev.239 Jul 2024pre-release

    Nothing published for this version

  3. 5.17.0-dev.229 Jul 2024pre-release

    Nothing published for this version

  4. 5.17.0-dev.219 Jul 2024pre-release

    Nothing published for this version

  5. 5.17.0-dev.209 Jul 2024pre-release

    Nothing published for this version

  6. 5.17.0-dev.199 Jul 2024pre-release

    Nothing published for this version

  7. 5.17.0-dev.185 Jul 2024pre-release

    Nothing published for this version

  8. 5.17.0-dev.173 Jul 2024pre-release

    Nothing published for this version

  9. 5.17.0-dev.163 Jul 2024pre-release

    Nothing published for this version

  10. 5.17.0-dev.153 Jul 2024pre-release

    Nothing published for this version

  11. 5.17.0-dev.143 Jul 2024pre-release

    Nothing published for this version

  12. 5.17.0-dev.133 Jul 2024pre-release

    Nothing published for this version

  13. 5.17.0-dev.123 Jul 2024pre-release

    Nothing published for this version

  14. 5.17.0-dev.113 Jul 2024pre-release

    Nothing published for this version

  15. 5.17.0-dev.1028 Jun 2024pre-release

    Nothing published for this version

  16. 5.17.0-dev.928 Jun 2024pre-release

    Nothing published for this version

  17. 5.17.0-dev.828 Jun 2024pre-release

    Nothing published for this version

  18. 5.17.0-dev.728 Jun 2024pre-release

    Nothing published for this version

  19. 5.17.0-dev.628 Jun 2024pre-release

    Nothing published for this version

  20. 5.17.0-dev.528 Jun 2024pre-release

    Nothing published for this version

  21. 5.17.0-dev.428 Jun 2024pre-release

    Nothing published for this version

  22. 5.17.0-dev.227 Jun 2024pre-release

    Nothing published for this version

  23. 5.17.0-dev.126 Jun 2024pre-release

    Nothing published for this version

  24. 5.16.29 Jul 2024
    Release notes

    Today, we are issuing the 5.16.2 patch release to fix an issue in Prisma client.

    Fix in Prisma Client

    Open source →
  25. 5.16.2-dev.19 Jul 2024pre-release

    Nothing published for this version

  26. 5.16.127 Jun 2024
    Release notes

    Today, we are issuing the 5.16.1 patch release to fix an issue in Prisma client.

    Fix in Prisma Client

    Open source →
  27. 5.16.1-dev.127 Jun 2024pre-release

    Nothing published for this version

  28. 5.16.025 Jun 2024
    Release notes

    🌟 Help us spread the word about Prisma by starring the repo or tweeting about the release. 🌟

    Highlights

    Omit model fields globally

    With Prisma ORM 5.16.0 we’re more than happy to announce that we’re expanding the omitApi Preview feature to also include the ability to omit fields globally.

    When the Preview feature is enabled, you’re able to define fields to omit when instantiating Prisma Client.

    const prisma = new PrismaClient({
      omit: {
        user: {
          // make sure that password is never queried.
          password: true,
        },
      },
    });
    

    You’re also able to omit fields from multiple models and multiple fields from the same model

    const prisma = new PrismaClient({
      omit: {
        user: { 
          // make sure that password and internalId are never queried.
          password: true,
          internalId: true,
        },
        post: {
          secretkey: true,
        },
      },
    });
    

    With both local and global omit, you now have the flexibility to completely remove sensitive fields while also tailoring individual queries. If you need the ability to generally omit a field except in a specific query, you can also overwrite a global omit locally

    const prisma = new PrismaClient({
      omit: {
        user: { 
          // password is omitted globally.
          password: true,
        },
      },
    });
    
    const userWithPassword = await prisma.user.findUnique({
      omit: { password: false }, // omit now false, so password is returned
      where: { id: 1 },
    });
    

    Changes to prismaSchemaFolder

    In 5.15.0 we released the prismaSchemaFolder Preview feature, allowing you to create multiple Prisma Schema files in a prisma/schema directory. We’ve gotten a lot of great feedback and are really excited with how the community has been using the feature.

    To continue improving our multi-file schema support, we have a few breaking changes to the prismaSchemaFolder feature:

    • When using relative paths in Prisma Schema files with the prismaSchemaFolder feature, a path is now relative to the file it is defined in rather than relative to the prisma/schema folder. This means that if you have a generator block in /project/prisma/schema/config/generator.prisma with an output of ./foo the output will be resolved to /project/prisma/schema/config/foo rather than /project/prisma/foo. The path to a SQLite file will be resolved in the same manner.
    • We realized that during migration many people would have prisma/schema as well as prisma/schema.prisma. Our initial implementation looked for a .prisma file first and would ignore the schema folder if it exists. This is now an error.

    Changes to fullTextSearch

    In order to improve our full-text search implementation we have made a breaking change to the fullTextSearch Preview feature.

    Previously, when the feature was enabled we updated the <Model>OrderByWithRelationInput TypeScript type with the <Model>OrderByWithRelationAndSearchRelevanceInput type. However, we have noted that there are no cases where relational ordering is needed but search relevance is not. Thus, we have decided to remove the <Model>OrderByWithRelationAndSearchRelevanceInput naming and only use the <Model>OrderByWithRelationInput naming.

    Fixes and improvements

    Prisma

    Language tools (e.g. VS Code)

    Prisma Engines

    Credits

    Huge thanks to @key-moon, @pranayat, @yubrot, @skyzh, @brian-dlee, @mydea, @nickcarnival, @eruditmorina, @nzakas, @gutyerrez, @avallete, @ceddy4395, @Kayoshi-dev, @yehonatanz for helping!

    Open source →
  29. 5.16.0-integration-vitest-workaround.225 Jun 2024pre-release

    Nothing published for this version

  30. 5.16.0-integration-vitest-workaround.117 Jun 2024pre-release

    Nothing published for this version

  31. 5.16.0-integration-sqlite-fix.111 Jun 2024pre-release

    Nothing published for this version

  32. 5.16.0-integration-optimize-login-v2.519 Jun 2024pre-release

    Nothing published for this version

  33. 5.16.0-integration-optimize-login-v2.418 Jun 2024pre-release

    Nothing published for this version

  34. 5.16.0-integration-optimize-login-v2.318 Jun 2024pre-release

    Nothing published for this version

  35. 5.16.0-integration-optimize-login-v2.218 Jun 2024pre-release

    Nothing published for this version

  36. 5.16.0-integration-optimize-login-v2.118 Jun 2024pre-release

    Nothing published for this version

  37. 5.16.0-integration-joel-repro-gh-11789.218 Jun 2024pre-release

    Nothing published for this version

  38. 5.16.0-integration-joel-repro-gh-11789.118 Jun 2024pre-release

    Nothing published for this version

  39. 5.16.0-integration-janpio-studio-prisma-config.314 Jun 2024pre-release

    Nothing published for this version

  40. 5.16.0-integration-janpio-studio-prisma-config.214 Jun 2024pre-release

    Nothing published for this version

  41. 5.16.0-integration-janpio-studio-prisma-config.114 Jun 2024pre-release

    Nothing published for this version

  42. 5.16.0-integration-fix-empty-schema.110 Jun 2024pre-release

    Nothing published for this version

  43. 5.16.0-integration-engines-5-16-0-15-fix-fts-relation-input-name-9388ddb70ab6bc6cba66ec9b351906f857af5d3f.117 Jun 2024pre-release

    Nothing published for this version

  44. 5.16.0-integration-engines-5-16-0-1-fix-sqlite-concurrent-writes-74a48e9f33b0a8b403045af35430ce444541be88.15 Jun 2024pre-release

    Nothing published for this version

  45. 5.16.0-integration-crypto-client-vercel.25 Jun 2024pre-release

    Nothing published for this version

  46. 5.16.0-integration-crypto-client-vercel.15 Jun 2024pre-release

    Nothing published for this version

  47. 5.16.0-dev.6425 Jun 2024pre-release

    Nothing published for this version

  48. 5.16.0-dev.6325 Jun 2024pre-release

    Nothing published for this version

  49. 5.16.0-dev.6224 Jun 2024pre-release

    Nothing published for this version

  50. 5.16.0-dev.6124 Jun 2024pre-release

    Nothing published for this version

  51. 5.16.0-dev.6024 Jun 2024pre-release

    Nothing published for this version

  52. 5.16.0-dev.5921 Jun 2024pre-release

    Nothing published for this version

  53. 5.16.0-dev.5821 Jun 2024pre-release

    Nothing published for this version

  54. 5.16.0-dev.5720 Jun 2024pre-release

    Nothing published for this version

  55. 5.16.0-dev.5620 Jun 2024pre-release

    Nothing published for this version

  56. 5.16.0-dev.5520 Jun 2024pre-release

    Nothing published for this version

  57. 5.16.0-dev.5420 Jun 2024pre-release

    Nothing published for this version

  58. 5.16.0-dev.5319 Jun 2024pre-release

    Nothing published for this version

  59. 5.16.0-dev.5119 Jun 2024pre-release

    Nothing published for this version

  60. 5.16.0-dev.5019 Jun 2024pre-release

    Nothing published for this version