Replacing SQLite with MySQL or PostgreSQL

SQLite is not suitable for production environments

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.

 

You must be logged in to comment on this article