Sqlite3 Notes¶

I found that the GetHyperactive instructions also work with sqlite3. In addition to those instructions, the following changes are needed:

1. Change your database.yml to use the sqlite3 adapter:

development:
  adapter: sqlite3
  database: db/hyperactive_development.sqlite3
  timeout: 15000

test:
  adapter: sqlite3
  database: db/test.sqlite3
  timeout: 15000

production:
  adapter: sqlite3
  database: hyperactive_production.sqlite3

Don't mix and match the adapter as this seems to upset rake.

2. Comment out the following lines on the first migration: 001_active_rbac_to_version_1_and_hyperactive_to_version_34.rb

212: add_index "roles_static_permissions", ["static_permission_id", "role_id"], :name => "roles_static_permissions_all_index", :unique => true
213: #add_index "roles_static_permissions", ["role_id"], :name => "role_id" 

and

221:  add_index "roles_users", ["user_id", "role_id"], :name => "roles_users_all_index", :unique => true
222:  #add_index "roles_users", ["role_id"], :name => "role_id

This is to do with adding indexes with the same table name and sqlite3 causing problems, hopefully we'll fix it soon ;)

Besides this, everything worked fine for me with ubuntu and sqlite3 and rails 2.0.2