Storing connection details locally

[travierm]

Feel free to edit, this is just an initial scope of the issue

After users provide valid connection details to a server we should store that locally in a JSON file.

When the app is reloaded it can read that file and list the possible connections a user can make.

Scope

• Process for writing and reading JSON files from a directory in the app
• Users should have a checkbox such as "Save Connection Details" that defaults to true
• A component that lists all possible connections from the JSON file. This could live as a list to the left side of the login screen or be its own page entirely

Security Risks

• Stored files will need to be encrypted eventually

Example of Connection Pages from other apps

MySQL Workbench:

[GreyDelamar]

Nice!!!

[GreyDelamar]

@georgeglessner you want to grab this one? Main focus being on the file storage, we can always help with the frontend ❤️

[georgeglessner]

Sorry just seeing this, I can take a look into some solutions

[GreyDelamar]

All good 👍 no rush on any of this

[georgeglessner]

What do we think of storing all info except the password? So the connections will still be saved, but the user will still have to enter password each time. Just thinking on the security endpoint. I am fine with either or, just looking for suggestions.

[GreyDelamar]

I'm pretty torn on which way to go

[GreyDelamar]

check telegram easier to chat on

[georgeglessner]

Proposed idea:

• Keep using local storage for now
  • Encrypt data with a master password before setting local storage object
• Prompt user for master password upon opening app
  • On success, restore all connections

Still undecided of which algo to use at the moment.