sqlite3_hash

Sqlite3Hash

A persistent simple Hash backed by sqlite3

Contains (almost) the same features/API as the Ruby Hash object (v2.0.0)

Installation

Add this line to your application's Gemfile:

gem 'sqlite3_hash'

And then execute:

$ bundle

Or install it yourself as:

$ gem install sqlite3_hash

Usage

SQLite3Hash is a persistent simple Hash backed by sqlite3.

You can use it like a Hash object, but all data is stored in SQLite3, which can be re-used over multiple instantiations of ruby.

Example case:

require 'rubygems'
require 'sqlite3_hash'

shash = SQLite3Hash.new('tmpfile.db')
shash['int'] = 42
shash[:sym] = { a: 12, b: 32 }
shash[99.1] = [1,[10,20],3]  
shash = nil

# Some point later..  or even in another ruby instance:
shash = SQLite3Hash.new('tmpfile.db')
shash['int']   # => 42
shash.to_s     # => {"int"=>42, :sym=>{:a=>12, :b=>32}, 99.1=>[1, [10, 20], 3]}

Handles values of String, Fixnum, Float, and anything that can be Marshalled

Keys are anything that can be Marshalled.

This means, for example, that you cannot store Procs in an SQLite3Hash

You can use the same SQLite3 DB for multiple hashes:

require 'rubygems'
require 'sqlite3_hash'
hash1 = SQLite3Hash.new('tmpfile.db','hash1')
hash2 = SQLite3Hash.new('tmpfile.db','hash2')

Contains all the Hash class methods from 2.0.0 except:

• No deprecated methods
• Methods not implemented: rehash, compare_by_identity, SQLite3Hash[]
• Methods that are supposed to return a hash do so (instead of returning an SQLite3Hash), for example 'to_h'
• try_convert also requires db and other parameters as per SQLite3Hash.new
• Uses the value of an object instead of the object as a key

For example:

a = [ "a", "b" ]
h = { a => 100 }
sh = SQLite3Hash('tmp.db', h)
a[0] = 'z'   # This only effects 'h' not 'sh'
h	 # => {["z", "b"]=>100}
sh  # => {["a", "b"]=>100}

Development

After checking out the repo, run bin/setup to install dependencies. Then, run bundle exec rspec to run the tests. You can also run bin/console for an interactive prompt that will allow you to experiment.

To install this gem onto your local machine, run bundle exec rake install. To release a new version, update the version number in version.rb, and then run bundle exec rake release, which will create a git tag for the version, push git commits and tags, and push the .gem file to rubygems.org.

(This should probably someday be rewritten using mixins or inheritance.)

Contributing

Bug reports and pull requests are welcome on GitHub at https://github.com/daveola/sqlite3_hash.

License

The gem is available as open source under the terms of the MIT License.