The default database for development in Rails is SQLite3,
which I personally think is great. Any Ruby developer (using Windows or
any other OS) should have SQLite installed on their development
environments. It only takes a minute.
Install SQLite3 on Windows
- Go to SQLite3 download page, “Precompiled Binaries For Windows” section;
- Download “sqlite-shell” and “sqlite-dll” archive files;
- Unpack them in
C:\WINDOWS\system32
folder (or any other that is in your PATH); - Install the sqlite3 Ruby gem.
Install SQLite3 on Ubuntu Linux
- Install the sqlite3 and libsqlite3-dev packages;
- Install the sqlite3 gem.