web-sql Questions
0
We've developed an app for iPad (using Sencha Touch and Phonegap) that stores data locally using websql db.
Thousands of records are inserted in db during synchronization, but sometimes the app cr...
Torch asked 16/11, 2013 at 21:5
1
Solved
I've tried to insert variables into multiple rows at once in Web SQL database but with all known to me methods I'm getting errors:
("INSERT INTO tab (a,b) VALUES (?,?),(?,?)",[v1,v2,v3,v4])
>&g...
Vulva asked 20/10, 2013 at 13:20
7
Solved
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...
Sforza asked 12/10, 2011 at 1:38
1
My old application used web2py with SQLite as the database. Now I want to try porting this app to Dart and again use SQLite as the database.
I can't find any documentation on how to use it. I just...
1
Solved
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@[email protected]'
SELECT * FROM custo...
Puling asked 11/5, 2013 at 20:33
2
Solved
As written in the Safari Client-Side Storage and Offline Applications Programming Guide, rolling back a HTML 5 Web SQL Database transaction is done by returning true in the callback function provid...
Matchmark asked 28/2, 2011 at 14:5
2
I have a web-based Android app that uses WebSQL for storage. For some reason, calling openDatabase at one point (in response to a button click), causes a DOMException with the message "SECURITY_ERR...
Phony asked 25/1, 2013 at 14:19
4
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...
Fenestra asked 18/2, 2013 at 22:27
2
Solved
I've the following code that gets a json recordset and insert some data in three different tables on the client Web Sql storage.
How can I intercept the end of databaseSync() function?
What I want...
3
Solved
I'm writing a pretty simple database application, which I want to be locally stored (as opposed to looking up a remote database). I like HTML/Javascript for designing interfaces, and they're cross-...
Polarimeter asked 6/5, 2012 at 11:44
3
Solved
My company is currently transitioning to a new architecture, as well as a model that provides services to mobile devices. Our application was traditionally web based (HTML5/CSS3/JS/PHP/MYSQL), so w...
1
Is there a way to execute multiple statements in a single transaction? I want to do something like:
db.transaction(function (tx) {
tx.executeSql(
"CREATE TABLE Foo(ID INTEGER); CREATE TABLE Bar(...
Newsom asked 4/12, 2012 at 21:52
1
I have created local DB (WebSQL) in HTML5. The content of the local storage has to be sent as an attachment in an email. The email client will be opened using javascript mailto feature.
The require...
Mcmurry asked 3/12, 2012 at 12:23
2
I am building an offline web app targeting iPhone and other mobile devices. Is there any way we can keep the user authentication saved using WebSql local storage?
So when you open the web app whi...
Fjeld asked 18/11, 2012 at 12:37
1
Solved
I have a JavaScript object with multiple rows of data and I want to insert it into web sql database.
Here is how my code looks like.
for(i in rows)
{
(function(row){
db.transaction(function(tx) ...
Disconnect asked 14/11, 2012 at 19:46
2
Solved
I guess I have a relative simple question, but I keep thinking in circles and even Google is not giving me an answer I can work with.
Basically I am trying to copy some records that are stored loc...
Fluorinate asked 16/10, 2012 at 11:26
4
Solved
I have one requirement where should be stored locally when internet is not available. It should handle it in cross browser compatible way. Now as I know there are variety of options to store ...
Rainbolt asked 19/9, 2012 at 15:59
1
Solved
Primecheck function is supposed to return true or false whether passed number is prime or not. If the number is prime, function adds it to PRIMES table.
This is a Sieve of Eratosthenes algorithm, b...
Birdiebirdlike asked 17/9, 2012 at 14:53
1
I've been trying to use web sql database api in webkit based browsers. I have been using the async api in the main ui thread and a web worker. Both threads access the same database (which as you kn...
Bombardon asked 15/2, 2012 at 14:43
2
I made a demo chrome extension to compare websql and indexeddb and to learn how both worked in more detail.
To my surprise it showed that indexeddb is a lot slower even compared to the most naive ...
Mercuric asked 11/4, 2012 at 8:38
3
For Chrome, I can use IndexedDB and WebSQL, for Firefox, I can use IndexedDB, what about IE? I have developed an app that uses WebSQL and it works fine on desktop Chrome and Safari, iOS Safari and ...
Emmerich asked 11/6, 2012 at 22:17
1
Solved
For a project with offline storage, I created a database with a primary key for the id and also a unique field holding the date.
When I delete an entry, I can not create a new one with the same da...
Dora asked 1/6, 2012 at 17:37
2
Solved
How is it possible to access Web SQL database created in PhoneGap app from native code in Android?
I have a local notification plugin set up and what I want to achieve is fetch user setting from w...
3
Solved
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 a...
Unrounded asked 7/5, 2012 at 16:6
1
So I am writing a web app that needs to store ~40MB of offline data in a offline Web SQL database. It needs to work in Chrome (desktop), Safari (desktop and mobile) and android's browser. Now I kno...
Chinquapin asked 21/4, 2012 at 16:40
© 2022 - 2024 — McMap. All rights reserved.