Need some help...

[David de Argentina]

Hi overthere,

I need create an app that handles a database within the phone.
I need a phisical database, for backup and some stadistic processes made with neobook or another engines Outside phone.

I need do some basical processes, like update, insert & select actions.
I just trying this javascript services:

https://github.com/kripken/sql.js

In fact, this services seems to do all the job, but i found the way to save phisically the database after changes.

Does any have some experience on similar programs with this or another javascript services ?

Thanks in advance,
David de Argentina

[luishp]

David, the library is only for not persistent databases:
"It uses a virtual database file stored in memory, and thus doesn't persist the changes made to the database."
Local persistent databases are quite unstable on HTML5.
Remote databases are more apropiated but they require PHP and MySQL on a remote webserver to save and retrieve the data.
Good luck.

[David de Argentina]

Thanks Luis,

I had suggested the same configuration to the end user.
He told me 2 conditions:
* No external files
* No wifi or internet

I think i have a problem...
All ideas are welcome

Thanks in advance,
David

[luishp]

Probably you should try this:

https://developer.mozilla.org/es/docs/I ... _IndexedDB
http://nparashuram.com/jquery-indexeddb/

Although IndexedDB is not supported on all browsers yet.
Another option is to use a Cordova plugin but I don't know how to use them with NeoAppBuilder:

https://www.sitepoint.com/storing-local ... rdova-app/

Please tell us if you achive some success on this.
Thanks!

[David de Argentina]

Thanks Luis,
I regret the delay in answering.

Finally, everything worked correctly, but with another type of development:
Instead of using HTML5, I used Java directly with this service:

App Inventor ( http://ai2.appinventor.mit.edu/ )

It is a Java visual interface extremely easy to use (NeoBook style).
The logic is somewhat different, but soon it is easy to work.

It allows us to do everything we are used to, plus the possibility of using all the sensors in the phone.

The result is very impressive: Java native APK's.

As all the interface works within a browser, I think maybe it would be a good idea (message to Dave ... ) see if we can put together another environment just for windows, which allows to improve the aesthetics of the apps.

I recommend taking a look at this development environment.

Greetings from Buenos Aires,
David de Argentina