What's RamboSQL for?There are times when you use MySQL for storing data that relates to the way your website or web application looks like. In other words, your site layout, and maybe images and/or stylesheets are partially or entirely stored in the DB, which is sometimes the case when you've got yourself a CMS or just designed the site that way from the get-go.
If you're using Subversion for your project, or even just updating the website occasionally, you will encounter a need to version your database. One way of doing that suggested by some is noting down all the changes you have made to the DB in a text file and including it with the revision. Ok, have fun with that one..
For everybody else, there's RamboSQL! Using the Maatkit Perl scripts, it will compare selected or all tables in two databases you specify, for instance, on your development and the staging servers, and produce 2 files: one for updating the destination database to make it identical to the current one, and one to undo those same updates in case you screw up for some reason (you know, upload some of that wonderful test data filled with South Park quotes or delete customers' profiles etcetera).
The files contain regular SQL statements needed to perform the update or undo it that you can just pipe right into MySQL, though RamboSQL will do it for you if you want. Those same files can also be included along with your code when you commit it to the repository or in case you just want to keep track of all the changes made to the database. Handy!
FeaturesRamboSQL was created in a bit of a hurry to address an immediate need for a project but since I haven't found anything like it online it made sense to share it. Here is a list of features for v.0.1: Compares select tables or entire databases Applies the changes to bring the destination DB up to speed or undo those changes by clicking a button Produces easy to version and archive .sql statement files with unique filenames for updating and undoing Keeps track of the last set of files created to easily undo the last operation performed
Use Patent Claims
Include Install Instructions
These details are provided for information only. No information here is legal advice and should not be used as such.