ActiveTable
ActiveTable is a thin layer on top of ActiveRecord that uses temporary tables to meet all of your static data needs.
Installation
gem install active_table
Usage
Everything you need to set up ActiveTable lives within your model. It should be placed above any other code so that it can initialize the table and tell ActiveRecord to reload the attributes from the table. A sample model is as follows:
class Color < ActiveTable::Base
active_table do
create_table :colors do |t|
t.string :name
end
insert :id => 1, :name => "Chartreuse"
insert :id => 2, :name => "Cerulean"
insert :id => 3, :name => "Taupe"
end
end
ActiveTable will handle all of the CREATE/INSERT operations for every database connections that is opened. You get to use your new model just like an ActiveRecord model and stop worrying about everything else.