4 ms·
Sqlite3 Utility in the Browser
- baudaux 3y agoThe web browser is the new virtual machine
- davb 3y agoI 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.
- deleted 3y ago[deleted]
- adius 3y agoIf you want to take it to the next level, we’re building https://www.airsequel.com https://www.airsequel.com, a full fledged SQLite hosting platform!
- Lord_Zero 3y agoThat does look like a cool product, but I will say I don't love the idea of being restricted on how many tables, columns and rows I can have in my SQLite database...
- nalgeon 3y agoYou can also embed SQLite shell into your blog or product documentation: https://codapi.org/sqlite-wasi https://codapi.org/sqlite-wasi
- Jones4000 3y ago[dead]