Installation instructions for Ruby on Rails 1.x

Copy the file informix_adapter.rb into the directory:

  $RUBYLIB/gems/1.8/gems/activerecord-*/lib/active_record/connection_adapters/

where RUBYLIB is probably /usr/local/lib/ruby in Unix, and C:\ruby\lib\ruby in Windows.

Then edit the file:

  $RUBYLIB/gems/1.8/gems/activerecord-*/lib/active_record.rb

to add "informix" to RAILS_CONNECTION_ADAPTERS:

  RAILS_CONNECTION_ADAPTERS = %w( mysql postgresql sqlite firebird sqlserver db2 oracle sybase openbase informix)

Installation instructions for Ruby on Rails 2.x

  gem install activerecord-informix-adapter

Usage
==========
1. Rails configuration

The adapter has three options: database, username and password. Only database is mandatory. A sample database.yml file would look like this:

  development:
    adapter: informix
    database: dbname@dbserver
    username: santana
    password: secret

If no username and password are specified, the user running the web server is used.

2. Informix configuration

* You must have a sequence for each table in the form #{tablename}_seq.

Example:

      create table customers(id serial, name varchar(40));
      create sequence customers_seq;

* BYTE/TEXT columns must allow NULLs.


3. Caveats

* Prefer Informix 10 or above over Informix 9. Rails/Informix makes use of the SKIP option for pagination, which is only available since Informix 10.

There is currently no advanced documentation for this plugin.