I saw that there''s a patch in the queue (http://dev.rubyonrails.com/ticket/1874) for a Firebird adapter. Just wondering if anyone is using this, the other Firebird adapter, or something else w/ Rails. My main interest is that sometimes Windows is a target platform, and Firebird is stable on Windows, whereas I''ve heard that the Windows version of PostgreSQL isn''t quite there yet. Anyway, would love to hear of any experiences with Firebird. Thanks! Jen
Jen, I''m the author of the Firebird patch you mentioned (1874). My experience with Firebird in general has been very positive. It has become my rdbms of choice. The key features for me are: - extremely stable (on Linux and Windows) - excellent concurrency - broad ANSI SQL support (transactions, triggers, stored procs, etc.) - minimal admin overhead - ease of db migration, even across platforms (simply copy a single file) But if you''ve used Firebird, you probably know all this already :) As far as using Firebird with Rails... I''ve been working on an application for the past month or so (using the adapter I wrote). So far, everything works great. I know of a few other people who are testing the adapter as well... no issues reported as yet. If you''re interested in testing the adapter, let me know. I can post some instructions on a simplified way to deploy/test the patch (in case you don''t have svn+patch installed on Windows). Cheers, Ken
Ken Kunz wrote: Ken, how are you dealing with case insensitive searchs ? I''ve used Firebird a lot (1.0.3) and in my windows application I''ve created shadow fields that are updated through triggers (before insert, before update) new.name_up = upper(new.name). How do you deal with this issue ? Geraldo Lopes de Souza
Hi, Ken, Ken Kunz wrote:>I''m the author of the Firebird patch you mentioned (1874). > >Thanks for doing the work to get Firebird working with Rails!>If you''re interested in testing the adapter, let me know. I can post >some instructions on a simplified way to deploy/test the patch (in >case you don''t have svn+patch installed on Windows). > >More info would definitely be appreciated! Thanks! Jen
Jen, On 8/12/05, jennyw <jennyw-eRDYlh02QjuxE3qeFv2dE9BPR1lH4CV8@public.gmane.org> wrote:> More info would definitely be appreciated!I posted instructions for testing the adapter to the Rails wiki: http://wiki.rubyonrails.com/rails/show/Firebird+Adapter Let me know if you have any questions or issues. And please share feedback once you''ve had a chance to do some testing. Cheers, Ken
Geraldo, On 8/12/05, Geraldo Lopes de souza <geraldo-lopes-I4oVjbygTnVfyO9Q7EP/yw@public.gmane.org> wrote:> Ken, how are you dealing with case insensitive searchs ? > I''ve used Firebird a lot (1.0.3) and in my windows application I''ve > created shadow fields that are updated through triggers (before insert, > before update)I only have experience with Firebird >= 1.5, so I''m not certain whether my answer applies to earlier versions. Depending on what you''re trying to do... - use the CONTAINING comparison operator - use a case-insensitive collation sequence For more information, I''d suggest referring your question to one of the Firebird discussion groups under Yahoo! Groups. Cheers, Ken
For anyone who may be testing the Firebird adapter... a minor defect was identified in the patch and has been fixed. For more information: http://wiki.rubyonrails.com/rails/show/Firebird+Adapter http://dev.rubyonrails.com/ticket/1874 BTW... has anyone had a chance to test the adapter? Any feedback? Cheers, Ken
Is there a new version of the patch for the new version of rails? (14.3) and/or fireruby (0.4.0)? And I have used it (very littly) but worked well for what i did. no issues at all. Ken Kunz wrote:> For anyone who may be testing the Firebird adapter... a minor defect > was identified in the patch and has been fixed. > > For more information: > http://wiki.rubyonrails.com/rails/show/Firebird+Adapter > http://dev.rubyonrails.com/ticket/1874 > > BTW... has anyone had a chance to test the adapter? Any feedback? > > Cheers, > Ken > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails > >
Is there a new version of the patch for the new version of rails? (14.3) and/or fireruby (0.4.0)? And I have used it (very littly) but worked well for what i did. no issues at all. Ken Kunz wrote:> For anyone who may be testing the Firebird adapter... a minor defect > was identified in the patch and has been fixed. > > For more information: > http://wiki.rubyonrails.com/rails/show/Firebird+Adapter > http://dev.rubyonrails.com/ticket/1874 > > BTW... has anyone had a chance to test the adapter? Any feedback? > > Cheers, > Ken > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails > >
Chris, The Firebird adapter was just added to the Rails core on Nov 16: http://dev.rubyonrails.org/changeset/3052 That means you''ll have to use edge Rails to use it right now. Cody On 11/18/05, Chris Meelhuysen <chris-9Uo8qF64OCnby3iVrkZq2A@public.gmane.org> wrote:> Is there a new version of the patch for the new version of rails? (14.3) > and/or fireruby (0.4.0)? > > And I have used it (very littly) but worked well for what i did. no > issues at all. > > Ken Kunz wrote: > > For anyone who may be testing the Firebird adapter... a minor defect > > was identified in the patch and has been fixed. > > > > For more information: > > http://wiki.rubyonrails.com/rails/show/Firebird+Adapter > > http://dev.rubyonrails.com/ticket/1874 > > > > BTW... has anyone had a chance to test the adapter? Any feedback? > > > > Cheers, > > Ken > > _______________________________________________ > > Rails mailing list > > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > > http://lists.rubyonrails.org/mailman/listinfo/rails > > > > > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >
Chris,> Is there a new version of the patch for the new version of rails? (14.3) > and/or fireruby (0.4.0)?As Cody mentioned, the Firebird adapter has been merged to the trunk, and is available in edge-rails. It will not likely be included in 1.0, but perhaps 1.1. You should be able to use this version with FireRuby 0.4.0 without any problems. I have some additional updates to the adapter that make use of some of the improvements in FireRuby 0.4.0. I''ve also implemented Migrations, as well as the new connection maintenance methods found in the other adapters in edge-rails. I''ll submit these updates soon (perhaps this weekend)... and hopefully they''ll be merged to the trunk relatively quickly. Cheers, Ken