sql.js tests with IndexedDB as storage and Worker.
- Either open https://yanli0303.github.io/sql-js-worker-test/ with a browser;
- Or sideload microsoft-outlook-add-in-manifest.xml in Microsoft Outlook as an add-in.
- First, on
OPENtab, click theOPEN SQLITE DATABASE IN WORKERto loadsql.jslibrary in Worker and initialize the SQLite database. - Then, on
EXEC SQLtab,- Choose
CREATE TABLEby clickingSELECT SQL; - Check the
Will the SQL write any data?; - Click the
EXEC SQLbutton.
- Choose
- Switch to
INSERTtab, select the number of rows to insert, then click theINSERTbutton.The page might freeze for a few seconds while it generates random strings and numbers to insert.
- To verify the insertion, go back to
EXEC SQLtab, chooseSELECT COUNT(*)inSELECT SQLand click theEXEC SQLbutton to get the number of rows in the table. - Go to
MATCHtab, enter random numbers or texts, hit either of the two match buttons.