CODEWITHSUNDEEP
ruby-on-railssqlite
Nir Levy
Nir Levy

Reputation: 53

SQLite and Ruby on Rails on PC

I am using instant rails which makes use of SQLite and I am unable to connect to the database. I have been using a tutorial that uses MySQL and I have been unable to find instructions for SQLite. Any suggestions?

Upvotes: 1

Views: 423

Answers (1)

BaroqueBobcat
BaroqueBobcat

Reputation: 10150

You could install sqlite. Or, assuming you have mysql installed, you could change your config/database.yml file to use mysql instead of sqlite. (From using rails -d mysql testapp)

development:
  adapter: mysql
  encoding: utf8
  reconnect: false
  database: awesome_development
  pool: 5
  username: root
  password:
  host: localhost

Update To use sqlite3, you need the sqlite gem and to set up your rails database.yml to use it. The default config rails generates uses sqlite and looks like this

development:
  adapter: sqlite3
  database: db/development.sqlite3
  pool: 5
  timeout: 5000

to install, here are some good looking instructions

Upvotes: 1

Related Questions