Total Pageviews

Sunday, 12 June 2016


Sqlite-Commander is a project that is aimed to display sqlite databases in Terminal using ncurses. Mono.NCurses is used as the CUI framework. The name is inspired from Midnight-Commander written by Miguel De Icaza.

All the source code is available to you in LGPL v2.1 only.

Drop me a mail if you like the software.

+ Shows the list of tables in the left pane. 
+ Allows you to navigate the list of tables using arrow keys.
+ Shows the first 30 records for the selected table in the right pane
+ Non-printable columns are shown with a ???
+ Maximum of 30 characters are displayed per column. Column data exceeding this length are shown with "..."

There are few things which will be good to have. But I don't see a pressing need for these features in my workflow. So I have not implemented these. But patches are more than welcome. If you feel very interested about some of these items, send me a mail and I may do it :) Sending mails with patches for these features will be even more awesome.

+ Add a scroll bar and show more than 30 columns. Should be moderate/easy to implement.
+ Add a dialog box to execute any random SQL statement. Should be fairly trivial to implement.
+ Create Events such that pressing Enter on the records list will pass the currently selected record to a custom script/command. 
+ Copy selections of records to clipboard. Should be moderate/easy to implement.

Hacking Sqlite-Commander
1) Install mono-devel packages, make
2) Checkout MonoCurses package from Mono source code repositories: git clone
3) ./configure --prefix=/usr ; sudo make install
4) Checkout Sqlite-Commander sources from github: git clone
5) Substitute "<SQLITE FILE PATH>" in the Makefile with your sqlite file path.
6) make run

You can also execute sqlite-commander manually and pass the database file path as a command line option.