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
4
votes
2 answers

angular 2 websql typings

I am writing an app in electron using angular 4. I need a database and want to use websql but I cannot find a way to import websql typings. I added @types/websql. In my IDE, there is no compil error when i do : const db: Database =…
ctruchi
  • 153
  • 7
4
votes
0 answers

Where is SQL database in Safari inspector for ionic app

When using Safari's web inspector on an ios emulator that has an Ionic app loaded, I'd expect to see a database that was created listed under the Databases folder in the Storage tab of Safari's inspector window. My database is not shown at…
lilbiscuit
  • 2,109
  • 6
  • 32
  • 53
4
votes
1 answer

how do I force PouchDB to really delete records?

I am creating a PouchDb like so : var db = new PouchDB('my_db', { auto_compaction: true, revs_limit: 1, adapter: 'websql' }); Then I create and delete a number of records : db.put({ _id: '1'}); db.put({ _id: '2'}); db.put({ _id:…
kris
  • 11,868
  • 9
  • 88
  • 110
4
votes
0 answers

Accessing the WebSQL database created by a WebView

We are assembling an Android app around an existing web-based solution by using an Android WebView. The solution makes use of WebSQL to store data, which we would like to pull out and use in our app. Is there any way to access, in an Android…
Nick Dyke
  • 41
  • 2
4
votes
1 answer

How to protect localstorage and websql data in cordova - ionic application

data stored in local-storage or in WebSql database is not protected. we can directly see all the data of WebSql and local-storage because they are stored as plain text. is there any way to protect data?
Bhavesh Jariwala
  • 885
  • 8
  • 27
4
votes
0 answers

Get the Column names of a table in Web-Sql

I am trying implement a mobile app by using phonegap.I will get the tables from server side using RestFul api.Here i want to get the column names of a particulat table. I have seen other posts but no body has given the answer with respect to web…
M.S.Naidu
  • 2,239
  • 5
  • 32
  • 56
4
votes
1 answer

Uncaught Error: SECURITY_ERR: DOM Exception 18 at file:///android_asset/www/js/DB.js

I m using cordova to build hybrid android app and i m using this function which return database object its works fine everywhere in app function openDB() { var dbUser = null; var dBVersion =…
user3732629
  • 141
  • 15
4
votes
1 answer

WebSQL Errors - datatype mismatch

I am running a WebSql query that contains an error; When i console.log(error) I get the following error message could not execute statement (20 datatype mismatch) What i need to know is what is that 20 in front of the message. How do I know on…
paishin
  • 258
  • 1
  • 5
  • 15
4
votes
1 answer

WebSQL: Are returned rows in SQLResultSetRowList immutable?

I've been fetching rows from a WebSQL DB, and the returned rows seems to be readonly. db.readTransaction( function(t1) { t1.executeSql( "SELECT * FROM Foo WHERE id = ?", [1], …
Mister Smith
  • 27,417
  • 21
  • 110
  • 193
4
votes
2 answers

Websql Insert Query

I am new websql.i cannot insert primary key in websql. Create Query db.transaction(function (tx) { var sql = "CREATE TABLE vehicles ( "+ "id integer primary key autoincrement,"+ "vehicle_ref_no VARCHAR(255),"+ …
Gopesh
  • 3,882
  • 11
  • 37
  • 52
4
votes
2 answers

Future of cross-platform mobile development without WebSQL

I would say that WebSQL is a great option for databases on Mobile Devices. It support "large" amout of data (compared to localStorage) and allows to operates locally. Actually, I'm developing an app which storages data "locally". It treats data…
meetnick
  • 1,196
  • 2
  • 12
  • 28
4
votes
1 answer

how to save data locally in HTML5 web page so that we do not need to fetch from server again and again?

I want to make an app through HTML5 through which user can visit and store data for offline, could any one give me references for that?
ShakC
  • 53
  • 1
  • 6
4
votes
1 answer

Difference between Web SQL and SQLite

After a long search still am not able to find a difference between Web SQL and SQLite. Are both HTML5 based? Web SQL has a storage limit whereas with SQLite there is no storage limit? Is an external plugin required for SQLite in phonegap? As…
Divesh Salian
  • 1,457
  • 17
  • 30
4
votes
1 answer

local storage vs Web SQL

I am working on a project, that is a mobile web app. I am using JQuery mobile. I have a page with a jquery listview, when a user clicks on each item on the list view all data associated with that item is passed to a dialog page. I used local storage…
Dot
  • 279
  • 1
  • 9
  • 21
4
votes
1 answer

javascript/WebSQL: how to cancel query

I have this situation in which I execute a complex query which will take some time. But sometimes I don't need the result anymore, so I would like to cancel it. Is this possible? Here is the basic structure: db.transaction( function(tx) { …
Jeanluca Scaljeri
  • 26,343
  • 56
  • 205
  • 333
1 2 3
…
56 57