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
83
votes
8 answers

How permanent is local storage on Android and iOS?

When my app stores data locally on a phone, how permanent is that storage? I'll elaborate the exact situation: I'm building an app with jQueryMobile and Phonegap. It's essentially a browser app, but using Phonegap lets me package it and sell it in…
Wytze
  • 7,844
  • 8
  • 49
  • 62
74
votes
7 answers

Developing a HTML5 offline storage solution for iOS/Android in 2011

The problem: I need a device agnostic (e.g. HTML5) solution for storing and querying 250,000+ rows of data offline on a phone or tablet type device (e.g. iOS/Android). The idea being I have people working in remote areas without any cellular data…
zuallauz
  • 4,328
  • 11
  • 43
  • 54
53
votes
9 answers

How to delete a database in WebSQL programmatically?

I am new to Web SQL database and I use it to save data in a local database in a web page. 　I can create a database by var db = openDatabase('database', '1.0', 'my database', 2 * 1024 * 1024); 　and I can create a table by doing…
Derek 朕會功夫
  • 92,235
  • 44
  • 185
  • 247
45
votes
6 answers

HTML5 IndexedDB, Web SQL Database and browser wars

I'm starting the development of a web app with offline database storage requirements. Long story short, the app should be able to run on: One of the major desktop browsers, Chrome preferred Safari on iOS Android's native browser (based on V8 and…
ivo
  • 4,101
  • 5
  • 33
  • 42
40
votes
2 answers

When should I use Web SQL versus IndexedDB?

Recently, I have come across the Web SQL and IndexedDB APIs that are provided by browsers. What are the use cases for Web SQL and IndexedDB and when should I use one over the other?
Utsav Sinha
  • 605
  • 1
  • 5
  • 12
38
votes
1 answer

Conceptual problems with IndexedDB (relationships etc.)

I'm writing a thesis about offline abilities of web applications. My task is to show the possibilities of offline storage through a web application with a server-side relational database and Ajax/JSON traffic between client and server. My first…
Felix
  • 769
  • 1
  • 7
  • 8
29
votes
5 answers

Local Storage, Session storage, Web storage, web database and cookies in HTML5

What is the difference between these concepts, and when should I use one in particular? Does this listing also contain different names for the same general concept? HTML5 local storage HTML5 session storage HTML5 web storage HTML5 web…
texai
  • 3,696
  • 6
  • 31
  • 41
27
votes
1 answer

Javascript: Searching indexeddb using multiple indexes

I want to change from WebSql to Indexeddb. However, how would one do SQL queries like SELECT * FROM customers WHERE ssn = '444-44-4444' and emal = 'bill@bill@company.com' SELECT * FROM customers WHERE ssn = '444-44-4444' and emal =…
Jeanluca Scaljeri
  • 26,343
  • 56
  • 205
  • 333
18
votes
5 answers

phonegap - sqlite or Indexed DB?

I am web developer starting with phonegap. I need to create one app for iPhone, android and Windows Phone 8. I need to store some data (too big for localStorage) locally. I don't know witch solution is the best: Phonegap provides Storage (based…
Iwona Trąbka
  • 203
  • 1
  • 3
  • 7
17
votes
6 answers

JavaScript Library to Bridge IndexedDB and WebSQL

I'm curious if there is a library or a project out there to provide a generic interface to IndexedDB or to WebSQL, depending on user's browser's support. If they're using Chrome/Safari, use WebSQL, if they're using Firefox or Internet Explorer, use…
Peder Rice
  • 1,764
  • 3
  • 28
  • 51
16
votes
4 answers

Queryable client-side storage

What solutions are there for queryable client-side data stores? This would be used as a temporary cache to perform basic operations like sorting and aggregating over user-selected date ranges in the client I've found a few promising candidates, but…
user1424744
  • 161
  • 1
  • 5
14
votes
2 answers

Safely storing data in a HTML5 iOS application - are localStorage / WebSQL / IndexedDB appropriate?

I'm writing a HTML5 application that I want to release on the iOS app store. Either using PhoneGap or wrapped in a UIWebView control. I'm a bit confused about what options I have in terms of storing data for my application. Are using localStorage,…
asgeo1
  • 9,028
  • 6
  • 63
  • 85
14
votes
3 answers

Processing a large (12K+ rows) array in JavaScript

The project requirements are odd for this one, but I'm looking to get some insight... I have a CSV file with about 12,000 rows of data, approximately 12-15 columns. I'm converting that to a JSON array and loading it via JSONP (has to run…
S16
  • 2,963
  • 9
  • 40
  • 64
13
votes
3 answers

What is the status of HTML5 Database?

This spec http://www.w3.org/TR/webdatabase/ says: This document was on the W3C Recommendation track but specification work has stopped. The specification reached an impasse: all interested implementors have used the same SQL backend (Sqlite), but…
Phrogz
  • 296,393
  • 112
  • 651
  • 745
13
votes
2 answers

Synchronous query to Web SQL Database

I'm working on a bit of JavaScript that interacts with a client-side SQLite database, via the newish window.openDatabase(...), database.transaction(...) and related APIs. As most of you know when you execute a query in this way it is an asynchronous…
Naim
  • 133
  • 1
  • 1
  • 6
1
2 3
…
56 57