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

Attach content of HTML5 WebSQL database to email using javascript

I have created local DB (WebSQL) in HTML5. The content of the local storage has to be sent as an attachment in an email. The email client will be opened using javascript mailto feature. The requirement is when the email client opens it should have…
user32262
  • 8,660
  • 21
  • 64
  • 77
3
votes
1 answer

Google Chrome freezes when inspecting WebSQL Database

I'm inserting a new row in a WebSQL Database, which works perfectly fine (the data is accessible later on and is correct), but when I try to inspect the WebSQL Table in Google Chrome's "Resources" tab, the whole Tool freezes. The odd thing is: I…
Ingo Bürk
  • 19,263
  • 6
  • 66
  • 100
3
votes
1 answer

Inserting Primary ID of one table into another table

I need some help on how to set up a database for user accounts on a mobile device. I have 2 tables: login and settings. login id 1 username test password pass settings id(same key from login) 1 setting1 0 setting2 …
Sephiroth
  • 189
  • 1
  • 3
  • 15
3
votes
1 answer

Phonegap. What happens to web SQL database on app update?

Please excuse the very novice question but I am about to embark on my first mobile app project using Phonegap. My project will rely heavily on a web SQL database. When I make updates to the app in the future, I need the database the user has built…
Fraser
  • 14,036
  • 22
  • 73
  • 118
3
votes
3 answers

Conversion from WebSQL to IndexedDB

I am currently working on a mobile application for time card submission that works with an already existing accounting application. Needless to say, this application relies heavily on relational databases and that particular reliance translates to…
Will
  • 733
  • 8
  • 23
2
votes
1 answer

Does WEBSQL support Phonegap Apps on Ice Cream Sandwich?

We're currently developing a iPhone/Android app with phonegap (and sencha touch), with a WEBSQL Database. Everything is working fine on the iOS and on all the Android versions, except for Ice Cream Sandwich. The problem until now has nothing to do…
hardcoder
  • 21
  • 2
2
votes
1 answer

Export WebSQL to CSV Locally

I would like to export a WebSQL database into a csv file locally on a mobile device using a webkit browser. Currently this code works inside google chrome and creates a file that automatically downloads: testCSV = function(){ var csvData = ""; …
Tim
  • 785
  • 1
  • 7
  • 20
2
votes
2 answers

What happened to HTML 5 web databases?

I checked out the site at http://www.w3.org/TR/webdatabase/ and I saw a huge banner there that said "Beware. This specification is no longer in active maintenance and the Web Applications Working Group does not intend to maintain it…
Ryan
  • 3,715
  • 2
  • 20
  • 17
2
votes
3 answers

Select Query - WebSQL

I've the following code to select a row.. When I call the function with getRecords("Peter Sam"); one record is shown.. However if I just pass getRecords("Peter"); it says "No results". getRecords = function(cname){ …
Naveen
  • 1,040
  • 4
  • 15
  • 38
2
votes
1 answer

Web SQL Storage in iphone

Can I use a Web SQL Storage in iPhone Currently my following code is resulting in error
Viren
  • 5,812
  • 6
  • 45
  • 98
2
votes
3 answers

How to get along with HTML5 offline apps when the WebSQL is deprecated?

Since the WebSQL has lost all the support and the development being stopped, how are people able to implement Offline Storage in web apps using HTML5. I know Google Chrome and Safari are still having it as a part of the browser but I guess soon it…
Shiv Kumar Ganesh
  • 3,799
  • 10
  • 46
  • 85
2
votes
1 answer

Public Database between chrome extensions

I want to created a public database so other extensions can access it, create tables, add entities, remove entities what they want. I saw that the only way to do this is to use message passing between multiple extensions, but this solutions is…
Yosi
  • 2,936
  • 7
  • 39
  • 64
2
votes
2 answers

web sql error "current version of the database and `oldVersion` argument do not match"

I am trying to run these set of functions: function erorr(e) { // error getting database alert(e.message); } window.onload = function() { prepareDatabase(erorr); }; function prepareDatabase(error) { return openDatabase('tasks13', '',…
M T
  • 4,099
  • 4
  • 21
  • 27
2
votes
1 answer

State of Web SQL - can I use it in a mobile project?

I am using Web SQL for my app that I intend to run on iOS and Android. It's coded in jQuery Mobile and will be translated to a native app using PhoneGap. Since I heard that Web SQL is kind of deprecated and will maybe no longer be supported, I am…
duality_
  • 17,738
  • 23
  • 77
  • 95
2
votes
1 answer

Is this really asynchronous or does it happen so fast it doesn't make a difference?

I'm trying to write a way to synchronously execute a set of sqlite queries within a WebDB environment. I've come up with what I think amounts to a synchronous routine, but I'm not sure how to test it. Here's what I have: var db =…
tmountjr
  • 1,423
  • 2
  • 22
  • 38
1 2 3
…
56 57