<?xml version="1.0" encoding="UTF-8"?>
<post>
  <body>&lt;p&gt;Hi all.&lt;/p&gt; &lt;p&gt;If your Operacional System is Ubuntu and you are using Ruby on Rails 2.0.2 you can easily use it:&lt;/p&gt; &lt;pre&gt;&lt;code&gt;$ sudo apt-get install sqlite3&lt;/code&gt;&lt;/pre&gt; &lt;pre&gt;&lt;code&gt;$ sudo gem install sqlite3-ruby&lt;/code&gt;&lt;/pre&gt; &lt;p&gt;SQLite3 does not use authentication and needs only a pointer to the database file on database yml.&lt;/p&gt; &lt;pre&gt;&lt;code&gt;development:&lt;br /&gt;&amp;nbsp; adapter: sqlite3&lt;br /&gt;&amp;nbsp; database: db/development.sqlite3&lt;br /&gt;&amp;nbsp; timeout: 5000&lt;br /&gt;test:&lt;br /&gt;&amp;nbsp; adapter: sqlite3&lt;br /&gt;&amp;nbsp; database: db/test.sqlite3&lt;br /&gt;&amp;nbsp; timeout: 5000&lt;br /&gt;production:&lt;br /&gt;&amp;nbsp; adapter: sqlite3&lt;br /&gt;&amp;nbsp; database: db/production.sqlite3&lt;br /&gt;&amp;nbsp; timeout: 5000&lt;/code&gt;&lt;/pre&gt; &lt;p&gt;When you run &amp;quot;rake db:create:all&amp;quot; on your RAILS_ROOT it creates all 3 databases.&lt;/p&gt; &lt;p&gt;More information about other plataforms?&lt;/p&gt; &lt;p&gt;Here: &lt;a href=&quot;http://wiki.rubyonrails.org/rails/pages/HowtoUseSQLite&quot;&gt;http://wiki.rubyonrails.org/rails/pages/HowtoUseSQLite&lt;/a&gt;&lt;/p&gt; &lt;p&gt;See you.&lt;/p&gt;</body>
  <created-at type="datetime">2008-01-28T13:19:07Z</created-at>
  <id type="integer">19</id>
  <permalink>sql-lite-for-ruby-on-rails</permalink>
  <title>SQL Lite for Ruby On Rails</title>
  <updated-at type="datetime">2008-10-24T04:33:15Z</updated-at>
  <user-id type="integer">3</user-id>
</post>
