When should we use Web SQL or IndexedDB? What are the use cases?

google-chrome indexeddb web-sql
Utsav Sinha picture Utsav Sinha · Sep 26, 2017 · Viewed 8.3k times · Source

Recently I have come across Web SQL and IndexedDB provided by browsers. I want to understand the use cases when these can be used.

Answer

Hakan picture Hakan · Apr 22, 2018

Web SQL is deprecated per https://www.w3.org/TR/webdatabase/.

You can use IndexedDB if you need to store structured client specific data that you do not store in the server side or you do not want to request from the server every time.

Also as opposed to localStorage, IndexedDB is async so it is more performant. It supports indexing resulting in more efficient querying than localStorage which is simply a key-value store. However, if your needs are simple, localStorage might be a better option.

Here is a link that talks about different web storage options. Here is a tutorial about how to use IndexedDB for a progressive web app.

Related questions

How to delete indexedDB?

I'm working in a project which involves using IndexedDB. As I'm begining to know this technology, I need to be able to delete an indexedDB by hand so I can start over. I found the way to do it in …

Read More
Why is this IndexedDB put command failing? Error: DataError: DOM IDBDatabase Exception 0

I have successfully added the following to the objectStore when I created it: { name: "John Doe", age: 21 } I used the options: { keyPath: "id", autoIncrement: true } I am able to find that record and it shows the id = 1. However, when I …

Read More
Check if IndexedDB objectStore already contains key

Adding an object to an IndexedDB objectStore will fail if the key already exists. How can I check for the existence of an object with a given key – preferably synchronously (no reason for another layer of callbacks) and without pulling …

Read More