On Thu, 10 Sep 2020 20:38:41 +0100, "NY"  declaimed the
following:

>Yes I'd already identified that cron would be a good way of triggering the
>upload. It's a matter of working out what can be run (via cron) at the Pi
>which makes a remote web server add data to an SQL database held on its
>server, preferably searching for each row of data that is about to be added
>to check that it doesn't already have it - to make the process resilient to
>temporary outages which would otherwise cause it to miss data if there was
>no catchup mechanism.
>

 Before worrying about the cron job, you need to determine what
capabilities the remote site provides.

 If you have direct access to the database server itself (with an
account/password for the DBMS and suitable privileges for add/delete/update
of records) then you can run a script issuing SQL DML statements meaning
all the checking for duplicates, et al can be done at your end.

 BTW "SQL database" is meaningless. SQL is a Query Language, not a
database engine. "SQLite" OTOH is a database engine that uses SQL as the
query language -- but practically any relational model database engine uses
SQL as the query language.

 If, OTOH, all you have access to is a web server interface, you will be
limited to submitting form data and receiving/parsing returned web pages.



--
 Wulfraed                 Dennis Lee Bieber         AF6VN
 wlfraed@ix.netcom.com    http://wlfraed.microdiversity.freeddns.org/

--- SoupGate-Win32 v1.05