Problem
SQLite has had support for JSON field type for a while. Sequelize supports this field type on par with Postgres and MySQL.
Lack of support for this field type by Prisma is preventing us from porting over our project.
SQLite is a great bootstrapping technology that allows developers to quickly prototype applications without introducing new dependencies such as docker or worry about running yet another service in the development flow. JSON field type gives us the option to have a nosql database colocated in a sql database.
Suggested solution
Please implement support for this feature. See JSON Extension documentation and refer to Sequelize's implementation if required.
Alternatives
Defer migration to Prisma and stick with Sequelize. Maintain status quo.
Additional context
cc: @ryands17
ref: #3575
Problem
SQLite has had support for JSON field type for a while.
Sequelizesupports this field type on par with Postgres and MySQL.Lack of support for this field type by Prisma is preventing us from porting over our project.
SQLite is a great bootstrapping technology that allows developers to quickly prototype applications without introducing new dependencies such as docker or worry about running yet another service in the development flow. JSON field type gives us the option to have a
nosqldatabase colocated in asqldatabase.Suggested solution
Please implement support for this feature. See JSON
Extensiondocumentation and refer toSequelize's implementation if required.Alternatives
Defer migration to Prisma and stick with
Sequelize. Maintain status quo.Additional context
cc: @ryands17
ref: #3575