[davb]

I was looking for something just like this the other day. I’ll often import a CSV into SQLite to do some ad hoc data analysis and transformation, but realised how useful it would be to have a JS/WASM based tool I could host on a static site for my colleagues (academics who don’t necessarily feel comfortable working in the terminal). Being able to say “import your CSV here and run some of these example queries” would be so useful. No complex web app or reporting suite to host, and nothing to install.

[chrisjc]

Sounds like a job for DuckDB. DuckDB is to Snowflake/Bigquery (OLAP/analytics) what sqlite is to mysql/postgres (OLTP).

https://sql.quacking.cloud/ https://duckdb.org/docs/archive/0.9.2/api/wasm/overview

[jswank]

Take a look at https://sqliteviz.com/ to do exactly this.

[p4bl0]

Do you know about SQLite DB Browser ? It's a multi platform application that would perfectly fit your use case :).

https://sqlitebrowser.org/

[crashabr]

Have you looked at Datasette? Seems like it addressed the exact pain point you're describing.