Page 1 of 1
I need a way to wrap my application with a self contained database, is this possible?
Posted: Tue May 13, 2014 5:05 pm
by 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.
I need a way to wrap my application with a self contained database, is this possible?
Posted: Tue May 13, 2014 5:32 pm
by Evgene Karachevtsev
Hello Dave,
You can use local SQLite DB for your purpose: http://docs.appery.io/tutorials/build...
I need a way to wrap my application with a self contained database, is this possible?
Posted: Tue May 13, 2014 8:20 pm
by 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.
I need a way to wrap my application with a self contained database, is this possible?
Posted: Tue May 13, 2014 8:21 pm
by 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.
I need a way to wrap my application with a self contained database, is this possible?
Posted: Wed May 14, 2014 1:03 am
by 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
I need a way to wrap my application with a self contained database, is this possible?
Posted: Wed May 14, 2014 4:27 am
by 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 [].
I need a way to wrap my application with a self contained database, is this possible?
Posted: Wed May 14, 2014 1:01 pm
by 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.
I need a way to wrap my application with a self contained database, is this possible?
Posted: Wed May 14, 2014 8:19 pm
by Evgene Karachevtsev
Hello,
You can test work your application with local database using the Dev Console on your browser
I need a way to wrap my application with a self contained database, is this possible?
Posted: Wed May 14, 2014 9:42 pm
by 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