Subject Re: [firebird-tools] Re: Firebird and Ruby on Rails
Author floater
Hi,

I had to have a look at what you mentioned. Spent a several hours looking
around at datamapper. Looks striaght forward, like wise Merb. Quite
impressed by the git based repositories. here is me using svn.

msvcrt well i tend to avoid that. Why compile when the is something
already that works.
fbclient.dll - dll/lib versions, they are versioned/numbered and they can
be checked against. we do that. Each release has its version. I just try
and make sure I have the lastest for the database version series for an
install. Failing that, i have found slightly out of date dll/lib work
well. You can guess, that all i care for is for stuff to work - if badly
at first. I have been running fb 2.1.x against 1.5.x databases (even an
1.5 rc11 version) and not found an issue.
If someone wants to use the adapter on windows. they will probably have
fbclient.dll. just need to allow where its loaded from to be set. Kind of
like vlad and co on the main FB forum, where i feel the is a certain
impatience with msvcrt versions.

I have a fb database system at work, I would like to add on a web front
end to it, in ruby. simple at first.

The name length being 31 did not bother me, I have used Oracle 6,7,8. Just
that the existing adapter failed on it. I mailed its author three days
ago, no reply.

So I am happy to help on this, but at a slow pace. I have used ruby off
and on for a decade, just not enough and I have do not have much time.
Oh, as for datamapper, very good, probably better than active record in
long term. Merb, well, okay, but I know rails having watched it grow from
0.3 (when i knew it well)

I am going to have a long look at fireruby over the weekend. if it uses
fbclient, then good, otherwise well ?

alex.


On Wed, 10 Sep 2008 12:36:38 +0100, Zedalaye <zedalaye@...> wrote:

> Alexc,
>
>> I am tempted to fill in the missing bits of this existing adapter, as I
> find them as I would like
>> to use rails for a new system but access an existing firebird db.
>
> I don't know what is the best way to improve Firebird support in Ruby
> and Rails.
>
> The official Firebird adapter for Rails is not maintained and the
> unofficial (fb_lib_adapter) miss support for ActiveRecord migrations,
> Firebird connectors (fireruby and fb_lib) are hard to deploy on Windows
> because they are not updated to use the right msvcrt version.
>
> I think we should rewrite an official Firebird connector in pure ruby
> and maintain the official ActiveRecord adapter. But I also think that
> Firebird should provide a Sequel Adapter and a Datamapper Adapter, two
> ORM useable with Merb and other Rails competitors.
>
> The 31 char identifier limitation is also a problem we should handle in
> ORM adapters to allow rails users to switch to Firebird backend without
> changing their code. For instance, when you add a reference to another
> model with has_one, has_many, belongs_to or has_and_belongs_to_many,
> ActiveRecord automatically use fields for foreign keys that may be
> longer than 31 chars so these foreign key fields declarations have to be
> manually overloaded to fit in Firebird bounds.
>
> Regards,
>