JavaScript and local databases..

[Roberto Lopez]

Hi All,

HMGSCRIPT could be used to create fully local applications.

In such case you don't need any web server, you must open the main app html file and it will work.

But... what about a local databases?

You surely know that JavaScript is 'sandboxed', meaning that it can't access local file system, so... how to do it?

HTML5 introduced local storage facilities.

slq.js (Sqlite compiled to JavaScript) uses HTML5 local storage to allow you to work with SQL local databases.

So... a full JavaScript app with local databases...? YES!

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

[mol]

fine news!
thanks Roberto for sharing!
Regards, Marek.

[Rathinagiri]

Wow! That is very promising!

[serge_girard]

Thanks, Roberto !

Serge

[dhaine_adp]

Thanks Roberto this is another milestone that extends the power of HMG with its own Unicode (by Dr. Claudio) and ANSI build.

[apais]

Note: Local Storage is limited to 5MB.
Fine for phone apps but not so much for fully fledged commercial desktop apps.

HTH
Angel

[Roberto Lopez]

Note: Local Storage is limited to 5MB.
Fine for phone apps but not so much for fully fledged commercial desktop apps.

HTH
Angel

You have other alternatives, ie: http://en.wikipedia.org/wiki/Indexed_Database_API

[mruizcanete]

Another tool to handle sql but without the limitations of web sql storage or local storage. And it's fully documented in Spanish also.
javascriptsql.sourceforge.net/ARCH/index.html
I've tried the test and it's quite nice. Tried locally but I had to deal with the Chrome problem about file:// as starting address that I solved in windows after some googling.
Perhaps using different tools but in the same project it would be possible to build an application as it is expected: one-single page html with hmgscript, javascript.js, jquery mobile... with no servers at all, and in every compatible browser with html5.
Dreams becoming true?
Thanks to all for this big effort in these days. Merry Christmas to everybody and a happy new year from this humble Spaniard.

[Roberto Lopez]

Another tool to handle sql but without the limitations of web sql storage or local storage. And it's fully documented in Spanish also.
javascriptsql.sourceforge.net/ARCH/index.html
I've tried the test and it's quite nice. Tried locally but I had to deal with the Chrome problem about file:// as starting address that I solved in windows after some googling.
Perhaps using different tools but in the same project it would be possible to build an application as it is expected: one-single page html with hmgscript, javascript.js, jquery mobile... with no servers at all, and in every compatible browser with html5.
Dreams becoming true?
Thanks to all for this big effort in these days. Merry Christmas to everybody and a happy new year from this humble Spaniard.

Thanks!

It looks good.

I'll test it ASAP.

[juanato]

XPCOM Mozilla can assist Firefox to via storage class call from Javascript sqlite commands.

You can using GreaseMonkey or iMacros4Firefox run javascript code inside XPCOM architecture inside Mozilla Firefox.


https://www.google.es/search?q=xpcom+sq ... easemonkey