sql.js + Worker + IndexedDB

sql.js tests with IndexedDB as storage and Worker.

  1. Load sql.js library in worker - one time only;
  2. Creates SQLite database;
  3. Load data from the IndexedDB if any.

Enter SQL below and execute

Insert into SQLite database, below is the example insertion SQL.

  • Match Whole: match the entered text as a whole to all TEXT type table columns.
  • Match Line by Line: split the entered text by new line characters, create a TEMPORARY TABLE with the text lines and match all TEXT type table columns using CROSS JOIN.
  1. Close SQLite database;
  2. Erase SQLite database from memory;
  3. Delete IndexedDB database.