Replacing SQLite

How to replace a default SQLite server with MySQL or Postgres

Instructions

Switching to another SQL-based database is easy, and the following instructions show you how to switch to MySQL or Postgres in five simple steps.

MySQL

Replace adapter: sqlite with adapter: mysql2 in your config/database.yml file.
Replace gem 'sqlite*' with gem 'mysql2' in your Gemfile.
Run bundle install.
Commit and check changes in.
Rebuild your application.

Postgres

Replace adapter: sqlite with adapter: postgresql in your config/database.yml file.
Replace gem 'sqlite*' with gem 'pg' in your Gemfile.
Run bundle install.
Commit and check changes in.
Rebuild your application.

More information about databases supported by Cloud 66.