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

How to select record from list displayed on first page and show it at another page

This is third time and i want to make it clear for my problem. So in the first page i display my whole record that i saved in database, and when i want to view the selected details at second page, i need to click the selected data and view, but…
newbie
  • 41
  • 11
0
votes
1 answer

Websql table init error

I want to do some data initialize in web sql with phonegap. Below is part of my code, when init table it always goes to error callback. I didn't find the reason. You can directly test it in browser.
yuyue007
  • 1,219
  • 3
  • 14
  • 25
0
votes
1 answer

Issue with display the data with two different page in html

hey guys i have question of displaying data with html in different page, it mean when i get data from web sql in the first page, then i click the data i want to edit and it link me to another page, so how can i do that? i test before with but it…
newbie
  • 41
  • 11
0
votes
2 answers

Can HTML5 Web SQL databases be used across pages?

This is probably a very simple question so please forgive my ignorance, but can a Web SQL database be read across pages of the same domain? For example if I insert data on page mydomain.com/createdata can the same data be queried on…
MeltingDog
  • 14,310
  • 43
  • 165
  • 295
0
votes
1 answer

Deleting an entry and releasing from unique key index

For a project with offline storage, I created a database with a primary key for the id and also a unique field holding the date. When I delete an entry, I can not create a new one with the same date the deleted entry had. What can I do to get the…
hm.
  • 166
  • 9
0
votes
1 answer

I want some result that is inside of a callback function inside of another one

I'm beggining with javascript. I think this question only about javascript but it envolves PhoneGap and WebSQL. My problem and what I want to do are in the code comments. var MyDatabase = function() { if (!(this instanceof MyDatabase)) return…
Hugo Maia Vieira
  • 125
  • 1
  • 4
0
votes
2 answers

Does Android 4.0.3 Web browser support the Web SQL database

I have a web app that runs on earlier versions of Android but seems to have problems when run on Android 4.0.3 (HTC 1x) Namely the openDatabase javascript function is "undefined", is this api supported?
Terry Canning
  • 1
  • 1
0
votes
2 answers

Chromium Web Browser: "There has been an error: could not prepare statement (1 table items has no column named due_date)"

I use websql for offline storage. Following addItem function works for other browsers, except Chromium: itemset.webdb.createTable = function() { var db = itemset.webdb.db; db.transaction(function(tx) { tx.executeSql("CREATE TABLE…
Ali Ismayilov
  • 1,707
  • 3
  • 22
  • 37
0
votes
1 answer

Jquery.tmpl with WebSql Result set

I am using JQM and building a large lists of contacts from a webSQL database. Currently the process is painfully slow so I am trying to use a template to see how this affects performance. I cannot figure out how to use a Jquery template with a…
Jon Wells
  • 4,191
  • 9
  • 40
  • 69
0
votes
0 answers

WebDB: finding pre-existing database and/or pre-existing tables

I've started to explore using web databases (in this case the database in chrome) that you can run calls on using javascript. On document load, I begin by running the following function: dbUtils = { db : null, initDatabase : function(){ …
NathanC
  • 71
  • 3
0
votes
1 answer

indexedDB XML Schema?

I am writing a small and simple API to abstract away Web SQL, indexedDB, and maybe even localStorage/JSON. The API will allow the programmer to think of the database as a small relational database even if the database actually being used is…
anonymous
  • 1,259
  • 2
  • 10
  • 15
-1
votes
1 answer

WebDB - For each Column, in Each Row

in webDB, EG: HTML5 SQLLite How can I do the following: For i = 0 To RS.Fields.Count -1 Response.Write "Field Name: " & RS.Fields(i).Name & "
" Response.Write "Field Value: " & RS(i) & "
" Next If, at all... Or, another question…
Sage
  • 4,769
  • 1
  • 21
  • 28
-1
votes
1 answer

Is it possible to get a variable or localStorage value to insert in a Web SQL code?

I've created just a simple code to simulate a virtual store with HTML, Web SQL & Javascript language and my question is: Is it possible to get a variable or localStorage value to insert in a Web SQL code? I just need to change the code number…
Maurilio_Junior
  • 1
  • 1
-1
votes
2 answers

data store in client with angular

we have heavy forms view in an Angular application based on ERP, we need store data that we data entry in some forms. When the user refreshes the browser data must appeared in the forms and forms must be open. what is the best way for this cases? we…
Mostafa Saadatnia
  • 802
  • 8
  • 20
-1
votes
1 answer

websql query dont work

I am developing a program using HTML5 and chose websql as my data storage. The problem is the following. I need to select from the database tasks belonging only today. Data in the database are similar to the following TASK_ITEM START_DATE …
Amely
  • 43
  • 1
  • 7
1 2 3
…
56
57