From: ahoward <ahoward@...>
Date: 2003-07-03T14:26:26+09:00
Subject: Re: A Quick Guide to SQLite and Ruby

On Thu, 3 Jul 2003, why the lucky stiff wrote:

> -Talkers:
>
> I've been truly impressed by SQLite, a small database with support for much of
> SQL-92.  This is a swift, ACIDic, customizable database that could be useful
> to a great many Ruby developers.
>
> Looking around RAA, I found a few extensions for using SQLite, but very little
> documentation.  Distilling the SQLite documentation can be a lot to take in
> at once, so I've started to collect my own experience into a quick guide for
> the uninitiated.
>
>   http://whytheluckystiff.net/articles/2003/07/02/aQuickGuideToSQLite
>
> I will continue to add to this page as I experiment.  Thank you.

very cool.  i used the package a bit using one extension - i can't remember
which - and was getting alot of bizzare errors which would leave the ruby
object in an invalid state...

anyhow - this must certainly be the coolest embedable rdbms out there and
should be a good match for ruby.  one thing i'll comment on though - the
speeds are not quite what i'd hoped (or claimed) - not bad though.


something like this (perhaps *just* like this) distributed with ruby would be
simply unreal IMHO...  having web and database packages standard with a
language is a powerful combo, especially an embedded database like sqlite;
i've been using pstore, cgi, and cgi::session::pstore (my own package) for
most of my web work since it makes moving an app to another server a simple
matter of tar/un-tar.  sqlite also would have this advantage.

one other note - i've successfully used sqlite from different machines on an
nfs mounted db file. pretty cool...

enough rambles.

-a
--
  ====================================
  | Ara Howard
  | NOAA Forecast Systems Laboratory
  | Information and Technology Services
  | Data Systems Group
  | R/FST 325 Broadway
  | Boulder, CO 80305-3328
  | Email: ara.t.howard@noaa.gov
  | Phone:  303-497-7238
  | Fax:    303-497-7259
  | ~ > ruby -e 'p(%.\x2d\x29..intern)'
  ====================================