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

How to know if browser supports webSQL?

I want to detect if browser supports webSQL, in the same way we can check for indexedDB like below if ( window.indexedDB ) { // indexedDB support is available }
New Coder
  • 117
  • 2
  • 12
3
votes
1 answer

Cordova - Android - Why is the WebSQL and Local Storage data being deleted by the Android OS?

I have an app called Fudget (which is a Cordova app for Android & iOS) which uses WebSQL to store the user's app data locally. This has worked ok for years (I occasionally had an Android user whose data would be wiped by the Android OS - but not…
Danny Connell
  • 782
  • 1
  • 8
  • 18
3
votes
1 answer

What should the return value of the websql sqlstatementerrorcallback be?

https://www.w3.org/TR/webdatabase/#sqlstatementerrorcallback See here that the sql statement error callback defines return type boolean : [Callback=FunctionOnly, NoInterfaceObject] interface SQLStatementErrorCallback { boolean handleEvent(in…
Boyen
  • 1,429
  • 2
  • 15
  • 22
3
votes
1 answer

Chrome Version 75.0.3770.80 (Official Build) (64-bit) - unable to begin transaction (3850 disk I/O error)

In windows 7 chrome latestVersion 75.0.3770.80 (Official Build) (64-bit) got an error while get data and write data to chrome browser db in web sql. "unable to begin transaction (3850 disk I/O error)". Do you know any solution to this issue?
temUser
  • 142
  • 8
3
votes
1 answer

What storage option is best for phonegap in 2019?

I am new to phonegap. I am coming from android because I want to build a cross plateform app which i want to run on both apple and android devices and i am more skilled in using Web technologies such as JavaScript. now i am half way through and fund…
judy
  • 325
  • 3
  • 15
3
votes
1 answer

JavaScript login function not working using WebSQL

I am attempting to do a login function using WebSQL and JavaScript. I have written a function the takes one argument(email). The function is supposed to search the database for an existing email then it should return an alert stating whether the…
Thandok Luthuli
  • 33
  • 6
3
votes
0 answers

pouchDB database locking up - unable to begin transaction

I have the following service that starts a pouchDB database. .service("$pouchDB", ["$rootScope", "$q", "$cordovaNetwork", function($rootScope, $q, $cordovaNetwork) { var self = this; self.db = new PouchDB(localStorage['uid'], {auto_compaction:…
bryan
  • 8,879
  • 18
  • 83
  • 166
3
votes
2 answers

Ionic 2 - Get token from Storage value and set Header before HTTP Request

I am using the ionic/storage package to store the api_token for users after they logged in so I can use the unique token to interact with an API. The problem I am facing is that I need to get the value via storage.get which returns a promise and…
Chris Mayer
  • 187
  • 3
  • 10
3
votes
1 answer

Cordova app using WebSQL hit quota limit and cannot recover

I have hit a quota roadblock on iOS using standard Cordova WebSQL (with MS OpenTech polyfill plugin but I don't think it actually uses that on iOS). An error is thrown from WebSQL indicating quota exceeded. When this happens I catch the error and…
mike nelson
  • 21,218
  • 14
  • 66
  • 75
3
votes
0 answers

Import web sql contents into SQL Server database

I'm creating an app for mobile and web and I'm using Visual Studio and SQL Server. I'm creating a mobile app that will create a web sql database but the web app is using SQL Server. Can I use SQL Server for the mobile app or is there a solution that…
Dimitri Gharam
  • 31
  • 1
3
votes
0 answers

WebSQL database is locked

A web app (HTML5 app, used on iOS (Safari or WebView)) using WebSQL sometimes does not work as expected. In short the working of the app: a user needs to register on a car before he sees a list of trips he can open. Because the app also needs to…
Martine
  • 41
  • 5
3
votes
0 answers

chrome websql database has been closed

I'm pretty new to using Karma and Jasmine and I'm trying to test an ionic/cordova based app which runs on iOS. The app is heavily using local sqlite database using cordova-sqlite-storage plugin. And the application also has a code to use websql if…
Byungchul Lee
  • 31
  • 2
3
votes
1 answer

Where is WebSQL database folder in Web Inspector when debugging iOS app

I have an app using WebSQL database. I can debug database when running app on my computer in Chrome. But when I try to debug it on my iPod (hooked up to my computer, using Safari's Web Inspector) there is no WebSQL folder under Resources. There are…
drinovc
  • 521
  • 5
  • 16
3
votes
1 answer

WebSQL error `SQL execution is disallowed` when chaining promises

I know the title is a mouthful but I honestly couldn't come up with a better one for my specific case (open to suggestions). So basically I jotted down on this JSFiddle (a simplified version of) the issue I am facing. I am using AngularJS's $q.all…
Andrea Aloi
  • 971
  • 1
  • 17
  • 37
3
votes
1 answer

WebSQL doesn't work inside Web Worker in Chrome 39

I have a web site built using WebSQL for offline storage. I use a Web Worker to run some database queries in the background. In latest version of Chrome 39.0.2171.95 it is not working anymore, it seems like the WebSQL APIs are not loaded. The error…
SzilardD
  • 1,611
  • 2
  • 22
  • 40
1 2 3
…
56 57