Install SQLite3 in Ubuntu

Install SQLite3 in Ubuntu
http://theplana.wordpress.com/2007/05/11/install-sqlite3-on-ubuntu/

1. Install Sqlite3


sudo apt-get install sqlite3 libsqlite3-dev
sudo gem install sqlite3-ruby

2. To create a data base, we only need to create a empty file.


touch database_name_dev.db
touch database_name_test.db
touch database_name_prod.db

3. Configure Ruby on Rails Modificar el archivo config/database.yml:


development:
adapter: sqlite3
database: db/database_name_dev.db

test:
adapter: sqlite3
database: db/database_name_test.db

production:
adapter: sqlite3
database: db/database_name_prod.db