From 403729f3cad0eef670164962bb1f773b2ca79534 Mon Sep 17 00:00:00 2001 From: Andreas Baumann Date: Wed, 13 Dec 2023 21:32:16 +0100 Subject: fts5 search working via http, not https, no clue --- search/fts5/README | 1 + search/fts5/main.js | 10 ---------- themes/new_theme/layouts/partials/ranklist_fts5.html | 4 +++- 3 files changed, 4 insertions(+), 11 deletions(-) delete mode 100644 search/fts5/main.js diff --git a/search/fts5/README b/search/fts5/README index db52dc2..f1c5006 100644 --- a/search/fts5/README +++ b/search/fts5/README @@ -72,6 +72,7 @@ cp node_modules/sql.js-fts5/dist/sql-wasm.wasm ../../themes/new_theme/static/js/ # https://github.com/phiresky/sql.js-httpvfs # https://github.com/psanford/sqlite3vfshttp # https://phiresky.github.io/blog/2021/hosting-sqlite-databases-on-github-pages/ +# https://github.com/jlongster/absurd-sql # https://github.com/kbumsik/sqlite-wasm sudo pacman -S typescript diff --git a/search/fts5/main.js b/search/fts5/main.js deleted file mode 100644 index 4f5d648..0000000 --- a/search/fts5/main.js +++ /dev/null @@ -1,10 +0,0 @@ -const initSqlJs = require( 'sql.js-fts5' ); - -//~ const SQL = initSqlJs({ - //~ locateFile: file => `http://localhost:1313/js/${file}` -//~ }); - -//~ const db = new SQL.Database(); - -//~ let sqlstr = "SELECT * FROM posts"; -//~ db.run(sqlstr); diff --git a/themes/new_theme/layouts/partials/ranklist_fts5.html b/themes/new_theme/layouts/partials/ranklist_fts5.html index cf65f56..cf003f1 100644 --- a/themes/new_theme/layouts/partials/ranklist_fts5.html +++ b/themes/new_theme/layouts/partials/ranklist_fts5.html @@ -2,7 +2,9 @@ +