Move all settings to SQL database - strawman

Continuing the discussion from Home Assistant Emoncms Addon:

I have been thinking about this add-on by @inverse and one of the limitations I think it will hit is the inability to edit the settings held in settings.ini via the UI.

There are 2 options as I see it;

  1. Build a mechanism to edit the ini file and write it back
  2. Move the settings to the sql database that is already used for some settings, and produce a UI for editing them.

I suspect the tools for creating the UI to edit settings held in a database are probably more readily available than editing the file.

There could be a flag that is set when the settings file is read the first time (on migration) with the option to reset all settings to default by reading the file again.

As I say, bit of a strawman…