Which ruby ORM framework to use in a standalone ruby app?
database, orm, postgresql, ruby
Solution
Check out DataMapper. I recently used it with Sinatra and deployed the app to Heroku. The only SQL I had to write was CREATE DATABASE. Everything else DataMapper provided for me with the .auto_migrate! and .auto_upgrade! functionality.
The foreign key support is in the dm-constraints plugin.
Problem
I would like to use postgresql with foreign keys to define relationships in data so that other platforms/apps would also be able to easily use the same database. Having some kind of ruby DSL to define database schema with migration support would also be great. Which framework would you recommend for me? Is there some kind of framework for only handling database schema changes, migrations and versions separate of ORM?