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
-1
votes
1 answer

Capturing errors from WebSQL commands

In my effort to learn more about WebSQL, I've ran across an "Errorundifined" in my javascript code. I've tested the code and can't seem to find the error. However, The database "To Do" gets created but not the table "Tasks". Can someone…
Mister Tech
  • 11
  • 2
-1
votes
2 answers

Web SQL INSERT INTO causing a crash

I have created a database, a table, and pre-populated it with initial values in one method: function Setup(cb) { _db = openDatabase("MoneyMan", "1.0", "Money Manager", 8 * 1024 * 1024); // Wallets _db.transaction(function(tx) { …
Zotoaster
  • 393
  • 2
  • 4
  • 15
-1
votes
1 answer

JavaScript WebSQL databases

I'm having a problem with my code below. db = openDatabase('mydb', '1.0', 'my first database', 5 * 1024 * 1024); if(!db) { alert("Failed to connect to database."); } else { function doQuery(queryType,query) { function errorHandler(tr,…
theOldMan
  • 19
  • 3
-1
votes
1 answer

jQ Mobile Collapsibles Not working while adding Content with innerhtml

When I try To get Dynamic Content from Websql jQ Mobile Collapsibles stops working but when i enter some input in search bar it start working agin..so plz help me wid this problem ,,,,, just copy and pest the code and help me... THANK YOU IN…
user3409412
  • 1
  • 1
-1
votes
1 answer

JS not entering transaction function

I have the following code: var db = openDatabase('CBDB', '1.0', 'mySpecialDatabaseThatWontWork',10*1024*1024); db.transaction(function (nw){ nw.executeSql('Drop TABLE user'); }); function db1(){ var db =…
GouravR
  • 184
  • 1
  • 9
-1
votes
1 answer

What medium does 50Mb limit for Web SQL Database on iOS apply to?

I have been researching this topic for a while but have come across no specific answers. I am attempting to insert a set of videos into a Web SQL Database on a site I'm developing. The issue I have is the videos that memory amounts to 300Mb+ and…
Christopher Grigg
  • 2,238
  • 27
  • 33
-1
votes
1 answer

Get a value from database using jQuery promises and use it anywhere

I am using jQuery promises to return the data set from a web SQL database table and using $.when, I can return the data set and use it inside $.when according to this link Return multiple rows as an array from a WebSQL databse using javaScript But…
vidulaJ
  • 1,232
  • 1
  • 16
  • 31
-1
votes
1 answer

In a Node webkit App, WEB SQL API is not creating a database

I'm creating a database and a table for my node webkit app, using this : var db = openDatabase('vizDb', '1.0', 'Visualiation database', 2 * 1024 * 1024); db.transaction(function (tx) { query = 'CREATE TABLE IF NOT EXISTS dataworking (id,…
vivekanon
  • 1,813
  • 3
  • 22
  • 44
-1
votes
1 answer

JayData orderBy function produce strange result

I have table in websql to get data from that i am using JayData and write this _context.FoodLog.include("FoodItem").orderByDescending("it.TotalCalories").toArray().then(function(foodLogs) { $scope.$apply(function () { try { …
Blu
  • 4,036
  • 6
  • 38
  • 65
-1
votes
1 answer

Create HTML5 web database in project directory

I am a newbie in using HTML5 web database. If I create a website using it and host it, different users will have their own different databases as the database is created in the user's local machine. Is it possible to create a HTML5 web database in…
Saurabh Saxena
  • 3,005
  • 10
  • 31
  • 46
-1
votes
1 answer

How to check if query result is empty

tx.executeSql("SELECT * FROM Routes WHERE id_object = 0", [], function (tx, result) { alert('You already added'); }, function (tx, error) { tx.executeSql('INSERT INTO Routes (id_object) VALUES (0)'); alert('add successfull')} ) } …
user2382168
  • 7
  • 4
-2
votes
2 answers

Is Possible to convert image file to binary format in Javascript.

how to convert image file to binary format in Javascript. I can not get a solution for this. Please explain Is this possible or not?
Gokul Kumar
  • 389
  • 6
  • 16
-2
votes
1 answer

js variable value into Web Sql db

I cannot find a solution for passing JS variable value (text) into websql DB .. All i keep finding is some PHP solutions and I do not want to use it. function store(){ var x = document.getElementById('inp1').value; names.push(x); L10(); …
GoranCrO
  • 19
  • 6
-3
votes
1 answer

Firebase for half and SQL for another half

I have built an app using firestore as we are interested in the realtime updates portion of things. However,we are not building a website that has CRM component where a lot of reports will be generated. The contents of that CRM are all new. There is…
Snake
  • 14,228
  • 27
  • 117
  • 250
-4
votes
1 answer

How do I Connect to the Local database to the Server MYSQL database

Hello Friends I want to Send the Data from local database to Server MYSQL database How it is possible.Means Local server to the Remote…
Karan Adhikari
  • 352
  • 1
  • 12
1 2 3
…
56
57