search

prisma / docs

📚 Prisma Documentation
https://www.prisma.io/docs
Apache License 2.0
981 stars 777 forks source link

SQL Server `Json` is documented, but does not exist #4935

Open janpio opened 1 year ago

janpio commented 1 year ago

Confusion around about our Json support for SQL Server:

prisma.io/docs/reference/api-reference/prisma-schema-reference#json prisma.io/docs/reference/api-reference/prisma-schema-reference#microsoft-sql-server-7

But:

https://github.com/prisma/prisma/issues/7417 (I confirmed this manually) https://github.com/prisma/prisma/issues/6843 It seems to not actually be implemented.

Why do we document otherwise? (Our SQL Server page is not helpful here: prisma.io/docs/concepts/database-connectors/sql-server#type-mapping-between-microsoft-sql-server-to-prisma-schema)

filipc30 commented 1 year ago

It seems like this confusion is going on for a longer period of time.. Is there going to be an implementation of Json type support? Or should I get used to saving my Json data as text (string) in prisma?

itpropro commented 2 months ago

@janpio as JSON is natively supported in MSSQL for a while now (back to MSSQL 2016), will there be an update to Prisma? https://learn.microsoft.com/en-us/sql/relational-databases/json/json-data-sql-server?view=sql-server-ver16

jharrell commented 1 month ago

@itpropro hey there! This is an issue around our documentation, not the engine of Prisma ORM. The issue around support for JSON in Prisma ORM can be found here: https://github.com/prisma/prisma/issues/7417

itpropro commented 1 month ago

@itpropro hey there! This is an issue around our documentation, not the engine of Prisma ORM. The issue around support for JSON in Prisma ORM can be found here: prisma/prisma#7417

Thanks for your reply @jharrell, but that issue is already open for over 3 years and there doesn't seem to be a status on that. Any chance you or someone else from the prisma team can give a statement on the two most important MSSQL issues, which are Managed Identity/Token support (#13853) and JSON support (#7417)? Thank you!

jharrell commented 1 month ago

@itpropro hi again!

Unfortunately, I don't have much information on those issues. I do not think they are planned for at least the coming quarter, perhaps longer.

itpropro commented 1 month ago

@itpropro hi again!

Unfortunately, I don't have much information on those issues. I do not think they are planned for at least the coming quarter, perhaps longer.

That's quite sad to hear, but thanks for coming back anyway!