Error when exporting saved photos in SQLite to Mysql remote server

Thanks for advice. In my case, only 2 pictures for record are stored. It is like "PICTURE BEFORE and PICTURE AFTER".

I agree with you, but the error put me on that new way...

Yes, but how many records ?

Not more than one. The project consists in the user take a picture from a place before the job he is gonna do and after the job done, take another picture after the job. And after got this 2 images, send them to the server and delete from SQLite.

1 Like

Fun as it is, you do not need sqlite for this, or tinydb for that matter, just cut out those steps and use variables...or re-reading, you may actually need tinydb given the time between the pictures taken etc

It could be, but (there is always a BUT), the user can take pictures in places which does not have internet, but he has to save until he arrives in a WIFI place or something similar, to send all data to the remote server. That's why I choose SQLite for this.

1 Like

tinydb is a local database on the device.

1 Like

SQLite and MySQL are relational databases and use the SQL language. And we use a lot of SQL in WEB development. Right Kleyber ?

Yes. That's right

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.