Persisting dynamic form data

by CodeYogi   Last Updated December 20, 2017 12:05 PM

My application uses a relational database but there is a feature requirement to display a survey form to users at the end of each quarter/year etc. I understand that this data maybe used to do some analysis in near future but the issue is the form would have many key value pairs and I am sure that it will keep on changing.

I did some research and found that people suggest to have NoSQL databases for these kind of stuff but I can't change my database for just one feature, other option is to have a JSON column in the database table and store all the key-value pairs there.

I don't have enough experience to know what can be tradeoff or if there are other alternatives?

Related Questions

Managing linked resources in UI

Updated July 08, 2017 04:05 AM

Strategy for fetching data from an API

Updated December 13, 2017 16:05 PM

Designing a role based system with more granularity

Updated December 14, 2017 12:05 PM

Thinking about roles and permissions

Updated December 14, 2017 17:05 PM