Page 1 of 1

Need some help...

PostPosted: Mon May 29, 2017 10:01 am
by 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

Re: Need some help...

PostPosted: Mon May 29, 2017 11:47 am
by 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.

Re: Need some help...

PostPosted: Mon May 29, 2017 8:54 pm
by 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

Re: Need some help...

PostPosted: Tue May 30, 2017 12:02 am
by 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!