There are two specific tools that are making my life very easy right now.
1) MySQL Workbench
This is made of awesome. It's not without its bugs (and boy does it have those), but it does a fantastic job of helping structure the database tables without needing to deal with more details than I need. And its free (and open-source). Plus they supply a 64-bit DEB file if you need such a thing. I recommend getting the stable version. The beta/dev version doesn't seem to have database sync for some reason. It allows you to automatically update a live local or remote database server without a worry. You will not want to be without that!
2) Rose::DB::Object
This handles many-to-many relationships so much better than Class::DBI did. I've recently moved to R::DB::O and am not looking back. It subclasses beautifully and helps me keep my database details and my logic separate. Plus it deals with so much other stuff that I'm not sure how I lived without it. There is a great tutorial, too.
1) MySQL Workbench
This is made of awesome. It's not without its bugs (and boy does it have those), but it does a fantastic job of helping structure the database tables without needing to deal with more details than I need. And its free (and open-source). Plus they supply a 64-bit DEB file if you need such a thing. I recommend getting the stable version. The beta/dev version doesn't seem to have database sync for some reason. It allows you to automatically update a live local or remote database server without a worry. You will not want to be without that!
2) Rose::DB::Object
This handles many-to-many relationships so much better than Class::DBI did. I've recently moved to R::DB::O and am not looking back. It subclasses beautifully and helps me keep my database details and my logic separate. Plus it deals with so much other stuff that I'm not sure how I lived without it. There is a great tutorial, too.
Leave a comment