Database choices?

[Mark Probert]

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

TIA,

 

[Ken Kunz]

Mark,

I have been using the FireRuby bindings for Firebird for several months
now, and I've been quite pleased:
http://rubyforge.org/projects/fireruby/

What I like:
- has a richer, more complete API compared to the older Interbase
bindings
- well documented
- actively developed and supported
- published as a gem

Possible gotchas:
- Limited BLOB support (not an issue for me)
- Not very mature, so API may still be in flux

BTW... I recently posted a Rails Firebird adapter that uses the
FireRuby extension:
http://dev.rubyonrails.com/ticket/1874

Cheers,
Ken

 

[Ken Kunz]

Mark,

Forgot to mention... FireRuby has been compiled for Linux, but not for
the other platforms you mentioned. Peter Wood (the FireRuby
author/maintainer) helped me get the Linux build working (required a
couple of small changes to extconf.rb). I bet it would be pretty
straightforward to build for FreeBSD & Solaris.

Ken

 

[Lyndon Samson]

------=_Part_3188_23522685.1123248577685
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Postges is great ( Stored Procs in Python/Ruby/Perl/Java? ), but for your=
=20
requirements it appears SQLite is worth investigating.

It's not inherently multi-user/network of course, which may be a requiremen=
t=20
for you.

--=20
Into RFID? www.rfidnewsupdate.com <http://www.rfidnewsupdate.com> Simple,=
=20
fast, news.

------=_Part_3188_23522685.1123248577685--

 

[Tom Copeland]

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