I need a way to wrap my application with a self contained database, is this possible?

[Dave Troxel]

I am aiming toward posting my app on the Play Store. However, I want to have the app and database all wrapped together so the info can be kept on the mobile device. I would also like to offer the ability to backup the app/db in its entirety to the owners Google Driver or other available cloud storage locations. What steps do I need to take to make that happen? Please advise.

[Evgene Karachevtsev]

Hello Dave,

You can use local SQLite DB for your purpose: http://docs.appery.io/tutorials/build...

[Dave Troxel]

Ok, I followed the tutorial. I converted all the wedding items, db title, etc... with my own in the javascripts. Now what? Do I have to create a button for them to trigger from? Can it attach to a local SQLite db on app load? How do I know this took place within the mobile device? Many unanswered questions.

[Dave Troxel]

Anyone... Ok, I followed the tutorial. I converted all the wedding items, db title, etc... with my own in the javascripts. Now what? Do I have to create a button for them to trigger from? Can it attach to a local SQLite db on app load? How do I know this took place within the mobile device? Many unanswered questions.

[Dave Troxel]

Developers Console throwing the following errors:
18:00:35.592 "Default implementation is used. Please define your own." getTableListJS.js:13
18:00:35.604 "TypeError window.openDatabase is not a function" jquery-1.9.1.js:1

[Bob Fludder]

SQLite can be "fun". Looks like you've missed a bit from the tutorial. When you create a generic service you get an option for the default implementation. If you do not change this you will get the "Default Implementation" message. You'll need to change it to match the tutorial (all the sql bits etc). Its a sort of rest service so when you invoke the service it runs. Could be page load, button whatever. I have the openDatabase running on app load and allocated to a "global" variable that I then refer to throughout my app. Looks like you have an issue with your openDatabase as well. Double check all the spelling etc. Typos are a nightmare - took me ages once to spot I'd used curly braces {} instead of square brackets [].

[Dave Troxel]

Thank you Bob. I will definitely check those items. Once I have verified default implementation is enabled.. can I 'Test' the app online and use the Dev Console on my browser to verify it is creating 'or trying to create' the SQLite DB? Or do I have to install it to a mobile device to verify that? Thanks again.

[Evgene Karachevtsev]

Hello,

You can test work your application with local database using the Dev Console on your browser

[Bob Fludder]

Yes. Evgene is basically correct. I have found chrome to be the best by far. Use f12 for the dev tools. You can see errors and view the database. You can also run the sql to double check. Also found using console.log a help