3 ms·
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 h
by davb 3y ago
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.
- p4bl0 3y agoDo you know about SQLite DB Browser ? It's a multi platform application that would perfectly fit your use case :). https://sqlitebrowser.org/ https://sqlitebrowser.org/
- jswank 3y agoTake a look at https://sqliteviz.com/ https://sqliteviz.com/ to do exactly this.
- chrisjc 3y agoSounds like a job for DuckDB. DuckDB is to Snowflake/Bigquery (OLAP/analytics) what sqlite is to mysql/postgres (OLTP). https://sql.quacking.cloud/ https://sql.quacking.cloud/ https://duckdb.org/docs/archive/0.9.2/api/wasm/overview https://duckdb.org/docs/archive/0.9.2/api/wasm/overview
- crashabr 3y agoHave you looked at Datasette? Seems like it addressed the exact pain point you're describing.