5 ms·

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 e

by pampa 6y ago

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/ https://litecli.com/ [2] https://www.dbcli.com/ https://www.dbcli.com/

flas9sd 6y ago
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 https://www.sqlite.org/forum/forumpost/3d157b175c The mongodb cli neither has the ability to set a pager I noticed recently.
deleted 6y ago
[deleted]
JNRowe 6y ago
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/ptpython/ ² https://pypi.org/project/prompt-toolkit/ https://pypi.org/project/prompt-toolkit/ ³ https://github.com/prompt-toolkit https://github.com/prompt-toolkit
fantod 6y ago
Nice! I came to the comment section precisely to see if someone could recommend an alternative to the default client.
leonim 6y ago
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/ https://www.visidata.org/ [2] tutorial: VisiData in 60 Seconds(https://jsvine.github.io/intro-to-visidata/the-big-picture/visidata-in-60-seconds/ https://jsvine.github.io/intro-to-visidata/the-big-picture/v...)

by pampa 6y ago

flas9sd 6y ago

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 https://www.sqlite.org/forum/forumpost/3d157b175c The mongodb cli neither has the ability to set a pager I noticed recently.

deleted 6y ago

[deleted]

JNRowe 6y ago

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/ptpython/ ² https://pypi.org/project/prompt-toolkit/ https://pypi.org/project/prompt-toolkit/ ³ https://github.com/prompt-toolkit https://github.com/prompt-toolkit

fantod 6y ago

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

leonim 6y ago

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/ https://www.visidata.org/ [2] tutorial: VisiData in 60 Seconds(https://jsvine.github.io/intro-to-visidata/the-big-picture/visidata-in-60-seconds/ https://jsvine.github.io/intro-to-visidata/the-big-picture/v...)