From: Randy Lawrence <jm@...>
Date: 2004-07-15T08:08:38+09:00
Subject: Re: Newbie: Pointers for Ruby compatible DBase engine

Ara.T.Howard wrote:

> On Wed, 14 Jul 2004, Xeon wrote:
> 
>> Hi,
>>
>> Can anyone suggest/direct me to a dbase engine which are supported by
>> ruby? I'm thinking about a small scale dbase (5,000-10,000 entries)
>> engine/server, single processed, can be searched on various rules (SQL
>> compatible would be nice), and most of all, lightweight (have mercy to
>> my ol' P100Mhz), small size (like Ruby), and free (yeah, I'm cheap). I
>> know it's a lot to ask. How is mSQL fare?
>>
>> I have tried mySQL, but it put a lot of strain to my PC (read:
>> P100MHz) for daily use, and I don't use much of it's power. Also, it's
>> size is not so small either.
>>
>> The standard *dbm supported by the STL can only be searched on a
>> single key, at least that I know of, or are there any ways to overcome
>> this limitation?
>>
>> Plz help
>>
>> TIA
> 
> 
> sqlite is good if you need sql - but do you?  if not try pstore (it 
> comes with
> ruby) or madeline (raa).  object storage is just fine about 80% of the 
> time.
> 
>   ~ > cat a.rb
>   require 'pstore'
>   db = PStore.new 'db'
> 
>   time = nil
>   now = Time.now
> 
>   db.transaction do
>     time =
>       if db.root? 'time'
>         db['time']
>       else
>         now
>       end
> 
>     db['time'] = Time.now
>   end
> 
>   p time
> 
> 
>   ~ > ruby a.rb && sleep 2 && ruby a.rb && sleep 2 && ruby a.rb
>   Wed Jul 14 14:53:53 MDT 2004
>   Wed Jul 14 14:53:58 MDT 2004
>   Wed Jul 14 14:54:00 MDT 2004
> 
> i have pstores with 100000 entries and they are just fine.
> 
> -a
> -- 
> =============================================================================== 
> 
> | EMAIL   :: Ara [dot] T [dot] Howard [at] noaa [dot] gov
> | PHONE   :: 303.497.6469
> | A flower falls, even though we love it;
> | and a weed grows, even though we do not love it. |   --Dogen
> =============================================================================== 
> 

Fascinating stuff!  Do you recommend pstore or madeline?

Is this "production-ready" based on your experiences?

Thanks for the tip.