All the Perl that's Practical to Extract and Report

a simple SQL client

sekimura on 2007-04-13T17:07:30

now I'm writing a simple SQL client that can connect multiple database servers. for some reasons I need to connect to MySQL and PostgreSQL.

using "screen" and "mysql + psql" works but sometimes I wanna share a term history on each SQL clients.

so, I'm doing it. Term::Shell and Text::ASCIITable rock.

TODO: handle '*', '%' and more SQL special chars.

UPDATE found DBI::Shell but it can't handle multiple DBI connections.

Vim and SQL

runrig on 2007-04-13T18:39:51

I like to run all of my ad-hoc SQL from within Vim. It's crude, but it does what I want it to do. It has to log in on every request, so I usually add stuff to automatically configure user/password for various database names.