I am facing a problem and I am not too sure which way is the best to go and I would need your help and experience to make the best choice.
I have several Single Board Computers (SBC) running a Django server with an SQLiteDB. With them I collect all sort of data, and can be run independently from each other. Most of the time they are running on a LAN only.
I have a web server, connected to Internet running Django, which will run the main database PostgreSQL.
users can input info some data and visualize them directly from the website.
Regularly, each SBC will connect to the internet and will need to synchronise their data with the main DB.
how should I handle this synchronisation?
Should I declare the main DB in each SBC, and run a script to synchronize the data?
Should I get some script which will send post request to the Mother DB to populate the db?
Should I get a script to prepare a csv/json file that will be uploaded to the main server and a routine on the mother DB will handle them.
How can I manage the other synchronisation? from the mother to the children?
Well at the moment I am a bit lost and would need your opinion on how to handle this.