List:General Discussion« Previous MessageNext Message »
From:Daevid Vincent Date:May 23 2011 8:34pm
Subject:FW: MySQL shell...with parameters
View as plain text  
Here’s an email from a good friend of mine that may be of interest. It is done in
Ruby.
 
From: Brad Robel-Forrest [mailto:brad@stripped] 
Sent: Sunday, May 15, 2011 7:01 PM
To: Daevid Vincent
Subject: MySQL shell...with parameters
 
Remember a long while back I was bitching about the need for parameterized MySQL when
working at the prompt? Well, it took me down a road and I've fulfilled that need and many
more. If you're interested, I've opened a project on a shell that allows you to write all
manner of SQL queries with variable interpolation and even generated query for
programmatic searching through your database. Plus, it has the ability to do all of this
remotely over an SSH connection without needing to have a mysql binary installed either
locally or remotely.
 
Main project site: https://github.com/bradrf/rsql
Installing on Windows: https://github.com/bradrf/rsql/wiki/Install-on-Windows
Tutorial: https://github.com/bradrf/rsql/raw/master/example.rsqlrc
I've been using it a ton for analyzing our database at work for the past several months.
It's a rare day that goes by where I don't fire this up.

    -brad

Thread
FW: MySQL shell...with parametersDaevid Vincent23 May