News for hackers. Stuff that matters.
Re:Hosting SQLite databases on GitHub Pages or any static fi... by bbkane on Sunday May 02, 2021 @03:24PM (#27018124)
Would it be possible to use a datasette frontend with this as a "backend" and statically host the whole thing?
Re:Hosting SQLite databases on GitHub Pages or any static fi... by simonw on Sunday May 02, 2021 @03:28PM (#27018174)
Not easily - Datasette is written in Python, so you could try running it in WebAssembly (like Mozilla did for Jupyter with https://hacks.mozilla.org/2019/03/iodide-an-experimental-too... ) but it would be enough work that it might be easier to reimplement a subset of Datasette directly in JavaScript.
Re:Hosting SQLite databases on GitHub Pages or any static fi... by rewq4321 on Friday May 07, 2021 @10:00AM (#27075941)
I've got no experience with Datasette, but if it's all in pure python, then you can use Pyodide[0] to run it within a wasm module. I was surprised how easy it was - took about 15 minutes and I had a Python package working perfectly in the browser. The Python package is about 3x faster than the JS/wasm version, but I'm guessing that performance gap will narrow when we get wasm-gc.

[0] https://github.com/pyodide/pyodide

Re:Hosting SQLite databases on GitHub Pages or any static fi... by bbkane on Sunday May 02, 2021 @03:39PM (#27018280)
Thank you!