From b086884c25d781f6ab6d4a151bf76580a649612f Mon Sep 17 00:00:00 2001 From: Ardis Lu Date: Sat, 28 Aug 2021 20:16:53 -0700 Subject: [PATCH] Fetch query from CDN instead of local --- demo/generateDatabaseQuery.sql | 9 --------- demo/index.html | 6 +++++- 2 files changed, 5 insertions(+), 10 deletions(-) delete mode 100644 demo/generateDatabaseQuery.sql diff --git a/demo/generateDatabaseQuery.sql b/demo/generateDatabaseQuery.sql deleted file mode 100644 index d69f53d..0000000 --- a/demo/generateDatabaseQuery.sql +++ /dev/null @@ -1,9 +0,0 @@ --- This query was generated by sheets-db --- https://docs.google.com/spreadsheets/d/1pY-0oDh4pI8NffZQwN-AkpfJdot7bmlM9nky7w150UY/ - - CREATE TABLE table_1 ('id' INTEGER,'first_name' TEXT,'last_name' TEXT,'birthday' TEXT,'city' TEXT,'state' TEXT,'long_string' TEXT,'complex_string' TEXT,'number_column_1' INTEGER,'number_column_2' INTEGER,'number_column_3' INTEGER,'number_column_4' INTEGER,'number_column_5' INTEGER,'float_column_1' REAL,'float_column_2' REAL,'float_column_3' REAL,'float_column_4' REAL,'float_column_5' REAL); - INSERT INTO table_1 VALUES (1,'Francis','Hood','1954-03-31T08:00:00.000Z','Hialeah','Florida','This is a really, really, really, really, really, really, really, really, really, really, really, really, really, really, really, really, really, really, really, really, really, really, really, really, really, really, really, really, really, really long string. It''s over 256 characters! ID number: 1','This string has complex characters to test your encoding. Emojis: 😀😁😂 XML comment: executeSQL(editor.getValue())); /** Globals related to the initial data table */ - const queryPromise = fetch('/generateDatabaseQuery.sql').then(response => response.text()); // Fetch from local + 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 /** Globals related to SQL.js */ const sqlPromise = initSqlJs({ -- 2.47.3