Rails - Jan 2005 - =?iso-8859-1?Q?Re:__Sybase_anyone??=

Rob Lally <ruby-TLoEj6T5Eh2QE6UZXBUcsgC/G2K4zDHf@public.gmane.org> schrieb
am 28.01.2005, 13:37:39:
> I noticed on the rubyonrails site that there was mention of desire for a
Sybase version of rails. Is this still a pipe
> dream or is someone driving it?
Currently I''m writing the ActiveRecord for Oracle and I thought of
writing one for Sybase, too. Unfortunately, I do not have the time at
the moment. So, it would be great, if someone else could write the
Sybase adapter. You can find a database driver encapsulating the Sybase
ct library under http://raa.ruby-lang.org/project/sybase-ctlib. It''s
very old ad I do not know, if is still maintained. Maybe you have to
clean it up a bit first. Under
http://wiki.rubyonrails.com/rails/show/HowToWriteAnActiveRecordAdapter
you''ll find a tutorial on writing ActiveRecord adapters. It''s
really
easy and the biggest problem is the generation of primary keys. If you
have any questions do not hesitate to ask me.

Cheers,

Maik

I have been working with Sybase and have a read-only adapter.   I went
the ODBC route because I did not want to deal with the ctlib
(*shudder*).

Drop me a line and I can send you what I have so far.

-Dale


On Fri, 28 Jan 2005 13:54:04 +0100,
contact-CKba8aKGf+ewktNWMKzPnQ@public.gmane.org
<contact-CKba8aKGf+ewktNWMKzPnQ@public.gmane.org>
wrote:
> 
> Rob Lally <ruby-TLoEj6T5Eh2QE6UZXBUcsgC/G2K4zDHf@public.gmane.org>
schrieb am 28.01.2005, 13:37:39:
> > I noticed on the rubyonrails site that there was mention of desire for
a Sybase version of rails. Is this still a pipe
> > dream or is someone driving it?
> Currently I''m writing the ActiveRecord for Oracle and I thought of
> writing one for Sybase, too. Unfortunately, I do not have the time at
> the moment. So, it would be great, if someone else could write the
> Sybase adapter. You can find a database driver encapsulating the Sybase
> ct library under http://raa.ruby-lang.org/project/sybase-ctlib.
It''s
> very old ad I do not know, if is still maintained. Maybe you have to
> clean it up a bit first. Under
> http://wiki.rubyonrails.com/rails/show/HowToWriteAnActiveRecordAdapter
> you''ll find a tutorial on writing ActiveRecord adapters.
It''s really
> easy and the biggest problem is the generation of primary keys. If you
> have any questions do not hesitate to ask me.
> 
> Cheers,
> 
> Maik
> _______________________________________________
> Rails mailing list
> Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
> 

-- 
This is my sig.  Isn''t it cool....

Thank you both for your replies.

At this stage of my railing I would only be able to use something ''out
of the box'' as it were. I hope you don''t mind if
I come back to you in a while when I have some more experience.

Thanks,

R.

Dale K. Hawkins wrote:
> I have been working with Sybase and have a read-only adapter.   I went
> the ODBC route because I did not want to deal with the ctlib
> (*shudder*).
> 
> Drop me a line and I can send you what I have so far.
> 
> -Dale
> 
> 
> On Fri, 28 Jan 2005 13:54:04 +0100,
contact-CKba8aKGf+ewktNWMKzPnQ@public.gmane.org
> <contact-CKba8aKGf+ewktNWMKzPnQ@public.gmane.org> wrote:
> 
>>Rob Lally <ruby-TLoEj6T5Eh2QE6UZXBUcsgC/G2K4zDHf@public.gmane.org>
schrieb am 28.01.2005, 13:37:39:
>>
>>>I noticed on the rubyonrails site that there was mention of desire
for a Sybase version of rails. Is this still a pipe
>>>dream or is someone driving it?
>>
>>Currently I''m writing the ActiveRecord for Oracle and I thought
of
>>writing one for Sybase, too. Unfortunately, I do not have the time at
>>the moment. So, it would be great, if someone else could write the
>>Sybase adapter. You can find a database driver encapsulating the Sybase
>>ct library under http://raa.ruby-lang.org/project/sybase-ctlib.
It''s
>>very old ad I do not know, if is still maintained. Maybe you have to
>>clean it up a bit first. Under
>>http://wiki.rubyonrails.com/rails/show/HowToWriteAnActiveRecordAdapter
>>you''ll find a tutorial on writing ActiveRecord adapters.
It''s really
>>easy and the biggest problem is the generation of primary keys. If you
>>have any questions do not hesitate to ask me.
>>
>>Cheers,
>>
>>Maik
>>_______________________________________________
>>Rails mailing list
>>Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
>>http://lists.rubyonrails.org/mailman/listinfo/rails
>>
> 
> 
>

