Forum | Appery.io

Hello,

We are planning a new application and I want to ask if we can realize our plan with Apperyio.

The idea is the following:

On the start of the app we want to import datarows from a PROGRESS DB to the device. From now on no internet connection is available, because the app has to work in basements where no connection to the internet is given.

We then want to scan barcodes and modify the item related to the code on the device and the data has to be saved locally on the phone.

After all tasks are done the device gains internet connection again and then we want to copy the modified datarows to our PROGRESS DB, which is accessible in the internet.

The question is: How can we save the datarows on the phone when no internet connection is given? Is there something like a local DB? I dont think we can work with the local storage there, can we?

Thanks in advance, Kai

Hello!

You can use local DB as shown here http://docs.appery.io/tutorials/build...

Maryna-

Hi. How does one push the data from the local SQLite database to the database in the cloud? I have successfully created and populated a local SQLite database and now I need to populate the database in the cloud with the same entires. Thanks for your help.

Cheers,

Nathan

Hello Nathan,

1 Retrieve records one by one from SQLLite database http://devcenter.appery.io/documentat... .
2 Send every record via create service http://devcenter.appery.io/documentat....

You can not do it with one Service unless you use custom server code script http://devcenter.appery.io/documentat....

The link to the local DB tutorial above is broken. Is the tutorial still available somewhere else?

I have also seen comments/suggestions that IndexedDB is supported. Is there an IndexedDB tutorial?

Hi Mark - This tutorial is deprecated, but you can use any that is available online e.g.: https://developer.mozilla.org/en-US/d...

Illya,

I've been working with the IndexedDB doc you linked to, as well as the Appery doc for Generic Services, but I don't have the understanding to integrate the IndexedDB code into an Appery Generic Service.

Would it be possible for someone at Appery to recreate the deprecated demo using IndexedDB and a Generic Service? A working example would be a huge help!

Thanks,
Mark

Unfortunately, we do not have enough resources for this right now.

these links are going to docs, not able to find sqllite content

Please read below my replies about this. We also have introduced our built-in Offline support for API Express services, read more about it here:

https://docs.appery.io/docs/building-...
https://docs.appery.io/docs/apiexpres...