This is the best tool in its category that I've found. It's the only that can stream results (so you can run SELECT without LIMIT and see the first results immidiately) and display them as a table.
I was looking for a simple, no bloat sqlite explorer that runs in a container and ended up deploying sqlite-web[1] in read-only mode. Very impressed, no external dependencies, works great. A CLI tool is nice, but then still have to ssh into the remote server to access the db file.
This is the best tool in its category that I've found. It's the only that can stream results (so you can run SELECT without LIMIT and see the first results immidiately) and display them as a table.
EDIT: Crashes often though.
My SQL Playground can stream results and display them as a table: https://play.clickhouse.com/
And for a command-line client, clickhouse-client has been around since 2016.
Impressive, but the category I was refering to is SQLite clients.
How is that best in class, then? If it crashes often, it’s not production-ready.
I wrote that in a burst of enthusiasm before I noted the crashes.
Interesting to see a tool written in V in the wild. I will try it out just for that reason.
The UI looks a lot like Harlequin https://github.com/tconbeer/harlequin
I was looking for a simple, no bloat sqlite explorer that runs in a container and ended up deploying sqlite-web[1] in read-only mode. Very impressed, no external dependencies, works great. A CLI tool is nice, but then still have to ssh into the remote server to access the db file.
[1] https://github.com/coleifer/sqlite-web