It ain't free, but there's a lovely client for mysql called navicat
(http://www.navicat.com/) that we've been using. And even though I *can*
do command line queries, gotta say I love pulling lines between tables to
set them up. It's not too expensive and I find that for light to medium
weight stuff it's fun and easy to use.
On Wed, 30 Jul 2008, Eric Lease Morgan wrote:
> On Jul 30, 2008, at 1:47 PM, Cloutman, David wrote:
>> Perhaps you should put together some MySQL training materials for
>> librarians. A webinar, perhaps. I'd love it if my colleagues had those
>> skills. I don't think there is that much interest, but I could be wrong.
>> There are at least 101 ways enterprise level database skills could be
>> put to work in my library. I'm pretty sick of our core technical
>> solutions being Excel spreadsheets and the occasional Access database.
> Tell me about it, and besides, basic SQL is not any more difficult than CCL.
> SELECT this FROM that WHERE field LIKE "%foo%" Moreover, IMHO, relational
> databases are the technological bread & butter of librarianship these days.
> Blissful ignorance does the profession little good.
> Eric Lease Morgan
> Hesburgh Libraries, University of Notre Dame