Android Question Providing SQLLite data backup facility to end-user

[beelze69]

Hi,

I have a b4A App which stores data into/accesses data from a Sqllite database.

I would like to provide backup services to the end-user with a choice for the user to

1) Save the data to

1.1)either some 'designated storage area' in the mobile device [for example, user will fix the location for the 1st time and every time the data will be backed up to that location either 'at designated times'/upon click of a button..This storage location can be in an SD Card etc.]

1.2)a designated path in 'Google Drive' of the end-user on open internet [System should automatically perform the 'Google authentication etc.' required for accessing the particular path and save the data to the specific location in 'Google Drive' at 'designated times'/upon the click of a button]

2) Ability to import the data from the locations in 1.1 and 1.2 mentioned above (in case the database gets corrupted in the mobile device)[System should detect that it is unable to open the database because it is corrupted and then offer the end-user a choice for carrying out 1.1 and 1.2 ]..

Requesting for guidance on how to do this.

Thanks

 

[Andrew (Digitwell)]

Use Erel's Save As code, this also supports Google Drive.

SaveAs - Let the user select a target folder + list of other related methods

B4A + B4i example: https://www.b4x.com/android/forum/threads/b4x-texteditor-save-and-load-external-files.132731/#post-838166 List of classes or libraries that can be used to access secondary storages: ContentChooser (Phone libray) - allows the user to select a resource or file using external...

www.b4x.com

Android Google Drive folders

anyway to check if google drive is installed and check it's folder to save/read files for it the idea to make backup for clients data (database/images/......) to google drive in easy and fast way without API

www.b4x.com

 

[Erel]

Make sure to set the db journal mode to DELETE: https://www.b4x.com/android/forum/threads/b4x-sql-setting-the-journal-mode.136211/#content

 

[beelze69]

Use Erel's Save As code, this also supports Google Drive.

SaveAs - Let the user select a target folder + list of other related methods

B4A + B4i example: https://www.b4x.com/android/forum/threads/b4x-texteditor-save-and-load-external-files.132731/#post-838166 List of classes or libraries that can be used to access secondary storages: ContentChooser (Phone libray) - allows the user to select a resource or file using external...

www.b4x.com

Android Google Drive folders

anyway to check if google drive is installed and check it's folder to save/read files for it the idea to make backup for clients data (database/images/......) to google drive in easy and fast way without API

www.b4x.com

Hi Andrew,

Thanks ! I will try this out...

 

[beelze69]

Make sure to set the db journal mode to DELETE: https://www.b4x.com/android/forum/threads/b4x-sql-setting-the-journal-mode.136211/#content

Hi Erel,
Thanks ! I will try this out...