Kai Biefang
Posts: 0
Joined: Mon Mar 31, 2014 10:12 am

Offline DB and synching with online DB

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

Maryna Brodina
Posts: 0
Joined: Thu Apr 05, 2012 7:27 am

Offline DB and synching with online DB

Hello!

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

Nathan Morin
Posts: 0
Joined: Thu Sep 05, 2013 6:12 am

Offline DB and synching with online DB

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

Alena Prykhodko
Posts: 0
Joined: Tue Apr 09, 2013 7:36 am

Offline DB and synching with online DB

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....

Mark Lawther
Posts: 0
Joined: Mon Nov 02, 2015 5:19 pm

Offline DB and synching with online DB

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?

Illya Stepanov
Posts: 0
Joined: Mon Mar 18, 2013 8:48 am

Offline DB and synching with online DB

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

Mark Lawther
Posts: 0
Joined: Mon Nov 02, 2015 5:19 pm

Offline DB and synching with online DB

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

Alena Prykhodko
Posts: 0
Joined: Tue Apr 09, 2013 7:36 am

Offline DB and synching with online DB

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

Mohammad Sahil
Posts: 0
Joined: Tue Oct 24, 2017 6:48 am

Offline DB and synching with online DB

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

Illya Stepanov
Posts: 0
Joined: Mon Mar 18, 2013 8:48 am

Offline DB and synching with online DB

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...

Return to “Issues”