I’m working in an app that has a settings page with ~30 settings (user preferences), each store has its settings so having one db table for settings is not possible. I’m using Postgres and I can easily use JSONB with a small JSON object per store and call it a day, but if I ever want to add a setting it’ll be a little bit of a pain.
I’m wondering how do you handle user preferences in Shopify Apps on the server level? 1 database per tenant/store?
