Using Interbase 2007 in Ruby on Rails Project

Joe McGlyn, Director of Product Management at CodeGear has shown the way to use Interbase 2007 in Ruby on Rails as follows :-

Assuming you already have a project, here are the basic steps to modifying a project to work with InterBase as the database...

1. Get the InterBase gem
gem install ibruby

Comments by CCH :
There are a few ways to do this
a) c:\instantrails\ruby\bin >gem install ibruby

b) In Aptana RadRails,
i) call up the Gems Manager from
Windows\show view\Ruby Gems
ii) Within the Gems Manager
- Click Install
- select ibruby Gem

You can then see the progress within the Console Tab

c) In 3rdRail, you can use the Project Commander


2. Get the Rails adapter (from the root dir of your rails app or from the project commander) script/plugin source http://ibruby.rubyforge.org/svn/rails_plugins/trunk/
script/plugin install ibrails_plugin

Comments by CCH
a) Shell to Command prompt and cd to root of your project folder

c:\project_name>ruby script/plugin source http://ibruby.rubyforge.org/svn/rails_plugins/trunk/
c:\project_name>ruby script/plugin install ibrails_plugin

b) Using Aptana Radrals,
i) select the Rails Plugins Tab
ii) select ibruby and click Go

Nb. If ibruby does not show in the list, revert to method (a) :-)

c) In 3rdRail, you can use the Project Commander

NOTE :
You will also need to add these two lines into your Rails
environment.rb file:
# ------ force InterBase support to be added to Rails
# ------ as Rails currently has no way of extending its db
# ------ support apart from a new Rails release!
require 'active_record'
require 'vendor/plugins/ibrails_plugin/lib/ibrails_plugin'
# ------
Ideally these two lines should appear after the line loading
boot.rb which typically looks like this:
require File.join(File.dirname(__FILE__), 'boot')
and before anything else gets done (particularly any
initialization)

3. Assuming you have IB installed, and have the default IB user/pwd enabled you're good to go.
It will even create the database file (within your project directory by default)
Known limitation:Indicies are limited to ~200 characters, depending on how they are composed. This is InterBase, not the integration.

Comments by CCH

Despite religously following the instructions from Joe McGlyn of CodeGear, I have not been able to overcome the barrier and error message
ie "database configuration specifies nonexistent interbase adapter"
You may want to read the thread "Using Interbase with RoR" started by Joe here borland.public.3rdrail.ide