I'm looking for a database agnostic way to create new schemas. Something like
postgres_uri = "postgres://username:password@hostname/database"
mysql_uri = "mysql://username:password@hostname/database"
[postgres_uri, mysql_uri].each do |db|
connection = DB.connect(db_uri)
connection.create_schema("xyz")
end
Bonus marks for something that will work easily with the connection active_record establishes in rails.