bowing down to salute monks.
I would like to create a bare minimum command line editor for SQL. I have libarary Term::ReadKey; -- and nothing else.
Anyone has already done this editor code that I can leverage? ( basically that allows user to move cursor, type and insert and delete ). Any general advice on how to write/design this ?
Background: Currently my team uses "isql -S .. -U.." in Linux cmd prompt and the output is often too wide, wrapped in many lines - resulting in misaligned output. I would be very happy if I could write sql editor tool replacing this "isql" .
I have written a DBI:: module, that extends DBI and Statement handler classes. This makes my team's DB coding tasks (remote load, saving in file/FPT, mailing query output as report) much faster. I could create a nice "HTML table like tabulated display" of sql output that team is happy. I want to add the editor mentioned above to make this complete.
thanks,
Jay