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

iOs 7 website as homescreen icon crashes on start

We have a html5 application. When its started on iOS 7 on iPhone 5, from the home screen (as a fullscreen application). The phone restarts. We're using webSql, and the appCache. The application never reaches a point where it does Ajax calls. Has…
Morten
  • 4,507
  • 7
  • 29
  • 31
2
votes
1 answer

Call function after websql transaction finishes?

How do I run a function when a specific web sql transaction has finished, so that the transaction commits before the function call?
Filip Haglund
  • 13,919
  • 13
  • 64
  • 113
2
votes
1 answer

Cordova 3.0.0 Storage API error

I'm developing crossplatform application, using cordova 3.0.0. The project is created using cordova-cli and built for android platform. It successfully using file and file-transfer plugins at the moment. The problem comes when attempting to use…
Andrew Shustariov
  • 2,530
  • 1
  • 17
  • 17
2
votes
2 answers

Why does Lawnchair's webkit-sqlite adapter converts key to string?

I got a problem on webkit-sqlite adapter. It somehow saves the key on a string format rather than integer. Indexed-db works just fine. It won't convert the key to string. Please see the code below. var ppl = Lawnchair({adapter: 'webkit-sqlite',…
paolooo
  • 4,133
  • 2
  • 18
  • 33
2
votes
1 answer

Does the storage limit (on IndexedDB or localStorage) apply for local apps running off the computer?

If I write a web app that will run in Chrome or Firefox and uses IndexedDB (or localStorage), but it's not hosted anywhere and instead is run by the user double-clicking a local ".html" file, will the limits on storage size still apply? I'm…
Don Rhummy
  • 24,730
  • 42
  • 175
  • 330
2
votes
2 answers

get existing tables from websql database

I was wondering if it is possible to get the existing tables from a websql database. Is there some sort of query to find these? I have already found several sqlite examples but these don't work in websql.
Jerodev
  • 32,252
  • 11
  • 87
  • 108
2
votes
2 answers

What is the preferred method of migrating from WebSQL to indexedDB?

I have a completed phonegap app that runs on Android currently, the DB is written using WebSQL. I've been tasked with porting the app to Windows Phone - the app falls apart due to not supporting WebSQL. Is there a quick conversion/shim script…
Richard
  • 1,148
  • 3
  • 18
  • 33
2
votes
0 answers

Web SQL - Insert if not exists or Unique column?

I try to execute insert or ignore into WDCategory(name,userID) values('Cate 1',1) which name is a unique column but not successful if there is a record with same name in the table. "Not Successful" means that the query fail instead of execute and…
Nguyen Minh Binh
  • 23,891
  • 30
  • 115
  • 165
2
votes
1 answer

Can executeSql take named parameters?

I see in examples when executeSql takes several parameters, we use question marks: db.transaction(function(tx){ var addedOn = new Date(); tx.executeSql("INSERT INTO todo(todo, added_on) VALUES (?,?)", [todoText, addedOn], …
Phillip Senn
  • 46,771
  • 90
  • 257
  • 373
2
votes
2 answers

How long does web SQL data persist?

I'm starting to work on an hybrid application which rely on web sql capabilities. The application works with a local database (web SQL) which may be synchronized to a distant database if the device is online. Off course, it is important for the…
Yako
  • 3,405
  • 9
  • 41
  • 71
2
votes
1 answer

Local storage and web SQL not working across multiple pages

To start of I have two pages (in the same folder, on the same domain), we'll call them dummy and dummy2. I have tried both html5 localstorage and now webSQL and am finding that I can save and read the data when on dummy (dummy is the page that has…
Aaron Fisher
  • 645
  • 3
  • 8
  • 23
2
votes
1 answer

How to store websql .executeSql results in a global variable?

How can access the results of a tx.executeSql('select query for a table',[],sucessCB); function sucessCB(tx, results){ //<--- this results param console.log(results.row.item(0).name); } I tried something like function(){ var tab = []; …
Sathya Raj
  • 1,079
  • 2
  • 12
  • 30
2
votes
2 answers

Sending Data From javaScript Which Is retrived from LocalStorage(WebSql) and pass to MVC Controller

db.transaction( function (transaction) { transaction.executeSql('INSERT INTO EmployeeTable(Firstname,Lastname,BirthDate,EmployeeType,MaritalStatus,Company,IsActive,Dependents) values(?,?,?,?,?,?,?,?)', …
Tushar Kshirsagar
  • 239
  • 2
  • 14
2
votes
1 answer

Web browser storage: Security implications of allowing user-supplied Strings to be evaluated?

I've almost finished developing a script that exposes an API that can be used to uniformly perform storage operations on any of the web browser storage technologies. The last bits of functionality that I'm working on are conditional retrieval and…
Kevin
  • 2,617
  • 29
  • 35
2
votes
1 answer

HTML5 Web SQL Dynamic Size

With the following segment: var db = openDatabase('mydb', '1.0', 'my first database', 2 * 1024 * 1024); I need to be able to have a dynamically sized database. Will the above database expand beyond the recommended size, or will it simply start…
Andrew Rhyne
  • 5,060
  • 4
  • 28
  • 41
1 2 3
…
56 57