From: "Marcin Mielżyński" <lopx@...>
Date: 2006-07-14T07:55:12+09:00
Subject: Re: ActiveRecord alternatives

Philip Hallstrom wrote:
>> On Fri, 14 Jul 2006 00:00:17 +0200, elriba <edgard.riba@gmail.com> wrote:
>>
>>> Hi,
>>> I have a database application running under sybase anywhere SQL server.
>>>  I would like to develop modules in Ruby to access that database.
>>>
>>> I started to look at ActiveRecord, but it seems that one requirement is
>>> that all tables have an identity column with a specific name.    My
>>> database was not designed that way :-(
>>
>> I don't think ActiveRecord is that stupid (but I've never tried it).
>> I think there must be a way to trick it into doing that.
> 
> set_primary_key()

You can override table names and names of all your columns. There are 
few things AR doesn't allow (compound primary and foreign keys notably)

There is another orm http://jutopia.tirsen.com/articles/tag/rbatis that 
will allow you to create much more flexible mappings.

lopex