DuckDB is great, and DuckDB-WASM is magic.
I build a whole LLM benchmark system around it that lets you run the whole benchmark in your browser: https://sql-benchmark.nicklothian.com/#sample-queries-and-sq...
Click on a cell and you can run the SQL the LLM generated vs what the solution is: https://sql-benchmark.nicklothian.com/?highlight=ggml-org_ge...
The hardest part is getting people to understand that it is interactive! People expect a document-looking webpage to be static, but we can do so much better!
This is awesome. Is your code open source? It would be cool to make a textbook for SQL in this format.
Yes, code here: https://github.com/nlothian/llm-sql-benchmark
There is a V2 branch with some minor fixes etc I'm working on.
Can it be run as a static site(github pages) ?
It is completely static - everything is done on the client side.
It's WASM plus client-side React components in a static site.
I'm hosting of Cloudflare Pages (without their serverside function hosting), so yes GH pages will work fine.