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

Where is the location of W3C Web SQL Database in android

From PhoneGap site, I know that it supports using Web SQL. Here, I have few things that are not clear: If I restart the apps, will the database disappear? If no, where is it? Can I go to File Explorer to see and what is the format of it? sqlite? …
red23jordan
  • 2,841
  • 10
  • 41
  • 57
2
votes
3 answers

which versions of chrome/opera/firefox support IndexedDb?

As I see in comments of this page , I could not understand that if chrome supports IndexedDB really. I'm going to write an userscript for chrome/opera/firefox, and decided to not use localstorage, I just wanna try IndexedDB instead of localstorage,…
Okan Kocyigit
  • 13,203
  • 18
  • 70
  • 129
2
votes
3 answers

My global variable comes up as undefined in transcationSuccess callback - can't figure out why

Im working with Sencha touch and I am trying to update a panel after I get the data from my webdb... wouldnt think this would be hard but I am totally missing something here... var returnHTML = getPresentations(); function getPresentations()…
Todd Vance
  • 4,627
  • 7
  • 46
  • 66
2
votes
2 answers

how to manipulate Phonegap Web SQL Database

I'm developing an app with PhoneGap and I found a problem. I don't know and can't find the database file so I can manipulate it or check if it has the records and tables that I want. Is there any app that can do that? I found that Safari and Chrome…
Elkas
  • 603
  • 12
  • 27
2
votes
2 answers

My websql transaction won't execute

I have a mobile app in HTML5 that is using the websql database. I have a data.js file with a bunch of functions for doing various CRUD jobs with the database. I've never had this problem until I got to wiring this function. Basically the app is for…
iamjonesy
  • 24,732
  • 40
  • 139
  • 206
2
votes
3 answers

web sql database foreign key support

I'm testing this statement in Safari 5.0.5, but I get an error before FOREIGN: CREATE TABLE IF NOT EXISTS Idea ( id INTEGER PRIMARY KEY, title TEXT NOT NULL, content TEXT NOT NULL, created TIMESTAMP NOT NULL, sketchID INTEGER, …
VansFannel
  • 45,055
  • 107
  • 359
  • 626
2
votes
2 answers

WebSQL alternative for mobile web apps?

Let me clarify, when I say mobile web apps I mean web apps that are designed to run across different mobile platforms, not native mobile apps that access the internet for data. So I was doing some reading to see how these mobile web apps could store…
chutsu
  • 13,612
  • 19
  • 65
  • 86
2
votes
1 answer

Is there a way to overcome the 5MB storage limit on an iPhone WebApp hosted in an ObjectiveC native app?

We have a iPhone web application that uses WebSQL that is working fine. The amount of data downloaded depends on the user of the app. If the user has more than 5MB data, the user is prompted to increase the size of their database. We then moved our…
Kevin
  • 9,309
  • 12
  • 44
  • 51
2
votes
0 answers

WebSql disabled by default in IOS13, a workaround exists for Safari, but can it apply to PWA's?

iOS13 appears to drop support by default for WebSQL. There exists a workaround to enable WebSQL in Safari, but this appears to only apply for Safari. I haven't found such a workaround for Firefox or Chrome on Safari. Similarly, this workaround does…
Zain Syed
  • 443
  • 4
  • 12
2
votes
0 answers

WebSQL PhoneGap is not returning insertId?

I am using PhoneGap and WebSql. When i am trying it on browser everything is fine.SQLResultSet object has 3 property which are rows,insertId and rowsAffected. But When i generate and Apk and trying a mobile device, SQLResultSet object has two…
mr.
  • 679
  • 12
  • 30
2
votes
1 answer

Ionic 3 : storage in both IndexedDB and Web SQL

I'm working on a mobile application for both android and iOS mobile phone. I'm experiencing something very weird with the Storage. I get data in both IndexedDB and Web SQL (when I'm testing/debugging in Browser). Here is the declaration of the…
Jérôme Vervier
  • 21
  • 4
2
votes
2 answers

HTML5 Websql- How to use with Ionic 3 and Angular 4

I am trying to put websql api with Ionic 3 and Angular 4 var db = openDatabase('mydb', '', 'my first database', 2 * 1024 * 1024); When I invoke openDatabase, it shows opendatabase is not a function and the page doesnt load. But in the browser I can…
jslearner07
  • 451
  • 1
  • 4
  • 17
2
votes
0 answers

What are options for Storing large data in WKWebView IOS as Web SQL is not supported

I have a Web SQL application which creates a database in browser and store data ranging from 5MB to 120MB. Loading this database the app fetches record executing queries and show result. This thing works good for Chrome browsers on all OS, safari…
Vivek Tankaria
  • 1,301
  • 2
  • 15
  • 35
2
votes
1 answer

Ionic 2: RC.0 Storage no longer works in browser

Q) How can I get my app to work in the browser as before, using WebSQL/SQLite? I've been using the ionic Storage module since forever, which enabled my app to run with WebSQL in the browser and SQLite on the device itself. This was simple and…
Dave
  • 5,283
  • 7
  • 44
  • 66
2
votes
1 answer

jQuery Async | Websql

I have trouble with looping. I want to realize the following steps: Download a huge JSON file from the web and then I want to loop through all the objects and for every object (product) download the image from the web (with an AJAX call) and fill…
Mathis Hüttl
  • 281
  • 4
  • 18
1 2 3
…
56 57