Rails - Apr 2005 - Sybase adapter status?

There''s been some talk previously on the list about a Sybase adapter,
but nothing conclusive.

Does anyone know what the status of this is?

I want to introduce some smaller Rails app to one of our clients that
have standardized on Sybase. Without a Sybase adapter it''s just not
going to fly.

I''m willing to spend some time on this if no one else is actively
working on it. What''s involved in creating an adapter? What kind of
time do I need to commit? I think I want to go down the ODBC route, so
appreciate any pointers regarding the ODBC<->Ruby story. Also somebody
mentioned they had a read-only adapter, that would be a great place
for me to start. I prefer to write as little C as possible, I''ve been
in GC land for too long that I don''t know if I would survive going
back out into the wild.

Cheers,
Jon

Hi,

I''ve been looking into building an odbc adapter too, but got stuck due 
to a few issues that need to be changed in the underlying ActiveRecord 
Base and/or AbstractAdapter code, especially escaping/quoting of 
variables in sql queries. For the rest, a lot depends on how well the 
sybase odbc driver behaves, and how much of the odbc functionality has 
actually been implemented in that driver.

Erich Ocean wrote this about the problem:

Hi. I''m working on the Frontbase adaptor and have run into similar 
problems. IMO ActiveRecord needs an overhaul to address not only that 
shortcoming, but a number of others. I am hoping to be able to start on 
a rewrite by the end of this month, possibly sooner. That doesn''t 
address your immediate needs, but I did want to let you know that AR 
will be getting a much-needed overhaul in the near future.

I have more experience with DB layers than DHH, and we''ve already 
discussed a number of the changes I want/need to make, and he''s been 
supportive. I''ve just needed to find the time to do it!

Best, Erich

So maybe it''s a good idea to wait for his changes (or help him a hand
to
get it done if you need it faster :-) )

best regards,
Bas




Jon Tirsen wrote:
> There''s been some talk previously on the list about a Sybase
adapter,
> but nothing conclusive.
> 
> Does anyone know what the status of this is?
> 
> I want to introduce some smaller Rails app to one of our clients that
> have standardized on Sybase. Without a Sybase adapter it''s just
not
> going to fly.
> 
> I''m willing to spend some time on this if no one else is actively
> working on it. What''s involved in creating an adapter? What kind
of
> time do I need to commit? I think I want to go down the ODBC route, so
> appreciate any pointers regarding the ODBC<->Ruby story. Also
somebody
> mentioned they had a read-only adapter, that would be a great place
> for me to start. I prefer to write as little C as possible, I''ve
been
> in GC land for too long that I don''t know if I would survive going
> back out into the wild.
> 
> Cheers,
> Jon
> _______________________________________________
> Rails mailing list
> Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
> http://lists.rubyonrails.org/mailman/listinfo/rails