amalgalite version 0.6.0 has been released.

  gem install amalgalite

http://copiousfreetime.rubyforge.org/amalgalite/

Amalgalite embeds the SQLite database engine in a ruby extension.  There is no
need to install SQLite separately.  

Look in the examples/ directory to see

* general usage
* blob io
* schema information
* custom functions
* custom aggregates
* requiring ruby code from a database

Also Scroll through Amalgalite::Database for a quick example, and a general
overview of the API.

I also wrote up a blog post on how to write SQL functions (both scalar and
aggregate).

  http://copiousfreetime.org/articles/2009/01/10/writing-sql-functions-in-ruby.html

{{ Release notes for Version 0.6.0 }}

=== Major Enhancements

* Added ability to define custom SQL functions implemented in Ruby
* Added ability to define custom SQL aggregates implemented in Ruby
* Added support for Ruby busy handlers
* Added database 'interrupt' support
* Added support for Ruby progress handlers

=== Minor Enhancement

* update to SQLite version 3.6.7

enjoy,

-jeremy

-- 
========================================================================
 Jeremy Hinegardner                              jeremy / hinegardner.org