⇧ home

How to install SQLite3

By Mislav on 22 Dec 2007 in rails

The new default database in Rails 2.0.2 is SQLite3, which I personally think is a great default. Although there is a discussion on Rails-core about reverting back to MySQL on Windows platforms if SQLite3 can’t be detected, I think the best choice for any Ruby developer (using Windows or any other OS) would be to simply have SQLite installed on every of her development environments. It only takes a minute.

Install SQLite3 on Windows

  1. Go to SQLite3 download page, “Precompiled Binaries For Windows” section;
  2. Download “sqlite-3xy.zip” and “sqlitedll-3xy.zip” archives;
  3. Unpack them in “C:\WINDOWS\system32” directory (or any other that is in your PATH);
  4. Install the sqlite3-ruby gem.

Install SQLite3 on Ubuntu Linux

  1. Install the sqlite3 and libsqlite3-dev packages;
  2. Install the sqlite3-ruby gem.

Install SQLite3 on Mac OS X

On Leopard, you don’t have to! On Tiger, refer to this guide by Scott Motte.