CodeWithAloha / HIERR

A Human-Centered Digital Engagement Process for the Hawai‘i Economic Recovery & Resilience Project with the State Office of Planning & Sustainable Development
https://hierr.vercel.app/
8 stars 7 forks source link

Migrate demographic questions out of the migrations file #166

Closed avenmia closed 3 months ago

avenmia commented 8 months ago

The demographic questions are hard-coded in SQL which make it difficult for to swap out custom questions.

One solution is that the questions are stored in a JSON blob and stored as an entry in the database. The application could have an environment variable specifying which database questions to get from the database.