fix base url not included in db of sqlide

mikebarkmin · mikebarkmin · commit 87f8c5506431 · 2026-03-16T12:58:07.000+01:00
diff --git a/.changeset/rich-houses-guess.md b/.changeset/rich-houses-guess.md
@@ -0,0 +1,6 @@
+---
+"@hyperbook/markdown": patch
+"hyperbook": patch
+---
+
+Fix missing basepath in db of sqlide
diff --git a/packages/markdown/src/remarkDirectiveSqlIde.ts b/packages/markdown/src/remarkDirectiveSqlIde.ts
@@ -23,24 +23,31 @@ export default (ctx: HyperbookContext) => () => {
 
         const data = node.data || (node.data = {});
         const attributes = node.attributes || {};
-        const {
+        let {
           id = hash(node),
-          db = ctx.config.elements?.sqlide?.db ||
-            ctx.makeUrl(
-              [
-                "directive-sqlide",
-                "include",
-                "assets",
-                "databases",
-                "world1.sqLite",
-              ],
-              "assets",
-              undefined,
-              { versioned: false },
-            ),
+          db,
           height = ctx.config.elements?.sqlide?.height || "600px",
         } = attributes;
 
+        if (!db) {
+          db = ctx.config.elements?.sqlide?.db
+            ? ctx.makeUrl(ctx.config.elements?.sqlide?.db, "public")
+            : ctx.makeUrl(
+                [
+                  "directive-sqlide",
+                  "include",
+                  "assets",
+                  "databases",
+                  "world1.sqLite",
+                ],
+                "assets",
+                undefined,
+                { versioned: false },
+              );
+        } else {
+          db = ctx.makeUrl(db, "public", ctx.navigation.current || undefined);
+        }
+
         expectContainerDirective(node, file, name);
         registerDirective(
           file,
diff --git a/website/en/book/changelog.md b/website/en/book/changelog.md
@@ -38,6 +38,18 @@ If you need a new feature, open an [issue](https://github.com/openpatch/hyperboo
 ::::
 -->
 
+## v0.89.1
+
+::::tabs
+
+:::tab{title="Fixed :bug:" id="fixed"}
+
+- Fix issue where the base URL was not included in the SQLIDE database URL.
+
+:::
+
+::::
+
 ## v0.89.0
 
 ::::tabs
