From: Tom Copeland <tom@...>
Date: 2005-08-05T23:35:28+09:00
Subject: Re: Database choices?

On Fri, 2005-08-05 at 04:36 +0900, Mark Probert wrote:
> Hi ..
> 
> Part of the project I am embarking upon will require an SQL database.
> My personal favourites are Firebird and SQLite, however I am not going
> to rule out either MySQL or Postgres.  However, given that I am a stored
> procedure fan, my focus is on Firebird.  
> 
> I was wondering if anyone has any comments on the maturity of the ruby
> database bindings or any other helpful insights.  As some basic
> parameters:
> 
>  Data storage: small-moderate (~100Mb)
>  Updates:      approx 5min intervals
>  Users:        small (10-15 conns)
>  Interface:    web + scripts (pref via stored procs)
>  Platform:     Linux / FreeBSD / Solaris / HTML clients

I've been using PostgreSQL 8.0, with the postgres-pr pure ruby driver,
on FC3, accessed via Rails/XML-RPC and FastCGI.  Seems to be working
pretty well so far, although I'm just in test mode...

Yours,

Tom