Stack Overflow
Stack Overflow

Questions tagged [web-sql]

Web SQL Database is a SQL-based API allowing a web pages to store and retrieve structured data locally. It is based on, but not the same as SQLite.

Web SQL Database is a SQL-based API allowing web browsers/extensions/apps to store structured data locally. It is based on SQLite and, in practice, has been implemented solely on SQLite.

The API is currently supported by Google Chrome, Opera and Safari. But, The W3C has abandoned Web SQL in favor of Web Storage and the Indexed Database API. From the Web SQL spec:

... specification work has stopped. The specification reached an impasse: all interested implementors have used the same SQL backend (SQLite), but we need multiple independent implementations to proceed along a standardisation path.

Mozilla will not implement Web SQL DB, opting to implement IndexedDB instead, and Microsoft has hinted that they are more likely to implement IndexedDB than Web SQL.

Resources

855 questions
3
votes
1 answer

Saving image data to client storage: canvas vs xhr, blob vs arraybuffer

I am trying to get our web app to cache and display images for offline mode, while the storage part is done (default to IndexedDB and fallback to WebSQL for certain device), I am unsure if: Canvas or XHR is the better option to get image data. Blob…
bitinn
  • 9,188
  • 10
  • 38
  • 64
3
votes
0 answers

Cordova/PhoneGap websql vs native sqlite plugin

Using Apache Cordova / Adobe PhoneGap to develop an app usually also means using a DB. Cordova offers out of the box WebSQL thanks to the embedded webview. Another option would be to use a native Cordova-SQLitePlugin. Can someone provide pros/cons…
Simone Avogadro
  • 789
  • 8
  • 23
3
votes
1 answer

What is Web SQL Database int max value?

In Web SQL Database, what is a int max value? (exactly in Safari on iOS 7) I didn't find anything in docs: http://www.w3.org/TR/webdatabase/
Radek Wilczak
  • 299
  • 5
  • 14
3
votes
1 answer

Why won't my extension for Google Chrome work on this one specific page?

I have been working on an extension for Google Chrome for some time now that allows users to share pages to Facebook using a simple browser action icon. It provides some additional functionality, such as allowing users to search through past links,…
Jordan M.
  • 310
  • 2
  • 13
3
votes
2 answers

Incrementing value in table with unique key causes constraint error

I have a table created with CREATE TABLE `tests` (`num` INTEGER UNIQUE, value VARCHAR(255)) and I add two rows to it with: INSERT INTO `tests` VALUES(0, "a") INSERT INTO `tests` VALUES(1, "b") My goal is now to insert a row with num = 0, but to be…
Eli White
  • 1,014
  • 1
  • 10
  • 20
3
votes
0 answers

Sencha Touch SQL proxy

I am using SQL proxy in my Sencha Touch 2 app and I am able to store and retrieve data offline. What I cannot do and what the Sencha documentation does not seem to provide is how do I customize the Sencha SQL store. For eg, to create a SQL based…
senchaDev
  • 587
  • 2
  • 6
  • 19
3
votes
2 answers

Javascript ORM Library

I am currently working on an application that stores all the data locally on the device, and updates it whenever there is a change. Therefore, I am looking for a way to store, read and update objects with relations between them inside client-side…
Aviran Cohen
  • 5,581
  • 4
  • 48
  • 75
3
votes
2 answers

Why is Cordova using Web SQL API which has been deprecated?

If you check here: http://cordova.apache.org/docs/en/3.3.0/cordova_storage_storage.md.html#Storage , the page clearly shows the Web SQL Database API is being used. This Web SQL Database API is no longer being maintained as mentioned here:…
Ravindranath Akila
  • 209
  • 3
  • 35
  • 45
3
votes
1 answer

downloading database to localfilesystem and using opendatabase results in no such table error message

I'm trying to open a database i downloaded using an xhrrequest and stored using the file system API with my google chrome browser (Version 30.0.1599.101 m) on windows 8 OS and hosted in IIS8. I can find and open the file in my user folder, on the…
programmingheadaches
  • 143
  • 1
  • 10
3
votes
1 answer

Web SQL insert data into multiple rows

I've tried to insert variables into multiple rows at once in Web SQL database but with all known to me methods I'm getting errors: ("INSERT INTO tab (a,b) VALUES (?,?),(?,?)",[v1,v2,v3,v4]) >> could not prepare statement (1 near ",": syntax…
Lapsio
  • 6,384
  • 4
  • 20
  • 26
3
votes
2 answers

No prompt to increase Web SQL limit in Android native browser?

I need to save 11 MB of data offline using Web SQL. In iOS I am asked if I want to increase the quota, and everything is fine. But in Android's native browser (2.3-4.2) no such prompt is presented - it simply fails with QUOTA_ERR*. I have spent many…
dalgard
  • 3,614
  • 2
  • 22
  • 28
3
votes
2 answers

Storage limitations for WebSQL on iOS (with PhoneGap)

I am currently using Local Storage on both Android and iOS, but reaching capacity limits. So I thought to switch to WebSQL, which is of course deprecated but still working on both platforms. The question is: is there any limitation regarding the…
asp_net
  • 3,567
  • 3
  • 31
  • 58
3
votes
0 answers

Strange "SELECT" in WebSQL or not?

I'm trying to use WebSQL using html5rocks example. All goes well until I try to do "SELECT * FROM todo" then there is something not clear to me. Callback returns SQLResultSet without SQLResultSetRowList. Code below I tried in Chrome, Background…
FFFFFF
  • 99
  • 7
3
votes
2 answers

websql insert slow

I have about 300 records I need to insert into a websql. I started out by writing 300 separate tx.executeSql insert statements without parameters. tx.executeSql("INSERT INTO `beerlist` VALUES ('1', '21st Amendment', 'Back in Black IPA', '83',…
Tim Boland
  • 10,127
  • 8
  • 27
  • 25
3
votes
3 answers

HTML5 Web SQL Database Concerns

My company is currently transitioning to a new architecture, as well as a model that provides services to mobile devices. Our application was traditionally web based (HTML5/CSS3/JS/PHP/MYSQL), so we want to be able to port it to mobile platforms…
Andrew Rhyne
  • 5,060
  • 4
  • 28
  • 41
1 2 3
…
56 57