Skip to content
SQLite database engine embedded in a ruby extension.
Branch: master
Clone or download
Latest commit 6f34b7f Jan 20, 2019
Type Name Latest commit message Commit time
Failed to load latest commit information.
examples switch to fts5 example Dec 6, 2015
ext update to sqlite 3.26.0 Jan 19, 2019
lib bump version Jan 19, 2019
tasks fix manifest ignores Jan 19, 2019
.ruby-version changing ruby version for semaphore Jan 19, 2019
.travis.yml update travis CI config Jan 19, 2019
Gemfile adding Gemfile and update gemspec Jan 12, 2015
Gemfile.lock Adding gemfile.lock Jan 19, 2019 bump version Jan 19, 2019
Manifest.txt fix manifest ignores Jan 19, 2019 Update documentation Jan 19, 2019
Rakefile update gem dependencies Nov 17, 2017 noting some items to work on Feb 18, 2015




  • gem install 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
  • full text search

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

Amalgalite adds in the following additional non-default SQLite extensions:

Other extensions are add that might not be usable/visible by users of the gem. The full list of extensions added is in extconf.rb. And those may be cross referenced against the compile options from SQLite



Read the HISTORY.rdoc file.


Copyright (c) 2008 Jeremy Hinegardner

All rights reserved.

See LICENSE and/or COPYING for details.

You can’t perform that action at this time.