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
0 answers

Synchronisation of Web SQL Database and Server Database

We are building web system that consist on AngularJS as client side and MVC 4 Web Api as server side. One of the main requirements is that at AngularJS client, once the user session is authenticated, user should be able to use application in offline…
Ivan Alek
  • 1,899
  • 3
  • 19
  • 38
2
votes
1 answer

Check if exist database in Cordova/Phonegap

I'm developing a Cordova/Phonegap application, Basicaly I want to know: how I can check if database exist? Before accessing it, to show a message and avoid an SQL error. Thank you!
candlejack
  • 1,189
  • 2
  • 22
  • 51
2
votes
2 answers

Insert or Update data into tables in SQlite

Am working in HTML5 + PhoneGap Applications with SQlite For updating the table in SQlite ; am using REPLACE INTO method. Here is example code ; : http://www.sqlfiddle.com/#!7/ccc33/2 Schema CREATE TABLE mytable ( id integer primary key…
ULLAS MOHAN.V
  • 1,521
  • 1
  • 19
  • 36
2
votes
0 answers

Cordova 3 how to backup the web sql file

what is actually the best solution or best practice to backup a web Sql file of a iOS / Android based App? I have developed a routine to export the whole content of the sqlite tables in a collection of queries to re-populate and overwrite the…
sasha
  • 365
  • 1
  • 15
2
votes
2 answers

IndexedDB Ordering

I'm an SQL person but I've now started programming offline apps in Dart and using IndexedDB seems to be the recommended method of storing local data. I'm using LawnDart to work with these IndexedDB databases and generating my own unique key (just a…
trvo
  • 665
  • 1
  • 10
  • 23
2
votes
1 answer

Function not returning value synchronously

I have the following condition where syncAnalytics is called first. Inside this function, there is another function, retreiveAnalyticsData, written to retrieve the locally stored data. But before the value is returned from retreiveAnalyticsData,…
Roy M J
  • 6,926
  • 7
  • 51
  • 78
2
votes
2 answers

WebSQL and jQuery - DB vanishes on refresh

I have a very simple app (the beginnings of a larger app) which does one thing at this point. All it does is create a new database and table and inserts a single row of data. The problem is, when I hit "refresh" on the browser, the data and table is…
Garfonzo
  • 3,876
  • 6
  • 43
  • 78
2
votes
2 answers

PhoneGap Local Storage WebSQL, IndexedDB, html5sql, lawnchair

I am trying to figure out the best way to store data in my cross platform app I am developing using PhoneGap.The API instructions suggest using WebSQL however this will no longer be supported, and IndexedDB is currently only for Windows /…
Environment
  • 59
  • 8
2
votes
1 answer

WebSQL in Chrome 32

I have a Chrome extension I wrote to log the searches I do in various search engines. Up until a few days ago, it worked fine. And then it stopped. Poking around in the code, as far as I can determine, the WebSQL stopped working. The commands…
dscrank
  • 31
  • 3
2
votes
3 answers

WEB SQL SELECT TOP 1 error

I keep getting an error when I try to add in a TOP 1 to my select statement. The SQL runs fine without the TOP 1 so it got me thinking that TOP is not supported in WEB SQL but I can't find any documentation online. Has anyone successfully used TOP…
StevenGardner
  • 21
  • 3
2
votes
2 answers

How can I create a JavaScript function from SQL where clause to pass it into filter function of JavaScript arrays as a predicate?

Scenario: I've a JavaScript based application which uses web sql database to store its data I've developed a custom entity set. It has a filter method which accepts string that contains sql query. for example: People.filter("Name = 'Test' and…
Yaser Moradi
  • 3,267
  • 3
  • 24
  • 50
2
votes
3 answers

Are SQL Statements Executed in Sequential Order via PhoneGap's Web SQL Database?

The PhoneGap Web SQL Database documentation at http://docs.phonegap.com/en/3.1.0/cordova_storage_storage.md.html#SQLTransaction lists the following JavaScript code fragment: function populateDB(tx) { tx.executeSql('DROP TABLE IF EXISTS DEMO'); …
Mitch
  • 21
  • 1
2
votes
2 answers

Web SQL Grow Database for iOS

I need to create an HTML5 Web SQL database (I realize that it's deprecated) for use on the iPad. It used to be with iOS 6 that you could create a 50 MB database right off the bat. But now iOS 7 has introduced a bug (see this article) that prevents…
Andy
  • 2,709
  • 5
  • 37
  • 64
2
votes
2 answers

localStorage no longer working in iOS 7 WebView

I am developing an HTML5 web app that is run from a WebView inside an iOS app. Once the users upgrade to iOS7, localStorage stops working and the app (which uses jQuery/jQuery Mobile) just shows the spinner. I've run some tests using Modernizr and…
pilar1347
  • 188
  • 1
  • 6
2
votes
0 answers

Phonegap with WebSql tranasction callback doesn't fired (sometimes)

I'm developing Phonegap application, and in the deviceready i'm initializing a web sql database. It works fine in general, but sometimes, the callback of the "_db.transaction" function doesn't get fired (neither the error nor the success…
Liran Brimer
  • 3,418
  • 1
  • 28
  • 23
1 2 3
…
56 57