Suppose i have an application, and an admin page for it.

Our sales department might want to change some global settings, like number of trial days on signup, or number of purchasable products for one user.

Since i do not want to deploy a new version every time a small request like this is made, it seems evident that these values should be stored in a database and available to change on the admin page.

However I do not find any “smart” way of doing it in our PSQL db, best solution so far is to make a public.global_settings table with name value pairs, then query that in the app.

I am wondering if there is a better way of doing this… ?