From: "Ara.T.Howard" <ahoward@...>
Date: 2004-07-15T06:02:21+09:00
Subject: Re: Newbie: Pointers for Ruby compatible DBase engine

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
===============================================================================