As of 2010, WebSQL is deprecated. Can you merge html5sql into IndexedDB?

Obviously a tall order, but things like persistence.js and lawnchair don't have the awesome power of SQL behind them (persistencejs comes close, but loses the SQL syntax). However, only really lawnchair has support for a wide variety of storage solutions--see it's adapters. It would be great if html5sql allowed the creation of adapters to suit any client-side storage solution. Do you think this is possible?

Hi, I do not see a license choice for this repository.
I note that https://github.com/LaravelCollective/html/blob/5.3/LICENSE.txt ,are the MIT License.

While that is a good choice for some projects, a tutorial and book are critical internet infrastructure for Indonesian software engineering, and should be available in a commercial-friendly way. #11

After running cordova install per the instructions and trying make create I get the following errors:

write out the source for each native platform

careful, this is destructive!!!

./bin/util/validate-config

./bin/create/blackberry

./bin/create/android
uname: illegal option -- o
usage: uname [-amnprsv]
./bin/create/android: line 13: [: =: unary operator expected
uname: illegal option -- o
usage: uname [-amnprsv]
./bin/create/android: line 17: [: =: unary operator expected
./bin/create/android: line 28: android: command not found
./bin/create/android: line 31: android: command not found
./bin/create/android: line 45: ./tmp/android/src/com/phonegap/vanilla/PhoneGapVanilla.java: No such file or directory
find: ./tmp/android/src/com/phonegap/vanilla/PhoneGapVanilla.java: No such file or directory
find: ./tmp/android/src/com/phonegap/vanilla/PhoneGapVanilla.java: No such file or directory
Traceback (most recent call last):
File "./bin/create/android-convert-config", line 7, in
manifest_xml = parse(manifest_path)
File "/System/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/xml/dom/minidom.py", line 1918, in parse
return expatbuilder.parse(file)
File "/System/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/xml/dom/expatbuilder.py", line 922, in parse
fp = open(file, 'rb')
IOError: [Errno 2] No such file or directory: './tmp/android/AndroidManifest.xml'
make: *** [create] Error 1

Not sure how to troubleshoot this.

I made a lil tool & tutorial to help a friend learn SQL that uses html5sql.js, and thought you might like it. You can see the tool, here. It syntax-highlights & auto-completes SQL & table/columns.

Hi,

I just encountered the following problem. I am having a couple of INSERT statements inserting values that contain semicola like
INSERT INTO mytable (id, name) VALUES (0, 'foo;bar');
I have all those INSERT statements in a single string but then 'sqlObjectCreator', which is called by 'process', decides to split up the INSERT statement by the semicolon which yields an
"Error: unrecognized token"
Is there any way to prevent this? Currently I can only think of producing an array that holds a single statement for each index ...

Best wishes
Alexander Körschgen

Hi,

I know that transaction is a void function, but using html5sql is there a way I can return the data that is received from the DB?

I can't seem to find a way.

Hello,
In the documentation from the README you give an example (in General Guide for Using section) :

"CREATE table (id INTEGER PRIMARY KEY, data TEXT);"

Should be

"CREATE TABLE table (id INTEGER PRIMARY KEY, data TEXT);"

on opendatabase()
can you specified a path?? how?
thanks

Hi, cute piece of software!

The following code crashes:

var sql = 'insert into foo (bar) values ('baz " biz') ; insert into foo (bar) values ('barbaz');
html5sql.process(sql, function() {});

Trying to debug, I found that at line 99 of html5sql.js the input string is split in two, and the splice on line 102 is executed repeatedly, until i+1 goes outside the array and the program crashes.

I guess that the split at line 95 must be substituted by something more complex.

Thanks in advance for your attention.