docs.nestjs.com icon indicating copy to clipboard operation
docs.nestjs.com copied to clipboard

doc(prisma): add prsima connection to mssql and azure sql

Open engcfraposo opened this issue 1 year ago • 0 comments

The changes made in the new version of the markdown add information about configuring Microsoft SQL Server and Azure SQL Server for use with the Prisma ORM (Object-relational mapping) system. Here's a detailed explanation:

The summary section of the collapsible details section is updated from "Expand if you're using PostgreSQL or MySQL" to "Expand if you're using PostgreSQL, MySQL, MsSQL or Azure SQL". This change reflects the expanded scope of the content.

After the sections on PostgreSQL and MySQL, a new section is added on "Microsoft SQL Server / Azure SQL Server". This provides specific information about configuring these additional database systems for use with Prisma.

In the new section, code snippets are provided for the schema.prisma and .env files similar to the ones given for PostgreSQL and MySQL. The provider in schema.prisma is specified as "sqlserver", indicating the use of Microsoft SQL Server or Azure SQL Server.

In the .env code snippet, the DATABASE_URL is updated to show the correct format for a Microsoft SQL Server or Azure SQL Server connection string.

There is also a note added to inform users that if they're unsure about the encrypt placeholder in the connection string, it should most likely be set to true. This is a security feature specific to these systems.

In conclusion, the markdown is expanded to provide information for additional database systems (Microsoft SQL Server and Azure SQL Server), increasing its utility for a broader range of users.

PR Checklist

Please check if your PR fulfills the following requirements:

  • [x] The commit message follows our guidelines: https://github.com/nestjs/docs.nestjs.com/blob/master/CONTRIBUTING.md

PR Type

What kind of change does this PR introduce?

The changes made in the new version of the markdown add information about configuring Microsoft SQL Server and Azure SQL Server for use with the Prisma ORM (Object-relational mapping) system

  • [ ] Bugfix
  • [ ] Feature
  • [ ] Code style update (formatting, local variables)
  • [ ] Refactoring (no functional changes, no api changes)
  • [ ] Build related changes
  • [x] Docs
  • [ ] Other... Please describe:

What is the current behavior?

The summary section of the collapsible details section is updated from "Expand if you're using PostgreSQL or MySQL"

Issue Number: N/A

What is the new behavior?

"Expand if you're using PostgreSQL, MySQL, MsSQL or Azure SQL".

Does this PR introduce a breaking change?

  • [ ] Yes
  • [x] No

Other information

engcfraposo avatar Jul 12 '23 13:07 engcfraposo