Replacing SQLite with MySQL or PostgreSQL

Instructions

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

MySQL

  1. Replace adapter: sqlite with adapter: mysql2 in your config/database.yml file.
  2. Replace gem 'sqlite*' with gem 'mysql2' in your Gemfile.
  3. Run bundle install.
  4. Commit and check changes in.
  5. Rebuild your stack.

PostgreSQL

  1. Replace adapter: sqlite with adapter: postgresql in your config/database.yml file.
  2. Replace gem 'sqlite*' with gem 'pg' in your Gemfile.
  3. Run bundle install.
  4. Commit and check changes in.
  5. Rebuild your stack.

More information about databases supported by Cloud 66.

Still need help? Contact Us Contact Us