<contact@...> writes:
> Currently I''m writing the ActiveRecord for Oracle and I thought of
...
> 
> Cheers,
> 
> Maik
So... what''s the status of the Oracle adapter? Any chance of seeing
this anytime
soon? 

Thanks,

Thomas

I too would love sybase support for ActiveRecord..

I looked into sybase-ctlib and my concern is that it''s a wrapper for a 
proprietary/closed driver for sybase..

Wouldn''t an implementation based on FreeTDS work better? Then it would
work
for both Sybase and Microsoft SQL!!

On Friday 28 January 2005 07:54, contact-CKba8aKGf+ewktNWMKzPnQ@public.gmane.org
wrote:
> Rob Lally <ruby-TLoEj6T5Eh2QE6UZXBUcsgC/G2K4zDHf@public.gmane.org>
schrieb am 28.01.2005, 13:37:39:
> > I noticed on the rubyonrails site that there was mention of desire for
a
> > Sybase version of rails. Is this still a pipe dream or is someone
driving
> > it?
>
> Currently I''m writing the ActiveRecord for Oracle and I thought of
> writing one for Sybase, too. Unfortunately, I do not have the time at
> the moment. So, it would be great, if someone else could write the
> Sybase adapter. You can find a database driver encapsulating the Sybase
> ct library under http://raa.ruby-lang.org/project/sybase-ctlib.
It''s
> very old ad I do not know, if is still maintained. Maybe you have to
> clean it up a bit first. Under
> http://wiki.rubyonrails.com/rails/show/HowToWriteAnActiveRecordAdapter
> you''ll find a tutorial on writing ActiveRecord adapters.
It''s really
> easy and the biggest problem is the generation of primary keys. If you
> have any questions do not hesitate to ask me.
>
> Cheers,
>
> Maik
> _______________________________________________
> Rails mailing list
> Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
> http://lists.rubyonrails.org/mailman/listinfo/rails

Thomas Lockney wrote:
><contact@...> writes:
>  
>
>>Currently I''m writing the ActiveRecord for Oracle and I thought
of
>>    
>>
>...
>  
>
>>Cheers,
>>
>>Maik
>>    
>>
>
>So... what''s the status of the Oracle adapter? Any chance of seeing
this anytime
>soon? 
>  
>
Chances are really good. The problem is that I do not have enough time 
currently. A lot of things are already working and many test cases pass. 
Only the generation of primary keys has to be finished. Oracle does not 
offer an auto_increment feature for primary keys and so you have to use 
a separate sequence for each table to simulate this feature. Every time 
you insert a new record into a table you have to ask the according 
sequence for a new primary key. That''s already working, too, but there 
are still some minor issues left. I hope that I''m able to finish it 
during the next two weeks. Of course, I''d appreciate any help.

According to Maik Schmidt:
> offer an auto_increment feature for primary keys and so you have to use 
> a separate sequence for each table to simulate this feature. Every time 
> you insert a new record into a table you have to ask the according 
> sequence for a new primary key. That''s already working, too, but
there
> are still some minor issues left. I hope that I''m able to finish
it
> during the next two weeks. Of course, I''d appreciate any help.
Which protocol do you to connect?  OCI8 or the older one?

Either way I''m interested in testing/coding although I''d
rather have OCI8
:)
-- 
Ollivier ROBERT -=- FreeBSD: The Power to Serve! -=-
roberto-0kjVc+YyuDZX+h8frlqCcVAUjnlXr6A1@public.gmane.org
Darwin snuadh.freenix.org Kernel Version 7.7.0: Sun Nov  7 16:06:51 PST 2004

Ollivier Robert wrote:
>According to Maik Schmidt:
>  
>
>>offer an auto_increment feature for primary keys and so you have to use 
>>a separate sequence for each table to simulate this feature. Every time 
>>you insert a new record into a table you have to ask the according 
>>sequence for a new primary key. That''s already working, too,
but there
>>are still some minor issues left. I hope that I''m able to
finish it
>>during the next two weeks. Of course, I''d appreciate any help.
>>    
>>
>
>Which protocol do you to connect?  OCI8 or the older one?
>
>  
>
The older one, because it''s part of the standard Ruby distribution. As 
far as I can see, it''s no big deal to code the OCI8 version as soon as 
the other one is working.
>Either way I''m interested in testing/coding although I''d
rather have OCI8
>:)
>  
>
Great!

According to Maik Schmidt:
> The older one, because it''s part of the standard Ruby
distribution. As
> far as I can see, it''s no big deal to code the OCI8 version as
soon as
> the other one is working.
Do you have anything to play with?  L''d like to test it as one of my
applications would be much likely to be accepted with an Oracle backend...
-- 
Ollivier ROBERT -=- FreeBSD: The Power to Serve! -=-
roberto-0kjVc+YyuDZX+h8frlqCcVAUjnlXr6A1@public.gmane.org
Darwin snuadh.freenix.org Kernel Version 7.7.0: Sun Nov  7 16:06:51 PST 2004