Anyone following along on the Trac timeline will know that the SQL Server adapter has been receiving a lot of love lately from Tom Ward and Ryan Tomayko. So much love in fact that it now supports migrations and pass all but a single test! That''s pretty impressive. Kudos to both of them. High fives should also go out to Maik Schmidt for keeping the DB2 on its game. It doesn''t support migrations just yet, but its still receiving love. Now this brings me to the main point of the post: We need the same kind of affection for the Oracle adapter. It would be very nice indeed to see it support migrations. And at least, we need to make sure that its still in top form for 1.0 on all other fronts. So consider this a plea for help. If you''re using the Oracle adapter, please give it a spin and a tune-up. Is it the best it could be? Could we get migration support going before 1.0? I hope so. -- David Heinemeier Hansson http://www.loudthinking.com -- Broadcasting Brain http://www.basecamphq.com -- Online project management http://www.backpackit.com -- Personal information manager http://www.rubyonrails.com -- Web-application framework
Yay for Tom! He does work hard at those tests; sometimes they need some seriously tough love. Or at least I presume that''s what those noises I hear from across the desk are... On 10/28/05, David Heinemeier Hansson <david.heinemeier-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > Anyone following along on the Trac timeline will know that the SQL > Server adapter has been receiving a lot of love lately from Tom Ward > and Ryan Tomayko. So much love in fact that it now supports migrations > and pass all but a single test! That''s pretty impressive. Kudos to > both of them. > > High fives should also go out to Maik Schmidt for keeping the DB2 on > its game. It doesn''t support migrations just yet, but its still > receiving love. > > Now this brings me to the main point of the post: We need the same > kind of affection for the Oracle adapter. It would be very nice indeed > to see it support migrations. And at least, we need to make sure that > its still in top form for 1.0 on all other fronts. > > So consider this a plea for help. If you''re using the Oracle adapter, > please give it a spin and a tune-up. Is it the best it could be? Could > we get migration support going before 1.0? I hope so. > -- > David Heinemeier Hansson > http://www.loudthinking.com -- Broadcasting Brain > http://www.basecamphq.com -- Online project management > http://www.backpackit.com -- Personal information manager > http://www.rubyonrails.com -- Web-application framework > _______________________________________________ > 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
How about the Firebird adapter David? There''s on already working at the wiki is uses (fireruby gem). On 10/28/05, David Heinemeier Hansson <david.heinemeier-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > Anyone following along on the Trac timeline will know that the SQL > Server adapter has been receiving a lot of love lately from Tom Ward > and Ryan Tomayko. So much love in fact that it now supports migrations > and pass all but a single test! That''s pretty impressive. Kudos to > both of them. > > High fives should also go out to Maik Schmidt for keeping the DB2 on > its game. It doesn''t support migrations just yet, but its still > receiving love. > > Now this brings me to the main point of the post: We need the same > kind of affection for the Oracle adapter. It would be very nice indeed > to see it support migrations. And at least, we need to make sure that > its still in top form for 1.0 on all other fronts. > > So consider this a plea for help. If you''re using the Oracle adapter, > please give it a spin and a tune-up. Is it the best it could be? Could > we get migration support going before 1.0? I hope so. > -- > David Heinemeier Hansson > http://www.loudthinking.com -- Broadcasting Brain > http://www.basecamphq.com -- Online project management > http://www.backpackit.com -- Personal information manager > http://www.rubyonrails.com -- Web-application framework > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >-- ------------------------------- Jorge Sousa _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails
> How about the Firebird adapter David? There''s on already working at the wiki > is uses (fireruby gem).That one would be great too. I hear that the author is working on getting it updated for the latest. And to implement migrations. Looking forward to that. -- David Heinemeier Hansson http://www.loudthinking.com -- Broadcasting Brain http://www.basecamphq.com -- Online project management http://www.backpackit.com -- Personal information manager http://www.rubyonrails.com -- Web-application framework
David, I have many years or oracle experience, not so much ruby experience, however if there were a place with some kind of outline with what needs to be done, I could start taking a look at things. Is there a "We need this" and "here is the adapter code" type of doc. Is it just the stuff from rails or the ruby oracle gem? Sam On 10/28/05, David Heinemeier Hansson <david.heinemeier-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Anyone following along on the Trac timeline will know that the SQL > Server adapter has been receiving a lot of love lately from Tom Ward > and Ryan Tomayko. So much love in fact that it now supports migrations > and pass all but a single test! That''s pretty impressive. Kudos to > both of them. > > High fives should also go out to Maik Schmidt for keeping the DB2 on > its game. It doesn''t support migrations just yet, but its still > receiving love. > > Now this brings me to the main point of the post: We need the same > kind of affection for the Oracle adapter. It would be very nice indeed > to see it support migrations. And at least, we need to make sure that > its still in top form for 1.0 on all other fronts. > > So consider this a plea for help. If you''re using the Oracle adapter, > please give it a spin and a tune-up. Is it the best it could be? Could > we get migration support going before 1.0? I hope so. > -- > David Heinemeier Hansson > http://www.loudthinking.com -- Broadcasting Brain > http://www.basecamphq.com -- Online project management > http://www.backpackit.com -- Personal information manager > http://www.rubyonrails.com -- Web-application framework > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >
David Heinemeier Hansson wrote:> Anyone following along on the Trac timeline will know that the SQL > Server adapter has been receiving a lot of love lately from Tom Ward > and Ryan Tomayko. So much love in fact that it now supports migrations > and pass all but a single test! That''s pretty impressive. Kudos to > both of them.Hey, I''ve been giving it some good lovin''.> Now this brings me to the main point of the post: We need the same > kind of affection for the Oracle adapter. It would be very nice indeed > to see it support migrations. And at least, we need to make sure that > its still in top form for 1.0 on all other fronts.W/ the patch you accepted last week, it''s actually fairly close to supporting migrations. Jason Wong and I were just talking about this point -- he may be using Oracle on an upcoming job, and was hoping for Migrations. I''ll take a crack at it this weekend. Oh, and it already passes all tests.
> W/ the patch you accepted last week, it''s actually fairly close to > supporting migrations. Jason Wong and I were just talking about this > point -- he may be using Oracle on an upcoming job, and was hoping for > Migrations. > > I''ll take a crack at it this weekend. > > Oh, and it already passes all tests.Oh, that''s fantastic. I hate being in the dark about these things. We so need to get a Oracle database setup that the Rails server can run unit tests against. I''m glad to hear that its in better shape than I thought. One problem I do remember: Eager loading. Especially with habtm and has_many collections. Do you know if this works already? Migration support for Oracle in 1.0 would be great. Please do attempt a shot at that. Thanks! -- David Heinemeier Hansson http://www.loudthinking.com -- Broadcasting Brain http://www.basecamphq.com -- Online project management http://www.backpackit.com -- Personal information manager http://www.rubyonrails.com -- Web-application framework
Feel the love. http://dev.rubyonrails.com/ticket/2647 David Heinemeier Hansson wrote:> One problem I do remember: Eager loading. Especially with habtm and > has_many collections. Do you know if this works already?Do you know specifically what wasn''t working? The test coverage in this area seems pretty good, and it passes all the tests.
I finished updating the Firebird adapter about a week ago. I was hoping to get Migrations implemented before submitting an updated patch, but that has turned out to be trickier than I expected for Firebird. So I''ll go ahead and post an update later tonight (sans Migrations). I''m not giving up on getting Migrations working though. Hopefully within another week, time permitting. I''m also looking into getting the FireRuby extension compiled for FreeBSD so it can run on the Rails test server. Let me know if there are any other questions regarding the Firebird adapter. Cheers, Ken On 10/28/05, David Heinemeier Hansson <david.heinemeier-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > How about the Firebird adapter David? There''s on already working at the wiki > > is uses (fireruby gem). > > That one would be great too. I hear that the author is working on > getting it updated for the latest. And to implement migrations. > Looking forward to that. > -- > David Heinemeier Hansson > http://www.loudthinking.com -- Broadcasting Brain > http://www.basecamphq.com -- Online project management > http://www.backpackit.com -- Personal information manager > http://www.rubyonrails.com -- Web-application framework > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >
On 10/28/05, David Heinemeier Hansson <david.heinemeier-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> We so need to get a Oracle database setup that the Rails server can run > unit tests against.This looks interesting along those lines: http://rubyurl.com/7iz [http://news.com.com/Oracle+to+offer+free+database/2100-1012_3-5920796.html?part=rss&tag=5920796&subj=news] Haven''t tried it out, but it looks like it could make Oracle support much easier for open-source projects. -- Nathaniel Talbott <:((><
On Tue, 2005-11-01 at 09:51 -0500, Nathaniel Talbott wrote:> On 10/28/05, David Heinemeier Hansson <david.heinemeier-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > We so need to get a Oracle database setup that the Rails server can run > > unit tests against. > > This looks interesting along those lines: > > http://rubyurl.com/7iz > [http://news.com.com/Oracle+to+offer+free+database/2100-1012_3-5920796.html?part=rss&tag=5920796&subj=news] > > Haven''t tried it out, but it looks like it could make Oracle support > much easier for open-source projects.Except that no one will be able to host it on any good servers. 1GB of RAM limit... I know people who have more RAM on their laptops. ;-) *yawn* -Robby -- /****************************************************** * Robby Russell, Owner.Developer.Geek * PLANET ARGON, Open Source Solutions & Web Hosting * Portland, Oregon | p: 503.351.4730 | f: 815.642.4068 * www.planetargon.com | www.robbyonrails.com * Programming Rails | www.programmingrails.com *******************************************************/
That''s 1GB of RAM to the database - not the amount of RAM on the machine. The other big limit is 4GB of user data. These limits do make it less viable for real apps, sure, but it is a nice tool for Oracle developers. One big constraint I''ve always found to using Oracle for a development system has always been the standard Oracle install process which is a big PIA on many systems (especially Linux). Oracle XE takes care of that nicely with an RPM install for Linux and what looks to be a quick install for Windows. The suite of web-based tools that come with it are also quite nicely done and include a nice set of GUI tools for system monitoring and tuning - like autotrace. Right now, I''m having some amount of trouble getting Ruby to connect to the database. I''ve been trying the same configuration that works with the Oracle instant client to connect to my other Oracle databases, but without much success. Hopefully I can get past this today. --Glenn On 11/2/05, Robby Russell <robby-/Lcn8Y7Ot69QmPsQ1CNsNQ@public.gmane.org> wrote:> > On Tue, 2005-11-01 at 09:51 -0500, Nathaniel Talbott wrote: > > On 10/28/05, David Heinemeier Hansson <david.heinemeier-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> > wrote: > > > > > We so need to get a Oracle database setup that the Rails server can > run > > > unit tests against. > > > > This looks interesting along those lines: > > > > http://rubyurl.com/7iz > > [ > http://news.com.com/Oracle+to+offer+free+database/2100-1012_3-5920796.html?part=rss&tag=5920796&subj=news > ] > > > > Haven''t tried it out, but it looks like it could make Oracle support > > much easier for open-source projects. > > Except that no one will be able to host it on any good servers. > > 1GB of RAM limit... I know people who have more RAM on their > laptops. ;-) > > *yawn* > > -Robby > > -- > /****************************************************** > * Robby Russell, Owner.Developer.Geek > * PLANET ARGON, Open Source Solutions & Web Hosting > * Portland, Oregon | p: 503.351.4730 | f: 815.642.4068 > * www.planetargon.com <http://www.planetargon.com> | www.robbyonrails.com<http://www.robbyonrails.com> > * Programming Rails | www.programmingrails.com<http://www.programmingrails.com> > *******************************************************/ > > _______________________________________________ > 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