@prisma/client

Releases

1. 4.10.0-dev.611 Feb 2023pre-release

   Nothing published for this version

2. 4.10.0-dev.601 Feb 2023pre-release

   Nothing published for this version

3. 4.10.0-dev.591 Feb 2023pre-release

   Nothing published for this version

4. 4.10.0-dev.581 Feb 2023pre-release

   Nothing published for this version

5. 4.10.0-dev.571 Feb 2023pre-release

   Nothing published for this version

6. 4.10.0-dev.5631 Jan 2023pre-release

   Nothing published for this version

7. 4.10.0-dev.5531 Jan 2023pre-release

   Nothing published for this version

8. 4.10.0-dev.5431 Jan 2023pre-release

   Nothing published for this version

9. 4.10.0-dev.5331 Jan 2023pre-release

   Nothing published for this version

10. 4.10.0-dev.5231 Jan 2023pre-release

    Nothing published for this version

11. 4.10.0-dev.5131 Jan 2023pre-release

    Nothing published for this version

12. 4.10.0-dev.5031 Jan 2023pre-release

    Nothing published for this version

13. 4.10.0-dev.4930 Jan 2023pre-release

    Nothing published for this version

14. 4.10.0-dev.4830 Jan 2023pre-release

    Nothing published for this version

15. 4.10.0-dev.4730 Jan 2023pre-release

    Nothing published for this version

16. 4.10.0-dev.4630 Jan 2023pre-release

    Nothing published for this version

17. 4.10.0-dev.4330 Jan 2023pre-release

    Nothing published for this version

18. 4.10.0-dev.4227 Jan 2023pre-release

    Nothing published for this version

19. 4.10.0-dev.4127 Jan 2023pre-release

    Nothing published for this version

20. 4.10.0-dev.4027 Jan 2023pre-release

    Nothing published for this version

21. 4.10.0-dev.3927 Jan 2023pre-release

    Nothing published for this version

22. 4.10.0-dev.3826 Jan 2023pre-release

    Nothing published for this version

23. 4.10.0-dev.3726 Jan 2023pre-release

    Nothing published for this version

24. 4.10.0-dev.3626 Jan 2023pre-release

    Nothing published for this version

25. 4.10.0-dev.3526 Jan 2023pre-release

    Nothing published for this version

26. 4.10.0-dev.3426 Jan 2023pre-release

    Nothing published for this version

27. 4.10.0-dev.3326 Jan 2023pre-release

    Nothing published for this version

28. 4.10.0-dev.3225 Jan 2023pre-release

    Nothing published for this version

29. 4.10.0-dev.3125 Jan 2023pre-release

    Nothing published for this version

30. 4.10.0-dev.3025 Jan 2023pre-release

    Nothing published for this version

31. 4.10.0-dev.2925 Jan 2023pre-release

    Nothing published for this version

32. 4.10.0-dev.2825 Jan 2023pre-release

    Nothing published for this version

33. 4.10.0-dev.2725 Jan 2023pre-release

    Nothing published for this version

34. 4.10.0-dev.2625 Jan 2023pre-release

    Nothing published for this version

35. 4.10.0-dev.2524 Jan 2023pre-release

    Nothing published for this version

36. 4.10.0-dev.2423 Jan 2023pre-release

    Nothing published for this version

37. 4.10.0-dev.2323 Jan 2023pre-release

    Nothing published for this version

38. 4.10.0-dev.2223 Jan 2023pre-release

    Nothing published for this version

39. 4.10.0-dev.2121 Jan 2023pre-release

    Nothing published for this version

40. 4.10.0-dev.2020 Jan 2023pre-release

    Nothing published for this version

41. 4.10.0-dev.1920 Jan 2023pre-release

    Nothing published for this version

42. 4.10.0-dev.1820 Jan 2023pre-release

    Nothing published for this version

43. 4.10.0-dev.1719 Jan 2023pre-release

    Nothing published for this version

44. 4.10.0-dev.1619 Jan 2023pre-release

    Nothing published for this version

45. 4.10.0-dev.1519 Jan 2023pre-release

    Nothing published for this version

46. 4.10.0-dev.1419 Jan 2023pre-release

    Nothing published for this version

