From: Reid Thompson <reid.thompson@...>
Date: 2006-03-26T09:03:00+09:00
Subject: Re: Best Database For Ruby

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