Hi, I am looking a solution for this but I don't find it in the forums.
I built an b4a app which at start download a SQLite db from http to use locally and refresh data by this way.
For reading data locally works fine, but if I wish add a record from app and update the source db from http, how can I do that?
Keep in mind several users could update data at same time.
Yes, of course. But the MySql from my hosting is restricted to local use, is not for external use for security reasons.
I am looking a solution with SQLite because of that.
Actually I upload the sqlite db from my pc to http, and the b4a app download it at start.
If I want to add or update any data in db, I must do it in pc with sqlite tool and upload again to http, to let the apps connected can download it again.
Sorry, I'm just trying to run your directions with your library. At this moment I am not able to initialize the datastore.
Stop my work? I find it very useful and interesting if it really works...
Mi db it's very tiny. What are the records limit that you say?
I found this information in Dropbox about limits:
Maximum record size100 KiB
Maximum number of records per datastore100,000
Maximum datastore size10 MiB
Maximum size of a single sync() call2 MiB
Actually my sqlite db has a size of 8Kb, I think 10Mb limit could be enough for me.
Did you recomend me I go on with your Dropbox library?
I have not choice to use another kind of database server like mysql or sql server...