Oracle+Ruby on Rails: Yummy

Oracle Database XE + Ruby on Rails is an increasingly tasty combination. A whole slew of new content re: this combo is forthcoming from OTN, with the first being the "Oracle+Ruby on Rails FAQ" - an excellent introduction.

Look for future articles about the Active Record persistence engine - of particular interest to those developing RoR apps on top of Oracle - as well as the use of Ruby scripts in conjunction with Oracle.

Add to recent articles such as "Ruby on Rails on Oracle: A Simple Tutorial" and "HR Schema on Rails", and we have the makings of a new Developer Center on OTN (coming in 2007).

Comments:

Justin, this is great news. People have been asking for this type of content, and I'm so pleased it's starting to come together. Now I can point them somewhere. Top stuff.

Posted by Alison Holloway on December 12, 2006 at 08:13 AM PST #

Great! DHH even picked up the news over at weblog.rubyonrails.org. Any idea when David and the rest of us with Intel Macs can start doing Oracle+Rails development on our machines? OS X for Intel has been out for almost a year now, and the Oracle 10g client is still PowerPC only.

Posted by Jesper Hvirring on December 14, 2006 at 10:01 PM PST #

Is anyone at Oracle putting any effort into improving the Ruby DBI driver for Oracle? The couple times I've tried putting Rails on top of an Oracle DB, it's painful how slow the app runs. We're talking just one select off 2 tables with one join.

Posted by Erik on December 14, 2006 at 11:26 PM PST #

I've been using Oracle/Rails for a year. Works fine. Very fast on our production server Linux/OracleXE environment. Too bad we can't run Oracle in development on our Intel Macs. We have to use MySQL, or use a Locomotive PowerPC bundle I constructed using the Oracle 10g InstantClient for PPC. Rosetta is grizzly slow, though. Intel Mac binaries for the InstantClient are required if you want to attract Rails developers to Oracle.

Posted by Lori M Olson on December 14, 2006 at 11:45 PM PST #

I will check with product management about these questions and get back to you guys!

Posted by Justin Kestelyn on December 14, 2006 at 11:57 PM PST #

Justin, do you know of a group working actively on ActiveRecord support for Oracle? How can I contact them? We've been using Rails+Oracle for a while and have come across a minor issue worth fixing. We have a patche proposal ready, but so far I haven't been able to contact someone who wants to pick up the topic (function-based indexes and generation of the schema.rb leading to problems when running tests in Rails).

Posted by Andreas Gungl on December 17, 2006 at 10:29 AM PST #

Re: Oracle 10g Client for OS X/Intel - apparently we have received several requests for this port and it is "under consideration". I don't have a date or any other info at the moment but will follow up.

Posted by Oracle Blogs on December 17, 2006 at 06:30 PM PST #

RE: support for active record on Oracle, I think you can look for Michael Schoen on the Rails core google group, he is doing most of the work on ActiveRecord for Oracle. Besides this it is nice to see more interest for Rails on Oracle. I did a presentation at the last Oracle User's Group conference in Italy about rails and had very good feedbacks from the audience. You can find my slides (in italian) here: http://ita.spazidigitali.com/wp-content/uploads/2006/12/OUGIT_2006.pdf

Posted by Luca Mearelli on December 18, 2006 at 09:57 AM PST #

Oracle needs to sort out the Rails non-use of bind variables very, very soon - or at least contribute resources to the engineering solution for that serious problem. Non-use of bind variables is the weak under-belly of Rails/Oracle. See http://www.ruby-forum.com/topic/86831 and Google 'oracle rails bind variables' for more.

Posted by Greg Clarke on December 26, 2006 at 03:07 AM PST #

I'm more than willing to be Oracle's contact point for Ruby and Ruby on Rails. While Oracle can play a part, Ruby and RoR are open source so your contributions have as much, if not more, significance.

Posted by Christopher Jones on January 02, 2007 at 03:45 AM PST #

Post a Comment:
  • HTML Syntax: NOT allowed