Sample: SQL Client in ruby ncurses
I am putting up a small SQL Client made in about 3 hours using rbcurse. The idea of course was to see deficiencies in the library, and yes, for adhoc queries auto_sizing of columns is required. Need to work on that.
The demo shows a textarea, enter a query and press Run to see the results in a table. The listbox on top-right shows the tables in the database, pressing Space on any will show its columns in the second list. Pressing Enter will display its data in the table.
The idea of the columns is to select columns and have the names be pushed to the textarea, or auto-generate SQL’s.Similar to sqlminus (sourceforge project).
I will put in some more work on this, just to find out how rbcurse can be improved more.

April 28, 2009 at 10:06 pm
That looks great do you know of any other ncurses command line sql clients?