47. 4.10.0-dev.1319 Jan 2023pre-release

    Nothing published for this version

48. 4.10.0-dev.1218 Jan 2023pre-release

    Nothing published for this version

49. 4.10.0-dev.1118 Jan 2023pre-release

    Nothing published for this version

50. 4.10.0-dev.1018 Jan 2023pre-release

    Nothing published for this version

51. 4.10.0-dev.918 Jan 2023pre-release

    Nothing published for this version

52. 4.10.0-dev.818 Jan 2023pre-release

    Nothing published for this version

53. 4.10.0-dev.718 Jan 2023pre-release

    Nothing published for this version

54. 4.10.0-dev.618 Jan 2023pre-release

    Nothing published for this version

55. 4.10.0-dev.518 Jan 2023pre-release

    Nothing published for this version

56. 4.10.0-dev.418 Jan 2023pre-release

    Nothing published for this version

57. 4.10.0-dev.318 Jan 2023pre-release

    Nothing published for this version

58. 4.10.0-dev.217 Jan 2023pre-release

    Nothing published for this version

59. 4.9.017 Jan 2023
    Release notes

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

    Highlights

    Initial support for database views (Preview)

    This release introduces a new keyword, view, behind the views Preview feature flag. You can manually add a view to your Prisma schema, which is ignored when running migrations. This is a small step forward but should already be helpful to many of you depending on workarounds and shell scripts to work with views and Migrate.

    Here is an example usage of views:

    generator client {
      provider        = "prisma-client-js"
      previewFeatures = ["views"]
    }
    
    view UserInfo {
      id    Int    @id
      // from the User model
      email String
      name  String
      // from the Profile model
      bio   String
    }
    
    model User {
      id      Int      @id @default(autoincrement())
      email   String   @unique
      name    String?
      profile Profile?
    }
    
    model Profile {
      id     Int    @id @default(autoincrement())
      bio    String
      user   User   @relation(fields: [userId], references: [id])
      userId Int    @unique
    }
    

    To learn more, head to our documentation. Try it out and let us know your thoughts on this GitHub issue.

    Multi-schema support for SQL Server (Preview)

    We're thrilled to share that this release adds Preview support for multi-schema for SQL Server.

    This release adds support for:

    • Introspecting databases that organize objects in multiple database schemas
    • Managing multi-schema database setups directly from Prisma schema
    • Generating migrations that are database schema-aware with Prisma Migrate
    • Querying across multiple database schemas with Prisma Client

    If you already have a SQL Server database using multiple schemas, you can quickly get up and running and set up multiple schemas by:

    • Enabling the Preview feature in the Prisma schema
    • Defining the schemas in the schemas property in the datasource block
    • Introspecting your database using prisma db pull

    You can further evolve your database schema using the multi-schema Preview feature by using prisma migrate dev.

    For further details, refer to our documentation and let us know what you think in this GitHub issue.

    Prisma Client Extensions improvements

    In this release, we've made a number of improvements to the Prisma Client Extensions Preview feature:

    1. Retrieving the current model name at runtime You can now get the name of the current model at runtime using Prisma.getExtensionContext(this).name. You might use this to write out the model name to a log, to send the name to another service, or to branch your code based on the model. You can learn more about this in our docs.

    2. Improved type safety when defining custom model methods Prisma Client now provides a set of type utilities that tap into input and output types. They are fully dynamic, which means they adapt to any given model and schema. You can use them to improve your custom model methods' auto-completion. This is especially useful in shared extensions. Learn more about this in our docs.

    Let us know what you think in this GitHub issue and in case you run into any issues, please create a bug report.

    Introspection and Migration engine improvements

    In this release, we moved the Introspection Engine (responsible for prisma db pull) which the Migration Engine will now serve. Previously, the Introspection Engine was stand-alone.

    Let us know what you think in this GitHub issue and in case you run into any issues, please create a bug report.

    MongoDB WriteConflict bug fix

    This version also comes with a notable bug fix: In our MongoDB provider, any queries that are returned with a WriteConflict error Prisma now will retry the query, similar to how other MongoDB drivers and clients do.

    Prisma plugin for JetBrains IDEs

    If you are using a JetBrains IDE the team over at JetBrains recently released an official Prisma plugin in their Plugin Marketplace.

    Thank you, @JetBrains, for working on this! Next to our VS Code extension for Prisma and our general language server, which works in many editors, most relevant editors should now be covered.

    Accelerate (Early Access)

    We’re thrilled to announce Early Access to Accelerate.

    Accelerate is a global database cache. It is available in 280 locations and has built-in connection pooling for serverless apps. You can make your queries up to 1000 times faster on any Prisma-supported database, reducing your query response times.

    Join the waiting list for Accelerate here.

    Fixes and improvements

    Prisma

    • Feature Request: Jetbrains (IntelliJ IDEA, Webstorm) Plugin
    • Misleading 'We need to reset the PostgreSQL database' when using PostgreSQL schemas
    • Solve "P1012 Introspection failed" errors on Windows CI
    • support NanoID
    • Create CI worker without a proper openssl or libc installation to improve snapshot testing suite
    • db pull --url with an invalid url produces a misleading error message
    • (re)-Introspection errors have a misleading error message
    • multi-schema + introspection: rename models and enums to avoid name collisions
    • multiSchema + introspection: add --schemas param to the db pull command
    • Cross schema reference with foreign key not working in 4.7.0+
    • Handle missing schemas property different when cross schema references are detected (when multiSchema preview feature is enabled)
    • db pull with multiSchema enabled and schemas defined, outputs public in CLI message anyway
    • Remove DML dependency from MongoDB introspection
    • I want short unique id. UUID, CUID are too long
    • Completions: for schemas property in datasource
    • Completions @@schema attribute
    • OS Support: improve SSL detection on debian distros
    • multiSchema: add schemas property to getConfig output
    • multiSchema: migrate reset with sqlserver does not delete second schema
    • Prisma 4.9.x (dev version) broke openssl detection for Linux distros besides Alpine and Debian-based distros, like RHEL
    • Wrong db pull warning with multiSchema preview feature, it says that These enums were enriched with @@map information taken from the previous Prisma schema. but the schema file datamodel is actually empty.
    • PSL: Recognize the view keyword
    • previewFeatures = ["multiSchema"] Error when doing db pull
    • #17126 broke the platform-serverless-vercel/vercel-cli ecosystem tests
    • When `distro` is undefined, the output of `ldconfig` is ignored because of the `sed: -e expression #1, char 7: unknown option to `s'` silent error

    Prisma Client

    • Detect absense of openssl and inform the user about it
    • [email protected] - "RangeError: Maximum call stack size exceeded" when clientExtensions enabled
    • Prisma 4.8 produces conflicting typescript types for custom many to many relations
    • Using findUnique on 4.8.0 with nested where and include produces an object that doesn't include entities you specify in include
    • Error: Maximum call stack size exceeded is thrown after I used clientExtensions as preview feature.
    • MongoDB: Using delete on a one-to-one relation while updating removes other relations
    • Promise types are not unwrapped properly when using async/await in WebStorm
    • Deeply nested objects aren't typed when clientExtensions is enabled

    Prisma Migrate

    • migrations: Ignore view definitions
    • Migrate dev breaks on multiSchema with SQL Server

    Language tools (e.g. VS Code)

    • Improve local development workflow and update documentation
    • Integer.MAX_VALUE is not portable across clients
    • Quick Fix: add @@schema attribute to model / enum
    • Completions: from the list of available schema namespaces
    • Recognizing the view keyword

    Prisma Engines

    • update napi dependencies from 2.9.1 to 2.10.1
    • me/ie rewiring: add introspect tests to migration-engine

    Credits

    Huge thanks @rintaun, @ivan, @Mini256, @fubhy, @unflxw, @Mosaab-Emam for helping!

    📺 Join us for another "What's new in Prisma" live stream

    Learn about the latest release and other news from the Prisma community by joining us for another "What's new in Prisma" live stream.

    The stream takes place on YouTube on Thursday, January 26 at 5 pm Berlin | 8 am San Francisco.

    Open source →
60. 4.9.0-integration-version-command-generated-client-16874.35 Jan 2023pre-release

    Nothing published for this version