So, first of all hello to everyone, I hope you are having a good day :)
I will give you a little context. I coded a program for my job, in which I save to a database Errors ID and their solutions. It could be one or more solutions. Right now the database is a text file which contains a dictionary, with keys being the Error ID and the values, the solutions.
This database right now is local because of some approvals from my company, but the idea is to put the database on a server, so that users can consult and update it in real time.
The question is, should I keep it like a txt and have a script to allow the program to connect to the server (maybe sftp?) to be able to open, read and write the txt file OR should I export all the data to a db file using mysql/etc?
Thanks in advance, I hope you understand my question. Feel free to ask for more details if it isn't enough or for clarification.