From ee0cff8a1e23a5ba59a21ae5ed042502110d14a1 Mon Sep 17 00:00:00 2001 From: Ardis Lu Date: Sat, 27 Nov 2021 23:21:26 -0800 Subject: [PATCH] Update demo to use SQLite binary instead of query --- demo/index.html | 17 ++++++++--------- 1 file changed, 8 insertions(+), 9 deletions(-) diff --git a/demo/index.html b/demo/index.html index 2b05c42..aaf38c0 100644 --- a/demo/index.html +++ b/demo/index.html @@ -164,11 +164,11 @@ document.getElementById('execute').addEventListener('click', () => executeSQL(editor.getValue())); /** Globals related to the initial data table */ - const queryPromise = fetch('https://sheets-db-sql.ardis.lu/file/sheets-db/generateDatabaseQuery.sql').then(response => response.text()); // Fetch from CDN mapped to Backblaze - // const queryPromise = fetch('https://f002.backblazeb2.com/file/sheets-db/generateDatabaseQuery.sql').then(response => response.text()); // Fetch from Backblaze origin - // const queryPromise = fetch('http://sheets-db-sql.ardis.lu/sheets-db/generateDatabaseQuery.sql').then(response => response.text()); // Fetch from CDN mapped to Google Storage - // const queryPromise = fetch('https://storage.googleapis.com/sheets-db/generateDatabaseQuery.sql').then(response => response.text()); // Fetch from Google Storage origin - // const queryPromise = fetch('/generateDatabaseQuery.sql').then(response => response.text()); // Fetch from local + const databasePromise = fetch('https://sheets-db-sql.ardis.lu/file/sheets-db/database.sqlite3').then(response => response.arrayBuffer()); // Fetch from CDN mapped to Backblaze + // const databasePromise = fetch('https://f002.backblazeb2.com/file/sheets-db/database.sqlite3').then(response => response.arrayBuffer()); // Fetch from Backblaze origin + // const databasePromise = fetch('http://sheets-db-sql.ardis.lu/sheets-db/database.sqlite3').then(response => response.arrayBuffer()); // Fetch from CDN mapped to Google Storage + // const databasePromise = fetch('https://storage.googleapis.com/sheets-db/database.sqlite3').then(response => response.arrayBuffer()); // Fetch from Google Storage origin + // const databasePromise = fetch('/database.sqlite3').then(response => response.arrayBuffer()); // Fetch from local /** Globals related to SQL.js */ const sqlPromise = initSqlJs({ @@ -178,11 +178,10 @@ let db; (async () => { - const data = await Promise.all([queryPromise, sqlPromise]); - const [generateDatabaseQuery, SQL] = data; + const data = await Promise.all([databasePromise, sqlPromise]); + const [database, SQL] = data; - db = new SQL.Database(); - db.run(generateDatabaseQuery); + db = new SQL.Database(new Uint8Array(database)); })(); -- 2.47.3