= Rails/Informix -- ActiveRecord adapter for Informix

== Motivation

The situation that started it all [link][http://santanatechnotes.blogspot.com/2006/03/informix-adapter-for-ruby-on-rails.html].

== 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.

== 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.

== 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.