HN Explorer

37 comments

[ 5.6 ms ] story [ 88.5 ms ] thread
nalgeon
What I've always lacked is something similar to JSFiddle / CodePen, but for SQLite. An online playground to quickly test the SQL query and share it with others.

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

leobg
Very cool. What better way to learn than to test and play and iterate. Thanks for making this! And beautiful it is, too.
nalgeon
Thanks a lot! Glad you find it useful.
pugworthy
no .tables command?
nalgeon
Nope — that's not SQL. Dot commands are available only in SQLite's CLI.

But there are 'more > show tables' command in the toolbar and Ctrl+/ shortcut which do exactly that.

pugworthy
True, but this is a SQLite CLI, isn't it? Run in a web browser?
bartvk
Heh, that's the first thing I tried, "show tables"
Scorpiion
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'

nicolasmelo12
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.

Siira
It can't change under you on a whim though, can't it? Unless you host it yourself.
jazzyjackson
Sure but you can always keep the network tab in the devtools open and be confident nothing is getting exfiltrated
krageon
Once you see a connection doing so, it is too late :)
Scaevolus
How does this compare to phiresky's work?

Can you include the FTS5 module?

nalgeon
Their work is a great POC how to handle large databases in the browser.

Mine is a tool for testing and sharing small snippets of SQL code.

shekhirin
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?

nalgeon
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.
krageon
> 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.

dspillett
Nice. A good wrapper around sql.js has been in my (ever-growing) want/todo list for some time. Good to see a decent implementation of the idea!
nalgeon
True, sql.js just asks for something like that :–) Thank you!
nemoniac
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?
osmarks
Presumably use on bad devices with no CLI available. Also sharing URLs with people to show them a thing quickly.
tfsh
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
severine
Five of the six points the OP mentions are relevant, specially #5:

> — The latest version of SQLite.

And minimalism is certainly appreciated also!

failingGrace
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/

[dead] chovybizzass
Why are you asking for my github creds? You don't really expect me to give you my github password do you?
RobinL
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
nalgeon
Thanks! I was even thinking of loading the demo database by default (instead of creating the empty one).
banana_giraffe
Looks good, only thing I'd like to see added is the wholenumber extension. It's surprisingly useful for creating mock data for tests.