ActiveRecord 0.2 has been released. (It's actually 0.2.1 because of a minor Gem glitch)
Ola wraps it up in the link above, but for the record it supports normal AR operations and basic migrations for the following databases:
- Microsoft SQL Server (except for change_column_default)
- DB2 (except change_column, change_column_default, rename_column, remove_column,
add_index, remove_index and rename_table)
- Derby (except change_column, change_column_default, remove_column, rename_column)
- FireBird (except change_column_default and rename_column)
I'm going to demo the AWDwR2 Depot app running on top of MySQL at Rails, and probably demonstrate one of the other databases Rails doesn't normally support as well (Derby perhaps? or SQL Server if I can get Parallels up before presenting?)
Ola has a Derby walkthrough with some unusual typos [Update: my mistake, he symlinked stuff like "gem" to "jem" to avoid collisions with MRI], but here's my walkthrough for MySQL in ultra-condensed form:
- Install JRuby from trunk or my branch
- Build it (not necessary once we get another release out)
ant clean jar
- Set up env vars for JRuby
export JRUBY_HOME=[jruby dir]
export PATH=[jruby dir]/bin:$PATH
- Install Rails
gem install rails -y --no-rdoc --no-ri
- Install ActiveRecord-JDBC
gem install activerecord-jdbc --no-rdoc --no-ri
- Generate a Rails App
- Go to the app
- Modify database.yml
- Modify environment.rb:
require File.join(File.dirname(__FILE__), 'boot')
- Add driver to CLASSPATH
- Create a testapp_development database, grants for testapp user, and widgets table in MySQL (use migrations if you like)
- Scaffold Widgets CRUD
jruby script/generate scaffold widget
- Start up the server
Pretty neat, eh?
- ActiveRecord-JDBC does not install: I had some trouble myself; I think something's up with either RubyForge or with our released gem. You can always download ActiveRecord-JDBC and install it locally, of course.
- scaffold fails with an error about "nonexistent jdbc adapter": Ensure you've added the require line to environment.rb (hopefully this will be unnecessary in the future)
- scaffold and script/server terminate without running: Make sure you've successfully installed the ActiveRecord-JDBC gem. The additional require in environment.rb causes Rails scripts to die silently if there are any errors.
- scaffold fails with the error "cannot convert NilClass into String": Make sure you've correctly specified the driver and url lines in database.yml
We're going to continue adding database support, especially if you folks can contribute migrations impls for your database of choice. It's fun and easy!
We've also got a patch under discussion to allow adding JDBC database jars to [RAILS_ROOT]/lib and have the driver pick them up automatically. This could obviously be extended to Rails at large for service client jars, persistence framework jars, and so on. No more CLASSPATH manipulation!
We're hoping to get the Rails guys to include "jdbc" in the list of supported adapters out-of-the-box, so that environment.rb require is not necessary.
We're also going to see if there's a way to abstract out all the DDL code in core Rails, so we can all benefit from the same code.