Converting rails project on sqlite3 on local host

Question

I am new to rails and i am facing alot of problems while running the project on local host using mysql database .Is there any way to run a project on sqlite3 on local host and on server it can be run using mysql database.

Answer 1

Yes, you can. In fact, I believe this setup is pretty common.

In your Gemfile, use sqlite3 in the development group, and mysql2 in the production group. For example,

group :production do
  gem 'mysql2'
end
group :development, :test do
  gem 'sqlite3'
end

Then, on your development machine, use

$ gem install --without production

to avoid installing mysql. Finally, in database.yml, check that the sqlite adapter is selected for test and development, and the mysql adapter is selected for production.

development:
  adapter: sqlite3
  database: db/development.sqlite3

test:
  adapter: sqlite3
  database: db/test.sqlite3

production:
  adapter: mysql2
  encoding: utf8

This should be enough to get you started.