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
2
votes
1 answer

Could not find SDK "SQLite.WinRT" - Add Reference shows "Missing value for TargetPlatformWinMDLocation property"

I'm trying to create a Multi-device hybrid app that uses Typescript, WinJS, and a persistent local database. I've got it working to the point of rendering WinJS controls. However, when I attempt to add WebSQL functionality according to the…
Lee McPherson
  • 931
  • 6
  • 20
2
votes
1 answer

Return multiple rows as an array from a WebSQL databse using javaScript

I want to return multiple rows as an array from a particular table in a database in WebSQL inside a javaScript function. Below is my code. function getCustomerAccountDetails(){ var dataset; db.transaction(function(tx) { …
vidulaJ
  • 1,232
  • 1
  • 16
  • 31
2
votes
2 answers

Return a COUNT from a WebSQL query in a javaScript function

I want to return the number of rows in a particular table in a database in WebSQL inside a javascript function. Below is my code. function getCustomerCount(){ var count = 0; db.transaction(function(tx) { tx.executeSql('SELECT *…
vidulaJ
  • 1,232
  • 1
  • 16
  • 31
2
votes
2 answers

Updating a row of data in WebSQL

WebSQL has been deprecated but it is still useful for some applications at this time. This is my table, I am using KnockoutJS:
Ausername
  • 31
  • 1
  • 1
  • 5
2
votes
1 answer

Synchronous WebSQL Transaction with another transaction inside

I know that I cannot retrieve the value of transaction Synchronously. I Read that an alternative is to Callback the function. But I can't manage to do it.. here's a snippet where I inserted the second transaction inside a function. for(...){ …
Gabriele Prestifilippo
  • 180
  • 2
  • 13
2
votes
0 answers

createObjectURL returns null

I use the following code to create URL's for blob's: var URL = window.URL || window.webkitURL; URL.createObjectURL(storedBlob); I ensured that URL method exists, as well as the blob which looks like this from the debugger: The code works fine on…
Ostkontentitan
  • 6,930
  • 5
  • 53
  • 71
2
votes
2 answers

Is there any polyfill for WebSQL using IndexedDB?

I wanted to use WebSQL in firefox and chrome packaged app. I know that IndexedDBShim is a polyfill for IndexedDB using WebSQL, conversely, is there any polyfill for WebSQL using IndexedDB?
Shellexy Wang
  • 21
  • 4
2
votes
1 answer

Adding values dynamically to the table in Web SQL database using javascript

I am fetching values from web service. And I have to insert those values into the table in Web SQL database. I have 4 records. I have inserted the following code into the loop, but only the last record is added in database and not the first 3…
Deepika
  • 331
  • 2
  • 7
  • 20
2
votes
1 answer

websql in android webview not created

I am using nparashuram's indexeddb polyfill for websql in an Android webview. when I first start my app, I create the database, 4 stores each with own indexes. I tested the polyfill in Chrome and Safari for iOS and everything works as expected, but…
bboydflo
  • 907
  • 1
  • 15
  • 24
2
votes
1 answer

Javascript Database Transaction Error could not prepare statement has no column

I'm currently having a problem where when I try to insert data I'm receiving an error that the table column does not exist but I have defined it. I've currently isolated the problem and decided to insert data manually. Once I get past my…
Richard
  • 826
  • 7
  • 23
  • 41
2
votes
1 answer

WebSQL Select with AND + OR

Is it possible to query a websql database using both AND and OR in the same statement? This will not work: tx.executeSql('SELECT * FROM people WHERE name="'+name1+'" OR name="'+name2+'" AND category=1', [], function (tx, results) { Both these…
mao
  • 1,059
  • 2
  • 23
  • 43
2
votes
1 answer

How to develop phonegap SQLite database

So PhoneGap's storage API supports webSQL which was deprecated in 2010. It's also totally broken in Chrome dev tools to test with. There is a native SQLite plugin that someone made https://github.com/brodysoft/Cordova-SQLitePlugin Which seems like a…
Sean Clark
  • 1,436
  • 1
  • 17
  • 31
2
votes
0 answers

Chrome developer tools WebSQL, can't see the data in massive SQL query

I have a set of massive SQL queries, they have so many columns that I cannot see any data returned from WebSQL in Chrome developer tools (screenshot below), one way to go about this would be obviously to break the queries apart into smaller ones…
Matas Vaitkevicius
  • 58,075
  • 31
  • 238
  • 265
2
votes
3 answers

WebSQL - Capacity

I have a PhoneGap app on iOS using a WebSQL database. In some places I'm reading that the storage capacity is 5MB and in others I'm reading it's 50MB, can someone clear this up for me? Also I'm planning on storing base64 images inside the…
Mohd
  • 313
  • 1
  • 4
  • 16
2
votes
1 answer

WebSQL - Storing and retrieving database from SD card - PhoneGap iOS

I'm making an iOS app using PhoneGap. Is there a way to store the webSQL database created by the app on the SD card, uninstall the app, install it again and then retrieve the database correctly with all the previous information that was there…
Mohd
  • 313
  • 1
  • 4
  • 16
1 2 3
…
56 57
Name Description Price