5 ms·

ZeQLplus: Terminal SQLite Database Browser

82 points by amadeuspagel 1y ago

amadeuspagel 1y ago
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.
- deafpolygon 1y ago
  How is that best in class, then? If it crashes often, it’s not production-ready.
  - amadeuspagel 1y ago
    I wrote that in a burst of enthusiasm before I noted the crashes.
  - 0cf8612b2e1e 1y ago
    If only my production tools did not crash.
  - ugh123 1y ago
    For development (and table browsing purposes), some crashing is acceptable (to me at least), as long as the tool overall gives me a productivity boost. Perhaps OPs use-case of streaming large sqlite files for browsing purposes is not typical.
    - Intralexical 1y ago
      If it crashes a lot because it's full of undefined behavior/unhandled errors, then what is it doing when it encounters those issues and doesn't crash?
- zX41ZdbW 1y ago
  My SQL Playground can stream results and display them as a table: https://play.clickhouse.com/ https://play.clickhouse.com/ And for a command-line client, clickhouse-client has been around since 2016.
  - amadeuspagel 1y ago
    Impressive, but the category I was refering to is SQLite clients.
smartmic 1y ago
Interesting to see a tool written in V in the wild. I will try it out just for that reason.
CraigJPerry 1y ago
The UI looks a lot like Harlequin https://github.com/tconbeer/harlequin https://github.com/tconbeer/harlequin
- darkteflon 1y ago
  I really like Harlequin. Discovered it by accident when I was assessing Textual - I think they showcased it. I can’t think of another DB TUI tool as nice. I use it mainly with DuckDB, for which I believe it was originally written (although the web notebook UI that now ships with the DuckDB binary is also nice). Slightly OT, but PyCharm / Datagrip always feels quite flaky with DuckDB. Thanks to Harlequin, I never needed to dig into it too deeply. I only wish that DuckDB supported writes while attached (in read-only mode) from another process! Although I understand there are good reasons for not doing so.
nodesocket 1y ago
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 https://github.com/coleifer/sqlite-web
qingcharles 1y ago
It hasn't been updated in two years?
bomewish 1y ago
Visidata I thought had totally nailed the tui db browser category. It’s got intuitive key bindings, lots of helpful built in functions, works on csv, and so on. Will give this one a go too.

82 points by amadeuspagel 1y ago

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.

deafpolygon 1y ago
How is that best in class, then? If it crashes often, it’s not production-ready.
- amadeuspagel 1y ago
  I wrote that in a burst of enthusiasm before I noted the crashes.
- 0cf8612b2e1e 1y ago
  If only my production tools did not crash.
- ugh123 1y ago
  For development (and table browsing purposes), some crashing is acceptable (to me at least), as long as the tool overall gives me a productivity boost. Perhaps OPs use-case of streaming large sqlite files for browsing purposes is not typical.
  - Intralexical 1y ago
    If it crashes a lot because it's full of undefined behavior/unhandled errors, then what is it doing when it encounters those issues and doesn't crash?
zX41ZdbW 1y ago
My SQL Playground can stream results and display them as a table: https://play.clickhouse.com/ https://play.clickhouse.com/ And for a command-line client, clickhouse-client has been around since 2016.
- amadeuspagel 1y ago
  Impressive, but the category I was refering to is SQLite clients.

smartmic 1y ago

Interesting to see a tool written in V in the wild. I will try it out just for that reason.

CraigJPerry 1y ago

The UI looks a lot like Harlequin https://github.com/tconbeer/harlequin https://github.com/tconbeer/harlequin

darkteflon 1y ago
I really like Harlequin. Discovered it by accident when I was assessing Textual - I think they showcased it. I can’t think of another DB TUI tool as nice. I use it mainly with DuckDB, for which I believe it was originally written (although the web notebook UI that now ships with the DuckDB binary is also nice). Slightly OT, but PyCharm / Datagrip always feels quite flaky with DuckDB. Thanks to Harlequin, I never needed to dig into it too deeply. I only wish that DuckDB supported writes while attached (in read-only mode) from another process! Although I understand there are good reasons for not doing so.

nodesocket 1y ago

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 https://github.com/coleifer/sqlite-web

qingcharles 1y ago

It hasn't been updated in two years?

bomewish 1y ago

Visidata I thought had totally nailed the tui db browser category. It’s got intuitive key bindings, lots of helpful built in functions, works on csv, and so on. Will give this one a go too.