Here is what I wanted:
— Binary database import, not just SQL schema.
— Support both local and remote databases (by url).
— Save the database and queries in the cloud.
— Free of charge, no sign-up required.
— The latest version of SQLite.
So I did it myself — an online SQLite playground for debugging and sharing SQL snippets.
Sample database: https://sqlime.org/#gist:e012594111ce51f91590c4737e41a046
As I see, currently you're loading whole DB into the memory, so large databases might become a problem. Did you think of adopting https://wicg.github.io/file-system-access, so users could query their databases directly from filesystem?
In other words, it should not be used. More concretely IIRC it only works on Chrome.
I was thinking at first: Hey, this might be kinda dangerous, imagine iterating in a tool and sending my database to a server and any attacker retrieves the database.
But since it runs everything inside of the browser with wasm i found it WAY more secure. Nice that you've done it, will probably use it a lot.
That part is provided by the excellent sql.js project btw: https://github.com/sql-js/sql.js/
Even I created a tool :) https://news.ycombinator.com/item?id=25791207
Coincidentally I threw together something very similar recently to run sqlite over csv files. It's very WIP right now and missing lots of useful things (e.g. currently every column is TEXT and maany more QOL things) but remarkably similar to sqlime!
Can you include the FTS5 module?
Mine is a tool for testing and sharing small snippets of SQL code.
> — The latest version of SQLite.
And minimalism is certainly appreciated also!
But there are 'more > show tables' command in the toolbar and Ctrl+/ shortcut which do exactly that.
SELECT name FROM sqlite_master WHERE type='table'