MySQL: A Grab Bag of Useful Bits
Database management tools are nice to have, but they're not essential (I'm talking about you, MySQL Workbench). When the tools aren't working, for whatever reason, you can always go back to basics and create the objects you need from the simple, mysql command-line utility. Here's a grab bag of things you can do...
MySQL and Rails 3 on a PC
Rails 3.0 is the new big thing, and deservedly so. But getting MySQL working with Rails 3 on a PC can be problematic. Here's some easy steps to make your life a whole lot easier if you're doing Rails and MySQL development on a PC.
Managing Database Dumps Using MySQL
On every project, I find myself creating a development version of the project database. The easiest way to get a database with real data in it for testing purposes is to make a dump of an existing database and load it wherever it's needed. Here's some simple instructions on how to create a database dump of a MySQL database and how to subsequently load that database dump.
Debugging Cross-Database Issues in Rails Migrations
It's pretty common in the Rails community to use migrations with multiple types of databases, e.g. - developers might use MySQL in their development environments while creating code targeted to run in production against an Oracle database. Learn about some of the pitfalls, and solutions, associated with using migrations in a cross-database manner.
Simulating IDENTITY Columns in Oracle
Microsoft SQL Server supports IDENTITY columns that can be used to generate unqiue primary key values. Unfortunately, Oracle does not support this useful feature. Find out how this feature can be simulated in Oracle.
Understanding How Oracle Triggers are Executed
Oracle's triggers provide a powerful way to implement complex business rules within the database itself. Take a whirlwind tour of the features that make Oracle triggers so powerful. Find out about a useful convention for naming triggers that provides better support future maintenance activities.