<story><title>Command Line Shell for SQLite</title><url>https://www.sqlite.org/cli.html</url></story><parent_chain><item><author>pampa</author><text>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.&lt;p&gt;[1] &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;litecli.com&amp;#x2F;&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;litecli.com&amp;#x2F;&lt;/a&gt;&lt;p&gt;[2] &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;www.dbcli.com&amp;#x2F;&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;www.dbcli.com&amp;#x2F;&lt;/a&gt;</text></item></parent_chain><comment><author>leonim</author><text>My favorite terminal based client to explore SQLite databases and many other data formats is the TUI VisiData[1].&lt;p&gt;It has a spreadsheet-like interface and makes it very easy to explore a SQLite database in the terminal&lt;p&gt;[1] &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;www.visidata.org&amp;#x2F;&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;www.visidata.org&amp;#x2F;&lt;/a&gt;&lt;p&gt;[2] tutorial: VisiData in 60 Seconds(&lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;jsvine.github.io&amp;#x2F;intro-to-visidata&amp;#x2F;the-big-picture&amp;#x2F;visidata-in-60-seconds&amp;#x2F;&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;jsvine.github.io&amp;#x2F;intro-to-visidata&amp;#x2F;the-big-picture&amp;#x2F;v...&lt;/a&gt;)</text></comment>
<story><title>Command Line Shell for SQLite</title><url>https://www.sqlite.org/cli.html</url></story><parent_chain><item><author>pampa</author><text>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.&lt;p&gt;[1] &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;litecli.com&amp;#x2F;&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;litecli.com&amp;#x2F;&lt;/a&gt;&lt;p&gt;[2] &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;www.dbcli.com&amp;#x2F;&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;www.dbcli.com&amp;#x2F;&lt;/a&gt;</text></item></parent_chain><comment><author>flas9sd</author><text>I&amp;#x27;m a fan of the series too, for one specific puropse: being able to set a pager.&lt;p&gt;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.&lt;p&gt;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&amp;#x27;s `pager less` in mysql and `\pset pager less` in postgres. See my comment on v3.33 (when alot of cli enhancements got introduced): &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;www.sqlite.org&amp;#x2F;forum&amp;#x2F;forumpost&amp;#x2F;3d157b175c&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;www.sqlite.org&amp;#x2F;forum&amp;#x2F;forumpost&amp;#x2F;3d157b175c&lt;/a&gt;&lt;p&gt;The mongodb cli neither has the ability to set a pager I noticed recently.</text></comment>