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
8
votes
5 answers

Javascript API wrapper around web storage?

Is there a cross-browser jquery like wrapper API abstraction over the various web storage systems available?
pathikrit
  • 32,469
  • 37
  • 142
  • 221
7
votes
2 answers

HTML 5 Web SQL Database Transaction commit or rollback when refreshing page

As written in the Safari Client-Side Storage and Offline Applications Programming Guide, rolling back a HTML 5 Web SQL Database transaction is done by returning true in the callback function provided as an error callback to a transaction the…
SzilardD
  • 1,611
  • 2
  • 22
  • 40
7
votes
6 answers

How to make website available offline

I want to make my website available offline even if the user clears the cache and cookies. Is is possible? Also I am dealing with database. Is is possible to handle databases offline?
rdp
  • 2,072
  • 4
  • 31
  • 55
7
votes
2 answers

Web SQL Database + Javascript loop

I'm trying to figure this out but can't seem to on my own... I'm playing with Web SQL DBs and I can't get a loop to work properly with it. I use: for (var i=0; i<=numberofArticles-1; i++){ db.transaction(function (tx) { …
Henry
  • 1,025
  • 1
  • 10
  • 19
7
votes
0 answers

WebSQL has increasing browser support. What's its future?

I've done some looking around, and found that WebSQL seems to have a somewhat rocky future right now. On the one hand, it's apparently widely looked down on as a solution because of the fact that literally every actual implementation simply uses…
i336_
  • 1,813
  • 1
  • 20
  • 41
7
votes
1 answer

How to insert multiple rows in Web SQL Database?

I have a JavaScript object with multiple rows of data and I want to insert it into web sql database. Here is how my code looks like. for(i in rows) { (function(row){ db.transaction(function(tx) { tx.executeSql("INSERT INTO…
Naveed
  • 1,191
  • 10
  • 22
7
votes
3 answers

Does IE support indexedDB, WebSQL, or a database similar to SQLite?

For Chrome, I can use IndexedDB and WebSQL, for Firefox, I can use IndexedDB, what about IE? I have developed an app that uses WebSQL and it works fine on desktop Chrome and Safari, iOS Safari and Android browser. Next, I want to port it to…
netmobile
  • 81
  • 1
  • 1
  • 4
6
votes
1 answer

What local storage in html5 can I use safely in the browser ui thread and the web worker thread

I've been trying to use web sql database api in webkit based browsers. I have been using the async api in the main ui thread and a web worker. Both threads access the same database (which as you know is sqlite underthehood) Everything behaves fine…
paul
  • 494
  • 6
  • 17
6
votes
4 answers

Wrapping webSql executeSql calls in a jQuery Deferred / Promise

The html5 spec for executeSql includes a success callback and a fail callback: db.transaction(function(tx) { tx.executeSql('SELECT * FROM MyTable WHERE CategoryField = ?', [ selectedCategory ], function (tx, rs) {…
Phillip Senn
  • 46,771
  • 90
  • 257
  • 373
6
votes
2 answers

Is it safe to use HTML5 Web SQL Database API?

After reading http://www.w3.org/TR/webdatabase/ and more specifically: This document was on the W3C Recommendation track but specification work has stopped. The specification reached an impasse: all interested implementors have used the same…
jldupont
  • 93,734
  • 56
  • 203
  • 318
6
votes
2 answers

getting data from async function

i have this code: function getData(){ db.transaction(function(tx){ tx.executeSql('SELECT * from q', [], function(tx, result){ var q = []; for (var i=0; i < result.rows.length; i++) { …
nukl
  • 10,073
  • 15
  • 42
  • 58
6
votes
1 answer

Quasar Framework - What is the safest way to store local persistent data (for Web, Cordova & Electron platforms)?

What is the safest way to store data offline, assuming that I want to cover all platforms (Web, Electron & Cordova). The reason I ask is, my app Fudget (which is a Cordova / Electron - but not Quasar) uses WebSQL to store the user's app data…
Danny Connell
  • 782
  • 1
  • 8
  • 18
6
votes
1 answer

How can i view a columns entire content in Chrome Dev Tools -> Web SQL Database

Chrome Dev Tools support querying a web sql database but the result is shown in a table that cuts off strings that are too long with ellipsis (...) How can i view the entire columns content? Because of the cutoff a ctrl-a selection + copy does not…
AdrianLoer
  • 624
  • 3
  • 11
6
votes
0 answers

Websql cache size on iOS

We've developed an app for iPad (using Sencha Touch and Phonegap) that stores data locally using websql db. Thousands of records are inserted in db during synchronization, but sometimes the app crashes in the middle of the process due high memory…
user1524752
  • 61
  • 3
6
votes
1 answer

How to connect Dart to SQLite?

My old application used web2py with SQLite as the database. Now I want to try porting this app to Dart and again use SQLite as the database. I can't find any documentation on how to use it. I just found out how to use MySQL with sqljocky. I've…
AhmadDani
  • 251
  • 3
  • 13
1 2
3
…
56 57