From e8ce511c915337ba31969b2766776e3f75141cd0 Mon Sep 17 00:00:00 2001
From: Ardis Lu <ardisglu@gmail.com>
Date: Sat, 20 Jan 2024 18:47:56 -0800
Subject: [PATCH] Upgrade sql.js

String memory issue fixed in 1.10.2
---
 demo/index.html | 6 +++---
 sidebar.html    | 6 +++---
 2 files changed, 6 insertions(+), 6 deletions(-)

diff --git a/demo/index.html b/demo/index.html
index 8e57606..7697078 100644
--- a/demo/index.html
+++ b/demo/index.html
@@ -12,7 +12,7 @@
   <link rel="icon" href="data:,">
   <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/codemirror@5.65.16/lib/codemirror.min.css">
   <link rel="preload" href="https://sheets-db-sql.ardis.lu/file/sheets-db/database.sqlite3" as="fetch" crossorigin>
-  <link rel="preload" href="https://cdn.jsdelivr.net/npm/sql.js@1.10.1/dist/sql-wasm.wasm" as="fetch" crossorigin>
+  <link rel="preload" href="https://cdn.jsdelivr.net/npm/sql.js@1.10.2/dist/sql-wasm.wasm" as="fetch" crossorigin>
   <style>
     body {
       font-family: -apple-system, system-ui, BlinkMacSystemFont, "Segoe UI", Roboto,
@@ -226,7 +226,7 @@ LIMIT 25</textarea>
   <!-- Load CodeMirror and sql.js -->
   <script src="https://cdn.jsdelivr.net/npm/codemirror@5.65.16/lib/codemirror.min.js" crossorigin></script>
   <script src="https://cdn.jsdelivr.net/npm/codemirror@5.65.16/mode/sql/sql.min.js" crossorigin></script>
-  <script src="https://cdn.jsdelivr.net/npm/sql.js@1.10.1/dist/sql-wasm.js" integrity="sha512-Rw3r47C4BVCj/4dy0MiF30B9c7+dLNeJdgPkyw8KiiYqUzAP3XFFw90EjO7mHLkJBl7JCm+/iTuL9dGh47lbMw==" crossorigin></script>
+  <script src="https://cdn.jsdelivr.net/npm/sql.js@1.10.2/dist/sql-wasm.js" integrity="sha512-Rw3r47C4BVCj/4dy0MiF30B9c7+dLNeJdgPkyw8KiiYqUzAP3XFFw90EjO7mHLkJBl7JCm+/iTuL9dGh47lbMw==" crossorigin></script>
 
   <script>
     /** Helper functions to handle SQL execution and output */
@@ -289,7 +289,7 @@ LIMIT 25</textarea>
 
     /** Globals related to SQL.js */
     const sqlPromise = initSqlJs({
-      locateFile: file => `https://cdn.jsdelivr.net/npm/sql.js@1.10.1/dist/${file}`
+      locateFile: file => `https://cdn.jsdelivr.net/npm/sql.js@1.10.2/dist/${file}`
     });
     let db;
 
diff --git a/sidebar.html b/sidebar.html
index 371785d..b169cbf 100644
--- a/sidebar.html
+++ b/sidebar.html
@@ -4,7 +4,7 @@
 <head>
   <base target="_top">
   <link rel="stylesheet" href="https://ssl.gstatic.com/docs/script/css/add-ons1.css">
-  <link rel="preload" href="https://cdn.jsdelivr.net/npm/sql.js@1.8.0/dist/sql-wasm.wasm" integrity="sha512-sGvDmvDGqGZJMpyv2eGMCD46jfxutp6xADGZRyxF2it6XPKKR3YhfjW7dRsSbs00uX5nDkedNxGuz9PbL/RWmQ==" as="fetch" crossorigin>
+  <link rel="preload" href="https://cdn.jsdelivr.net/npm/sql.js@1.10.2/dist/sql-wasm.wasm" as="fetch" crossorigin>
   <style>
     body {
       height: 100%;
@@ -49,7 +49,7 @@
 
   <p class="bottom gray">https://github.com/ardislu/sheets-db</p>
 
-  <script src="https://cdn.jsdelivr.net/npm/sql.js@1.8.0/dist/sql-wasm.js" integrity="sha512-n7swEtVCvXpQ7KxgpPyp0+DQQEf5vPpmzCRl14x2sp2v5LpCYCjrAx03mkBAbWwGF9eUoIk8YVcDFuJRIeYttg==" crossorigin></script>
+  <script src="https://cdn.jsdelivr.net/npm/sql.js@1.10.2/dist/sql-wasm.js" integrity="sha512-Rw3r47C4BVCj/4dy0MiF30B9c7+dLNeJdgPkyw8KiiYqUzAP3XFFw90EjO7mHLkJBl7JCm+/iTuL9dGh47lbMw==" crossorigin></script>
   <script>
     // Globals for SQLite which will be overwritten later
     let SQL; // the sql.js instance
@@ -132,7 +132,7 @@
     // Initialize sql.js
     (async () => {
       // WARNING: The following line will break if you try to use string interpolation (i.e. strings with backticks)
-      SQL = await initSqlJs({ locateFile: file => 'https://cdn.jsdelivr.net/npm/sql.js@1.8.0/dist/' + file });
+      SQL = await initSqlJs({ locateFile: file => 'https://cdn.jsdelivr.net/npm/sql.js@1.10.2/dist/' + file });
       db = new SQL.Database();
 
       setState('loaded');
-- 
2.47.3