Hi Team,
I'm after a recommendation what kind of database should i use under FlowFuse. Currently I have the PoC working fetching data out of a GoogleSheet file.
The end goal:
I will get csv exports from different systems most of them will update the csv in every few second. I will need to store them somewhere relatively secure cloud storage( opened for ideas) . I think the best would be to create db files from those csv files and update them as soon as the csv file will be updated.
I need to access the db from flow fuse and display some data out of them on the dashboard.
I'v never worked with database. So please advise where should I start. Or if there is any other idea beside db , I'm opened for suggestions.
Many thanks