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

Jquery mobile theme on button in websql success call

I am new to jQuery mobile and HTML5. I have created a page which has simple CRUD operation on WebSQL SQLite storage. It works well. On the page I have buttons to insert and display information (using jQuery mobile)..on this button it displays jQuery…
Tina Rathod
  • 13
  • 5
0
votes
3 answers

HTML 5 web SQL chrome support , Should I use webSQL?

Here I have to make a server based application which will run on an closed network and specific to chrome. I have to decided now whether I should use WebSQL (Which will definitely saves us development time) or should we use IndexedDB (of which we do…
Sanuj
  • 1,077
  • 1
  • 11
  • 23
0
votes
2 answers

Can I keep websql database open to improve performance?

I have an HTML5 mobile app running on iOS and Android. Users will normally have a little bit of local data stored in a few tables. Let's say five tables with an average of three records. Performance of websql is really bad. I read in this post that…
Wytze
  • 7,844
  • 8
  • 49
  • 62
0
votes
1 answer

How do you delete a Web SQL database in Android's default browser?

This is a web sql browser. I guess they recently switched to chrome so in newer versions it might be an idb thing but this problem is with web sql. Settings > Privacy and security > Clear cache (Clear locally cached content and databases) does not…
dolphone bubleine
  • 691
  • 1
  • 8
  • 18
0
votes
1 answer

Web SQL SECURITY_ERR: DOM exception 18 on Android only

This error does not happen anywhere else. I can even open a version database (and then another imaginary test database) with no problem. But as soon as I go to open the main database I get the error. The process I have been using is to get the…
dolphone bubleine
  • 691
  • 1
  • 8
  • 18
0
votes
2 answers

How to connect Delphi to remote MS Access Database through the internet?

Possible Duplicate: How to connect to an Access 2003 database located on a web server via HTTP? I have a working Delphi program that uses a MS Access Database to obtain reports etc. Now I want to migrate the database to a webserver running my…
ricky
  • 75
  • 1
  • 5
0
votes
1 answer

Accessing variable inside WebSQL Function

I am using the following code var Year12=new Array(); GetYear(function(Year12) { alert(Year12); }); function GetYear(callback) { var selectAllStatement = "SELECT DISTINCT year FROM mytable"; var db = openDatabase("Postit",…
my name is xyz
  • 329
  • 3
  • 7
  • 17
0
votes
1 answer

Tables are not getting created for websql in sencha touch app

I have created a sencha touch 2 application, in which I have used websql for offline data storing. There are around 13 tables I am creating using call back function. This works fine on desktop chrome browser. But when I use this application on…
mahesh
  • 135
  • 4
  • 14
0
votes
3 answers

Using where clause with javascript variable

Hello all this is my first question on stack overflow. I am developing an app with phonegap, with using webSQL and javascript. In my App there is a login form which takes two inputs as: username and password. when user fills these values and clicks…
Hemant Patel
  • 3
  • 1
  • 3
0
votes
1 answer

How do I return the number of rows of a table according to a search criteria in Web SQL?

I have created a database called todo with table name todo having fields like title,date etc. The table is empty right now. I have defined a function which takes title as parameter and check whether table contains that title or not. It should…
Pankaj Khurana
  • 3,243
  • 10
  • 50
  • 79
0
votes
1 answer

Dynamically Create SQLite In-Clause Parameters

I am trying to create a filter function for a web-based app that relies on SQLite for persistent storage. I am trying to use a prepared statement, but it has to be created dynamically based on the number of boxes checked by the user. I have an query…
salsbury
  • 2,777
  • 1
  • 19
  • 22
0
votes
0 answers

HTML5 WebSQL and AppCache on Blackberry Playbook

I have a web client that makes use of HTML5, webSQL and appcache. Apparently, it won't work on Blackberry Playbook. It works fine in an android device. I thought playbook supports webSQL, then why I'm not able to create a websql db? I've also…
lorraine batol
  • 6,001
  • 16
  • 55
  • 114
0
votes
1 answer

Read data from web sql into variables

I am using websql database to store my records successfully and while reading it back it returns undefined at first time on second time it returns actual value. myDB.transaction(function(transaction) { transaction.executeSql('SELECT * FROM…
Andy
  • 643
  • 5
  • 17
0
votes
1 answer

How to retrieve value from Web SQL Database by using function?

I have a textbox with button. how can i retrieve value from Web SQL database in JS file by using onclick function and display in textbox?
garo
  • 1
  • 1
0
votes
1 answer

websql phonegap app: database upgrade

I'm upgrading my android/phonegap app in the google market store. Due to an oversight on my part, I need to start again and will need to delete existing user data stored in websql and start again capturing it in the correct format. What's the best…
user1215923
  • 17
  • 4
1 2 3
…
56 57