0
I Use This!
Activity Not Available

Project Summary

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

Tags

mysql rambosql subversion

In a Nutshell, rambosql...

 No code available to analyze

Open Hub computes statistics on FOSS projects by examining source code and commit history in source code management systems. This project has no code locations, and so Open Hub cannot perform this analysis

Is this project's source code hosted in a publicly available repository? Do you know the URL? If you do, click the button below and tell us so that Open Hub can generate statistics! It's fast and easy - try it and see!

Add a code location

GNU General Public License v3.0 or later
Permitted

Place Warranty

Use Patent Claims

Commercial Use

Modify

Distribute

Forbidden

Sub-License

Hold Liable

Required

Distribute Original

Disclose Source

Include Copyright

State Changes

Include License

Include Install Instructions

These details are provided for information only. No information here is legal advice and should not be used as such.

All Licenses

This Project has No vulnerabilities Reported Against it

Did You Know...

  • ...
    Black Duck offers a free trial so you can discover if there are open source vulnerabilities in your code
  • ...
    compare projects before you chose one to use
  • ...
    55% of companies leverage OSS for production infrastructure
  • ...
    check out hot projects on the Open Hub

 No code available to analyze

Open Hub computes statistics on FOSS projects by examining source code and commit history in source code management systems. This project has no code locations, and so Open Hub cannot perform this analysis

Is this project's source code hosted in a publicly available repository? Do you know the URL? If you do, click the button below and tell us so that Open Hub can generate statistics! It's fast and easy - try it and see!

Add a code location

Community Rating

Be the first to rate this project
Click to add your rating
   Spinner
Review this Project!
Sample ohloh analysis