IndexedDB

Working with IndexedDB

Sample (try it in jsFiddel):

    var cityData = [{city:"Redmond", population:57530},
        {city:"Atlanta",population:447841},
        {city:"San Fracisco", population:837442}];

    // Create IndexdDB database and fill it with data from array
    alasql('CREATE INDEXEDDB DATABASE IF NOT EXISTS geo;\
        ATTACH INDEXEDDB DATABASE geo; \
        USE geo; \
        DROP TABLE IF EXISTS cities; \
        CREATE TABLE cities; \
        SELECT * INTO cities FROM ?', [cityData], function(){

        // Select data from IndexedDB
        alasql.promise('SELECT COLUMN * FROM cities WHERE population > 100000 ORDER BY city DESC')
              .then(function(res){
                document.write('Big cities: ', res.join(','));
        });
    });

Errors

All IndexedDB operations are asyncronous. This is the main reason try catch construction does not catch errors fron IndexedDB. Please see more about async code execution.

DROP

To drop an IndexedDB database please remember to include the engine name

DROP INDEXEDDB DATABASE db_name