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

Pat Maddox wrote:
> 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.
>
>   
yep - was just meant to show a simple usage with stats... but, since i'm 
interested anyway...

Different machine - athlon 2500, 512MB RAM, windows XP -- postgresql 
8.0.3 rather than PostgreSQL 8.1.3 and running ruby from cygwin rather 
than natively....

Runs in 12-13 seconds -- entirely possible that the other box( p4, 
2+ghz, 1GB ram, native ruby ) could drop it down under 10 seconds( or 
even this box, if I took cygwin out of the equation ).

db =Og.setup(og_psql)
t1= Time.now
db.store.start

1.upto(10000)  { |i|
 c = Comment.new
 c.title = 'Hello'
 c.body = 'World'
 c.create_time = Time.now
 c.author = 'tml'
 c.save
}

db.store.commit
puts  Time.now - t1