Hacker News Reader

Comment by pampa | Hacker News Reader

For everybody using sqlite cli from a terminal window, check out litecli [1]. It has some nice features like syntax color, better completion and query editing etc. It is part of the dbcli [2] family of database terminal clients. There are cli for mysql, postgres, redis and other databases.

[1] https://litecli.com/

[2] https://www.dbcli.com/

View on HN

My favorite terminal based client to explore SQLite databases and many other data formats is the TUI VisiData[1].

It has a spreadsheet-like interface and makes it very easy to explore a SQLite database in the terminal

[1] https://www.visidata.org/

[2] tutorial: VisiData in 60 Seconds(https://jsvine.github.io/intro-to-visidata/the-big-picture/v...)

I've been really enjoying the litecli experience. Having been a ptpython¹ user I already knew about prompt_toolkit², but somehow had missed litecli.

This comment is just a general recommendation for Python users to have a poke around the GitHub organisation³, as the packages are awesome.

¹ https://pypi.org/project/ptpython/

² https://pypi.org/project/prompt-toolkit/

³ https://github.com/prompt-toolkit

I'm a fan of the series too, for one specific puropse: being able to set a pager.

Generally the sqlite cli would be sufficient, but not having a pager for the output overflows the terminal and is a major hindrance in working with standard database tools.

Using no GUI helps with learning too I think. There are workarounds to stay in the shell context and pipe to the utils and append a pager. For an analogy, it's `pager less` in mysql and `\pset pager less` in postgres. See my comment on v3.33 (when alot of cli enhancements got introduced): https://www.sqlite.org/forum/forumpost/3d157b175c

The mongodb cli neither has the ability to set a pager I noticed recently.

Nice! I came to the comment section precisely to see if someone could recommend an alternative to the default client.

Reply on news.ycombinator.com