First off, my knowledge of web related coding is a 5 on a scale from 1 to 100. My python and sql language skills are better but I am by no means an expert in either.
The task: I want to dump a sqlite database of a few thousand records once a day to a MySQL database on my private domain that is running MySQL.
Question: I know the Arduino side can NOT handle this task efficiently, but the linux side should be able to using Python scripts.
1) What do I need on the Arduino/Linux side to make the connection with the web host? {code examples or link to tutorials would be great} 2) What is the syntax that would transfer several rows of data once the connections is made 3) What do I need on the web server to accept the data from the Arduino and insert into the MySQL db?
I have googled this topic for help, but either I am not asking the right questions or the method is more complicated than I understand at this point.
Any help or direction as to where or how to learn this is greatly appreciated.
Thanks a bunch in advance!
Aucun commentaire:
Enregistrer un commentaire