HTML5 database storage (SQL lite) – few questions

by

The spec you’re looking for is Web SQL Database. A quick reading suggests:

  1. There is no limit, although once your databases increase beyond a certain size (5MB seems to be the default), the browser will prompt the user to allow for more space.
  2. There is no way, in the current spec, to delete databases.
  3. The executeSql() function takes an optional error callback argument.

HTML5 Doctor also has a good introduction.

Going forward, though, I’d recommend looking at Indexed DB. Web SQL has essentially been abandoned since there is no standard for SQL / SQLite. Even Microsoft has endorsed Indexed DB. See Consensus emerges for key Web app standard.

More Related Contents:

  1. Can HTML5 databases and localStorage be shared across subdomains?
  2. I need a client side browser database. What are my options [closed]
  3. Normalization in database management system
  4. How to perform compound queries with logical OR in Cloud Firestore?
  5. Surrogate vs. natural/business keys [closed]
  6. Do you use source control for your database items? [closed]
  7. What is NoSQL, how does it work, and what benefits does it provide? [closed]
  8. database vs. flat files
  9. First name, middle name, last name. Why not Full Name?
  10. Can we update primary key values of a table?
  11. How do I output the results of a HiveQL query to CSV?
  12. SQLite UPSERT / UPDATE OR INSERT
  13. Elastic search, multiple indexes vs one index and types for different data sets?
  14. Import SQL dump into PostgreSQL database
  15. Can I do transactions and locks in CouchDB?
  16. Multivalued Fields a Good Idea?
  17. Elasticsearch query to return all records
  18. How to login and authenticate to Postgresql after a fresh install?
  19. Update the value of a field in database by 1 using codeigniter
  20. Versioning Database Persisted Objects, How would you? [closed]
  21. What are the differences between B trees and B+ trees?
  22. What is the default Precision and Scale for a Number in Oracle?
  23. What is caching?
  24. How to make a UUID in DynamoDB?
  25. Strange behavior in PowerShell function returning DataSet/DataTable
  26. Populating Spinner From SQLite Database Android
  27. List of standard lengths for database fields
  28. How to get item count from DynamoDB?
  29. How to find SQLITE database file version
  30. Oracle: How do I convert hex to decimal in Oracle SQL?

Leave a Comment