From: Pat Maddox <pergesu@...>
Date: 2006-03-26T11:11:32+09:00
Subject: Re: Best Database For Ruby

On 3/25/06, Reid Thompson <reid.thompson@ateb.com> wrote:
> Butternut squash wrote:
> > I want to learn DB and SQL using Ruby
> >
> > Project is not too big. Probably need 30 tables
> >
> > Everyone at work tells me MySQL is the best... I used to use Informix a long
> > time ago. It doesn't look like I can get this for linux.
> >
> > thanks in advance.
> >
> >
> PostgreSQL www.postgresql.org
>
> #for ruby db interaction....
> gem install postgres
> gem install postgres-pr
> # http://nitrohq.com  http://www.nitrohq.com/view/Og
> gem install nitro -y
>
>
> PostgreSQL and Og work very well...
>
> simple example -- playing around with ruby and postgresql on win XP..
> 10000 inserts in ~54 seconds ( pentium 4, 2+ghz, 1GB ram )
>
> ogtest.rb
> --------------------
> require 'og'
>
> class Comment
>    property :title, String
>    property :body, String
>    property :author, String
>    property :create_time, Time
> end
>
> og_psql = {
>  :destroy => false,
>  :store => :psql,
>  :user => 'rthompso',
>  :password => 'rthompso',
>  :name => 'testog'
> }
>
> Og.setup(og_psql)
>
> puts Time.now
> # save the object in the database
> 1.upto(10000)  { |i|
>  c = Comment.new
>  c.title = 'Hello'
>  c.body = 'World'
>  c.create_time = Time.now
>  c.author = 'tml'
>  c.save
> }
> puts Time.now
>
>
>
>

I've never used og, but I suspect that'd drop to < 10s if you wrapped
it all in a transaction.