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

Browser database that can sync between other devices?

I am developing a Web App and I would like to add functionality that enables users to use it while offline (Application Cache). I am looking for a tool that can sync the browser's DB (IndexedDB) between offline devices and then sync with MySQL when…
I'll-Be-Back
  • 10,530
  • 37
  • 110
  • 213
2
votes
0 answers

iOS 8 Safari indexedDB.open returns null

We are developing web app, that uses framework that uses indexedDB. All was going fine, but then we tested it on iPad and suddenly it didn't load the page at all. Thought it would be some minor issue, but after some tests we found out, that the app…
ezpzlmnsqz1337
  • 394
  • 1
  • 5
  • 16
2
votes
1 answer

How do I set the initial database size with IndexedDBShim?

I am using the polyfill IndexedDBShim to create a database on iOS Safari 7.1. However, it throws an error in indexeddbshim.min.js (line 118) and then tells me: "Application cache update failed, because size quota was exceeded." despite the entire…
Don Rhummy
  • 24,730
  • 42
  • 175
  • 330
2
votes
0 answers

Crosswalk WebSql Limits?

My cordova app currently has ~60,000 data points in PouchDB (and growing). When using Cordova's default webkit Websql adapter it stops accepting any more writes after 50MB (known limit). The work around was to use the Cordova Sqlite plugin, which…
CorbinUX
  • 576
  • 7
  • 14
2
votes
1 answer

cordova android sql select returning length 1 but no rows

I'm having some weird behaviour on this app I'm developing. While testing on browser everything seems to work fine, but I tried deploying my app on a device to test and apparently everything WebSQL related works fine up until I do a select. My…
Thiatt
  • 564
  • 1
  • 6
  • 21
2
votes
2 answers

Reading info from sqlite database, Syntax? How do I use it in html5 webapp?

I have a webapp that I'm building, and have just started with SQLite. I have been able to create my form, open the database I created, create the table, and fields i need, and enter data into the fields. Now I'm trying to read the data back out…
Mac-Gon
  • 240
  • 1
  • 8
  • 18
2
votes
1 answer

Storing Decimal value in Websql

I am trying to store a decimal value like -0.19999999999999998 and 174.18319999453 in a WebSql database. I however get the value round to -0.2 for -0.19999999999999998 in the database. I will like to save it as a number, not a string. thank…
David Addoteye
  • 1,587
  • 1
  • 19
  • 31
2
votes
1 answer

How to rename a database in Web SQL?

Is there a way to rename a database in Web SQL? I need a simple way to backup all data to another Web SQL database.
drinovc
  • 521
  • 5
  • 16
2
votes
0 answers

can we increase the storage limit of web-sql For apple ipad

I'm creating offline application with phonegap and HTML5. for that i m using Web-SQL database. and i have bunch of images around 1500. problem is i cant download it every time so i m converting the images in base64 code and save into the Web-SQL…
Kashyap Patel
  • 1,139
  • 1
  • 13
  • 29
2
votes
1 answer

Issue binding Angular ng-repeat to WebSQL/SQLLite

in a Cordova app I have been attempting to bind angular mark-up like this: …
Nick D
  • 286
  • 1
  • 4
  • 15
2
votes
0 answers

iOS App Crashing when SQLLite inserting more than 3000 records using Phonegap and Good Dynamics

I am using Phonegap(Cordova) with "Good dynamics" in iOS. We have a table with 15 columns and need to insert more than 10000 to 200000 records based on condition at once. But my app is getting crashed in iPAD when testing for more than 2000 records…
Kiran
  • 1,145
  • 1
  • 8
  • 22
2
votes
1 answer

Websql Does not create tables

db = window.openDatabase("javascript.db", "1.0", "My app", 2 * 1024 * 1024); db.transaction(function(tx){ tx.executeSql("CREATE TABLE topic (topic_id TEXT PRIMARY KEY NOT NULL, topic_name TEXT UNIQUE NOT NULL, 'topic description' TEXT)"); …
Amron
  • 197
  • 1
  • 9
2
votes
1 answer

How to populate sqlite database from a db file hosted on Google Drive or any other server

I am creating a question answer hybrid application and for that I am using webSQL I do not have a complete database for my app at the moment and it will never be complete. So I want to know if I could host a sqlite database file or a dump of that…
Amron
  • 197
  • 1
  • 9
2
votes
1 answer

Is there a preferred way of converting a SqlResultsetRowList to an array?

When I try this in Ramda I get an Illegal Invocation exception: var arr = R.map(r.rows.item, R.range(0, r.rows.length)); I can do it in two lines but then it seems even more of a hack: var i = 0; var arr = R.repeatN(null, r.rows.length).map(…
ilitirit
  • 16,016
  • 18
  • 72
  • 111
2
votes
3 answers

Order grouped selection by condition in IndexedDB

I have an object store "messages" with "timestamp" and "chat_id" fields inside it. I want to get all "chats" inside this object store ordered by "timestamp" field. As far as I see, I can't do it with IndexedDB only. I can get them like this using…
Dmitrii Sorin
  • 3,855
  • 4
  • 31
  • 40
1 2 3
…
56 57