tune_my_query is an extension of the gem me_gusta written by John Pignata
It is a simple way to switch between standard SQL and extended SQL syntax depending on the adapter. For example: PostgreSql has an ILIKE extension which is not found in other databases like mysql. This gem(not released yet) ensures the query is adapted based on the current database.
Gemcutter uses PostgreSql in production and uses ILIKE in one of the queries. For anyone, hacking on their local machine will have to change it to LIKE for it to work. Also, when it comes to accepting patches from a MySql user this would again pose a minor issue. Hence, this gem.
It is simple to use. Just install it like:
sudo gem install tune_my_query
And do the following in the model class where you have used a database specific SQL, like this:
Here 'like' signifies the extension to usual SQL LIKE.
Does it only work with LIKE? What a futile effort
Yes, at the moment it only does that. But, you can fork the code and add your own commands in the lib/commands directory. Every new command you add should have a name ending with "Command". For example: AwesomeCommand. Add a singleton "execute" method to it and send me a patch, I will add it in. Please do add specs.
In order to run the specs you should have mysql and postgresql installed. Here's how to install PostgreSql on a Mac. And, just do:
sudo gem install pg
to install postgreSql adapter or you can use bundler and install project dependencies with it.
Please report the issues through gitHub's issues.
- To make it work for any database extension. At the moment it would only work for PostgreSql specific SQL extensions.