ActiveTable is a thin layer on top of ActiveRecord that uses temporary tables to meet all of your static data needs.
gem install active_table
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 < :: 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.