Show HN: SQLite Playground(sqlime.org)
sqlime.org
Show HN: SQLite Playground
https://sqlime.org/
37 comments
Good work, always happy to see new tools related to SQLite and Wasm!
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?
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?
Thanks! Not really — the playground is meant for small databases. Just as one won't develop the whole app in JSFiddle, they probably won't import a large database to the playground.
https://phiresky.github.io/blog/2021/hosting-sqlite-database... might be of interest too.
> It is not a W3C Standard nor is it on the W3C Standards Track
In other words, it should not be used. More concretely IIRC it only works on Chrome.
In other words, it should not be used. More concretely IIRC it only works on Chrome.
really nice that you've used wasm and no server. This seems really secure to test.
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.
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.
Thanks! I've always liked the idea of SQL in the browser, since the Web SQL times.
That part is provided by the excellent sql.js project btw: https://github.com/sql-js/sql.js/
That part is provided by the excellent sql.js project btw: https://github.com/sql-js/sql.js/
It would of course also increase server's potential attack layer. sqlite had some bugs, potentially exploitable, if you are able to invoke arbitrary statements
https://www.sqlite.org/cves.html https://www.sqlite.org/security.html
https://www.sqlite.org/cves.html https://www.sqlite.org/security.html
It can't change under you on a whim though, can't it? Unless you host it yourself.
Sure but you can always keep the network tab in the devtools open and be confident nothing is getting exfiltrated
Once you see a connection doing so, it is too late :)
Love it! It'd be nice to have a couple more example datasets, and I'd promote them to the top level (rather than in 'more'). I think the first thing many users will want to do is just try to tool with some pre-provided datasets - and when it works nicely (which it does!) then maybe import their own data
Thanks! I was even thinking of loading the demo database by default (instead of creating the empty one).
How does it differ from http://sqlfiddle.com/ ?
It's easier to say how are they similar: both are capable of executing SQL in the browser. The rest is different.
I have been using https://www.db-fiddle.com/
Awesome, looks like using sqlite in browser is trending and there are new tools created often.
Even I created a tool :) https://news.ycombinator.com/item?id=25791207
Even I created a tool :) https://news.ycombinator.com/item?id=25791207
This is great! Very useful - great work on getting it up and running.
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!
https://csvee.io/
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!
https://csvee.io/
query results are not escaped. haha
https://sqlime.org/#gist:d31fd00895d34821797ccde8f94169fe
Looks good, only thing I'd like to see added is the wholenumber extension. It's surprisingly useful for creating mock data for tests.
Looks great! I created something similar at http://sqlforever.com/
I'm afraid I don't see the point of this at all. What does it offer that running sqlite from my command line does not?
Presumably use on bad devices with no CLI available. Also sharing URLs with people to show them a thing quickly.
The same argument could be said for most web-based playgrounds. I'd argue for small prototyping, playgrounds/pens offer an easier interface and enable sharing of artifacts
Five of the six points the OP mentions are relevant, specially #5:
> — The latest version of SQLite.
And minimalism is certainly appreciated also!
> — The latest version of SQLite.
And minimalism is certainly appreciated also!
no .tables command?
Heh, that's the first thing I tried, "show tables"
As others have mentioned there is a menu option to show the tables. You can also run this sql query to see the tables:
SELECT name FROM sqlite_master WHERE type='table'
SELECT name FROM sqlite_master WHERE type='table'
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.
— Minimalism.
So I did it myself — an online SQLite playground for debugging and sharing SQL snippets.
Sample database: https://sqlime.org/#gist:e012594111ce51f91590c4737e41a046