Amalgalite embeds the SQLite database engine in a ruby extension.

  * http://www.copiousfreetime.org/projects/amalgalite/
  * http://copiousfreetime.org/articles/2008/06/21/amalgalite-0-1-0-released.html

I would consider Amalgalite beta right now. It is fully usable; but it does not
contain all the features I want yet.

Give it a whirl and let me know what you think.

Current Functionality
--------------------

The normal stuff:

  * open or create databases
  * run SQL in single statements or in batches.
  * use prepared statements with parameters
  * access result sets by index or by column name
  * transactions
  * type conversion between database types and Ruby types

The fun/happy/cool stuff

  * trace information
  * profile information 
  * read only databases
  * a type conversion protocol 

Future plans
------------

  * ActiveRecord driver
  * DataMapper driver
  * Sequel driver
  * progress and authorizer callbacks
  * 'amalgalite' command line tool similar to the 'sqlite3' command line tool
  * utf-16 support
  * blob support
  * and more

{{ Release notes for Version 0.1.0 }}

* Initial public release

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