If you are using Rails, you will need a database. Often SQLite 3 may be used for local development, while one of the others might be used for deployment.

MySQL

http://www.mysql.com/

SQLite

http://www.sqlite.org/

PostgreSQL

http://www.postgresql.org/

SQL Server Express

http://www.microsoft.com/sql/editions/express/