Sqlite-Commander - A Curses client for your SQLite Database". I am happy to introduce to you, my recent nighttime hack "".

Sqlite-Commander => Click to enlarge

While I was working in a project involving sqlite, I wanted to check the contents of a sqlite database. The command line sqlite client involves too much of typing for viewing records. The sqlite viewers that I found were not very keyboard friendly. There was a firefox extension which looked good but I felt it is too clumsy to launch that application. Also, I wanted a tool that will read SQLite tables over ssh without requiring much bandwidth. I could not find any CUI client for SQLite and I felt it may be useful to write one, atleast for my satisfying my needs. So, here we have. The name is inspired from an awesome piece of software Midnight-Commander written by Miguel De Icaza.+ 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 "..."It is not a full-fledged SQLite client with rich features. It is like an enriched version of cat for working with sqlite. I don't intend to make a release, as I am not sure if this will be useful for anyone other than people who work with SQLite and can use only a terminal/ssh. If there are enough users, I will enhance and make it a full-fledged product. So drop me a mail if you are interested in this project.+ It should be fairly straight-forward to implement connectivity to any database (MySQL, Oracle, etc.) such that we can have a generic SQL NCurses client. It will be a good exercise for someone who wants to know C#.+ 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. Useful ?+ Copy selections of records to clipboard. Easy to implement.+ Handle tablenames with special characters.Credits are due for the awesome mono-ncurses interface authors (Miguel and Co.) If you are looking to writing some terminal application I can heartily recommend that mono-ncurses is the best library you will ever get. Before beginning this application, I evaluated a few options (like Python etc.) and nothing comes close to being as easy to use as mono-ncurses. Also, special thanks toand, two of the most productive tools ever invented.