The JRuby-extras project is proud to announce the release of version 0.2 of ActiveRecord-JDBC. This release brings much needed functionality and usability. Since 0.0.1, the project have gone from proof-of-concept to something that''s actually usable. ActiveRecord-JDBC now supports migrations and connections with 8 databases: MySQL, PostgreSQL, Oracle, MS SQL Server, DB2, Derby, FireBird and HSQLDB. Most of the standard functionality in ActiveRecord works with these databases, and Migrations are also there except for those cases when the database cannot support the operation. The release can be installed as a gem with: jruby gem install ActiveRecord-JDBC --no-rdoc --no-ri JRuby-extras: http://rubyforge.org/projects/jruby-extras/ -- Ola Bini (http://ola-bini.blogspot.com) JvYAML, RbYAML, JRuby and Jatha contributor System Developer, Karolinska Institutet (http://www.ki.se) OLogix Consulting (http://www.ologix.com) "Yields falsehood when quined" yields falsehood when quined.
Very cool. Question - for those of us on Unix based OSs like MacOS X, what is the best way to connect to SQL Server for Rails apps? I''ve got a system setup to use ODBC but this seems like a simpler alternative. Any idea of performance differences between the solutions? H> From: Ola Bini <ola.bini-sX4i5UfIK9o@public.gmane.org> > Organization: Karolinska Institutet > Reply-To: <rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > Date: Wed, 06 Sep 2006 10:56:10 +0200 > To: <jruby-extras-devel-GrnCvJ7WPxnNLxjTenLetw@public.gmane.org>, <dev-vBD6kId06caxIXFVlbCvtR2eb7JE58TQ@public.gmane.org>, > <user-vBD6kId06caxIXFVlbCvtR2eb7JE58TQ@public.gmane.org>, <rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org>, > <ruby-talk-X+L+6nJQZ58h9ZMKESR00Q@public.gmane.org> > Subject: [Rails] [ANN] ActiveRecord-JDBC 0.2 > > > The JRuby-extras project is proud to announce the release of version 0.2 > of ActiveRecord-JDBC. > > This release brings much needed functionality and usability. Since > 0.0.1, the project have gone from proof-of-concept to something that''s > actually usable. > > ActiveRecord-JDBC now supports migrations and connections with 8 > databases: MySQL, PostgreSQL, Oracle, MS SQL Server, DB2, Derby, > FireBird and HSQLDB. > Most of the standard functionality in ActiveRecord works with these > databases, and Migrations are also there except for those cases when the > database cannot support the operation. > > The release can be installed as a gem with: > > jruby gem install ActiveRecord-JDBC --no-rdoc --no-ri > > > JRuby-extras: http://rubyforge.org/projects/jruby-extras/ > > -- > Ola Bini (http://ola-bini.blogspot.com) > JvYAML, RbYAML, JRuby and Jatha contributor > System Developer, Karolinska Institutet (http://www.ki.se) > OLogix Consulting (http://www.ologix.com) > > "Yields falsehood when quined" yields falsehood when quined. > > > >--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
On 9/6/06, HH <lists-HAWAbpnI61OZ1JSuHaJ1sQC/G2K4zDHf@public.gmane.org> wrote:> > Very cool. > > Question - for those of us on Unix based OSs like MacOS X, what is the best > way to connect to SQL Server for Rails apps? > > I''ve got a system setup to use ODBC but this seems like a simpler > alternative. > > Any idea of performance differences between the solutions?If you''re on a platform that doesn''t support ODBC very well (basically anything non-Windows) the Rails + ActiveRecord-JDBC + SQL Server JDBC driver should always work without much fuss. It''s the same code everywhere, so it will work on any platform where Java''s supported. We haven''t done much benchmarking, but it breaks down like this: JRuby is still about twice as slow as Ruby for pure interpreted code (sometimes more in odd cases), but database access over JDBC should be as fast or faster than anything C-based (as the existing Rails adapters are). Database IO speed is a strong point for Java, so it helps to offset remaining performance issues in JRuby. -- Contribute to RubySpec! @ www.headius.com/rubyspec Charles Oliver Nutter @ headius.blogspot.com Ruby User @ ruby.mn --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
HH wrote:> Very cool. > > Question - for those of us on Unix based OSs like MacOS X, what is the best > way to connect to SQL Server for Rails apps? > > I''ve got a system setup to use ODBC but this seems like a simpler > alternative. > > Any idea of performance differences between the solutions? > > H >Well, either you could use an ODBC solution (that''s the way AWDwR shows how to do it) or you use JRuby. Those are really your only options. -- Ola Bini (http://ola-bini.blogspot.com) JvYAML, RbYAML, JRuby and Jatha contributor System Developer, Karolinska Institutet (http://www.ki.se) OLogix Consulting (http://www.ologix.com) "Yields falsehood when quined" yields falsehood when quined. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
Yeah, as I stated in the message, we have ODBC setup and it works. The setup is a pain and the tools aren''t great so I thought I would ask if this was a better solution. Sounds like there''s still some overhead but it is great to have options.> From: Ola Bini <ola.bini-sX4i5UfIK9o@public.gmane.org> > Organization: Karolinska Institutet > Reply-To: <rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > Date: Wed, 06 Sep 2006 21:58:02 +0200 > To: <rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > Subject: [Rails] Re: [ANN] ActiveRecord-JDBC 0.2 > > > HH wrote: >> Very cool. >> >> Question - for those of us on Unix based OSs like MacOS X, what is the best >> way to connect to SQL Server for Rails apps? >> >> I''ve got a system setup to use ODBC but this seems like a simpler >> alternative. >> >> Any idea of performance differences between the solutions? >> >> H >> > > Well, either you could use an ODBC solution (that''s the way AWDwR shows > how to do it) or you use JRuby. Those are really your only options. > > -- > Ola Bini (http://ola-bini.blogspot.com) > JvYAML, RbYAML, JRuby and Jatha contributor > System Developer, Karolinska Institutet (http://www.ki.se) > OLogix Consulting (http://www.ologix.com) > > "Yields falsehood when quined" yields falsehood when quined. > > > >--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
How would one go about converting to jdbc in rails? What would the database.yml need to look like once the gem has been installed? On 9/6/06, HH <lists-HAWAbpnI61OZ1JSuHaJ1sQC/G2K4zDHf@public.gmane.org> wrote:> > Yeah, as I stated in the message, we have ODBC setup and it works. The setup > is a pain and the tools aren''t great so I thought I would ask if this was a > better solution. Sounds like there''s still some overhead but it is great to > have options. > > > > From: Ola Bini <ola.bini-sX4i5UfIK9o@public.gmane.org> > > Organization: Karolinska Institutet > > Reply-To: <rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > > Date: Wed, 06 Sep 2006 21:58:02 +0200 > > To: <rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > > Subject: [Rails] Re: [ANN] ActiveRecord-JDBC 0.2 > > > > > > HH wrote: > >> Very cool. > >> > >> Question - for those of us on Unix based OSs like MacOS X, what is the best > >> way to connect to SQL Server for Rails apps? > >> > >> I''ve got a system setup to use ODBC but this seems like a simpler > >> alternative. > >> > >> Any idea of performance differences between the solutions? > >> > >> H > >> > > > > Well, either you could use an ODBC solution (that''s the way AWDwR shows > > how to do it) or you use JRuby. Those are really your only options. > > > > -- > > Ola Bini (http://ola-bini.blogspot.com) > > JvYAML, RbYAML, JRuby and Jatha contributor > > System Developer, Karolinska Institutet (http://www.ki.se) > > OLogix Consulting (http://www.ologix.com) > > > > "Yields falsehood when quined" yields falsehood when quined. > > > > > > > > > > > > >--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
Ola and I have pretty good walkthroughs on our blogs: http://ola-bini.blogspot.com/2006/09/activerecord-jdbc-020.html http://headius.blogspot.com/2006/09/activerecord-jdbc-021-released.html On 9/6/06, x1 <caldridge-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > How would one go about converting to jdbc in rails? What would the > database.yml need to look like once the gem has been installed? > > On 9/6/06, HH <lists-HAWAbpnI61OZ1JSuHaJ1sQC/G2K4zDHf@public.gmane.org> wrote: > > > > Yeah, as I stated in the message, we have ODBC setup and it works. The setup > > is a pain and the tools aren''t great so I thought I would ask if this was a > > better solution. Sounds like there''s still some overhead but it is great to > > have options. > > > > > > > From: Ola Bini <ola.bini-sX4i5UfIK9o@public.gmane.org> > > > Organization: Karolinska Institutet > > > Reply-To: <rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > > > Date: Wed, 06 Sep 2006 21:58:02 +0200 > > > To: <rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > > > Subject: [Rails] Re: [ANN] ActiveRecord-JDBC 0.2 > > > > > > > > > HH wrote: > > >> Very cool. > > >> > > >> Question - for those of us on Unix based OSs like MacOS X, what is the best > > >> way to connect to SQL Server for Rails apps? > > >> > > >> I''ve got a system setup to use ODBC but this seems like a simpler > > >> alternative. > > >> > > >> Any idea of performance differences between the solutions? > > >> > > >> H > > >> > > > > > > Well, either you could use an ODBC solution (that''s the way AWDwR shows > > > how to do it) or you use JRuby. Those are really your only options. > > > > > > -- > > > Ola Bini (http://ola-bini.blogspot.com) > > > JvYAML, RbYAML, JRuby and Jatha contributor > > > System Developer, Karolinska Institutet (http://www.ki.se) > > > OLogix Consulting (http://www.ologix.com) > > > > > > "Yields falsehood when quined" yields falsehood when quined. > > > > > > > > > > > > > > > > > > > > > > > > >-- Contribute to RubySpec! @ www.headius.com/rubyspec Charles Oliver Nutter @ headius.blogspot.com Ruby User @ ruby.mn --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---