From: Gregory Brown <gregory.t.brown@...>
Date: 2007-06-30T00:35:33+09:00
Subject: Re: DBI, and SQLite Problems

On 6/28/07, Ari Brown <ari@aribrown.com> wrote:
>
> On Jun 28, 2007, at 9:26 PM, Michael Glaesemann wrote:
> > So, I think you'd want something along the lines of
> >
> > ruby setup.rb config --with=dib, dbd_mysql or somesuch.
>
> I did ruby setup.rb config --with=dbd_mysql, as well as with
> dbd_sqlite. mysql worked perfectly, and sqlite did not. I assume this
> is because I do not have the sqlite software installed, as I do with
> mysql?

You need sqlite as well as the sqlite3-ruby gem

This howto is for camping, but should do the trick:
http://code.whytheluckystiff.net/camping/wiki/BeAlertWhenOnSqlite3

Also, you might consider using ActiveRecord standalone instead of DBI.
 Or possibly Sequel, or something else that isn't painful like DBI is.
;)

If you wanted to use AR outside of Rails, I wrote an article that
might be helpful.
http://www.oreillynet.com/pub/a/ruby/2007/06/21/how-to-build-simple-console-apps-with-ruby-and-activerecord.html

Good luck,
-greg