Direct database access

Adam Griffiths wrote:

I would like to write an app that makes some use of ActiveRecord for
persisting a few domain objects but also extensive direct database
access for doing things like creating new tables, adding columns /
indexes. Essentially I'm looking to replicate many of the features in a
tool like phpmyadmin for mysql, in a ruby app.

ActiveRecord has some schema editing abilities already due to it's migration facility. Take a look at that as much of the differences between the various database systems have already been abstracted for you.