Skip to content

Instantly share code, notes, and snippets.

@unicornrainbow
Created September 4, 2013 05:12
Show Gist options
  • Save unicornrainbow/6432979 to your computer and use it in GitHub Desktop.
Save unicornrainbow/6432979 to your computer and use it in GitHub Desktop.
Differences between rails projects generated with --database with postgresq| versus mysql.
diff --git c/Gemfile i/Gemfile
index 36c38ba..e999a91 100644
--- c/Gemfile
+++ i/Gemfile
@@ -3,8 +3,8 @@ source 'https://rubygems.org'
# Bundle edge Rails instead: gem 'rails', github: 'rails/rails'
gem 'rails', '4.0.0'
-# Use postgresql as the database for Active Record
-gem 'pg'
+# Use mysql as the database for Active Record
+gem 'mysql2'
# Use SCSS for stylesheets
gem 'sass-rails', '~> 4.0.0'
diff --git c/Gemfile.lock i/Gemfile.lock
index 9e82364..c9ba3af 100644
--- c/Gemfile.lock
+++ i/Gemfile.lock
@@ -52,7 +52,7 @@ GEM
mime-types (1.25)
minitest (4.7.5)
multi_json (1.7.9)
- pg (0.16.0)
+ mysql2 (0.3.13)
polyglot (0.3.3)
rack (1.5.2)
rack-test (0.6.2)
@@ -111,7 +111,7 @@ DEPENDENCIES
coffee-rails (~> 4.0.0)
jbuilder (~> 1.2)
jquery-rails
- pg
+ mysql2
rails (= 4.0.0)
sass-rails (~> 4.0.0)
sdoc
diff --git c/config/database.yml i/config/database.yml
index 3ee91ed..998f9b5 100644
--- c/config/database.yml
+++ i/config/database.yml
@@ -1,60 +1,39 @@
-# PostgreSQL. Versions 8.2 and up are supported.
+# MySQL. Versions 4.1 and 5.0 are recommended.
#
-# Install the pg driver:
-# gem install pg
-# On OS X with Homebrew:
-# gem install pg -- --with-pg-config=/usr/local/bin/pg_config
-# On OS X with MacPorts:
-# gem install pg -- --with-pg-config=/opt/local/lib/postgresql84/bin/pg_config
-# On Windows:
-# gem install pg
-# Choose the win32 build.
-# Install PostgreSQL and put its /bin directory on your path.
+# Install the MYSQL driver
+# gem install mysql2
#
-# Configure Using Gemfile
-# gem 'pg'
+# Ensure the MySQL gem is defined in your Gemfile
+# gem 'mysql2'
#
+# And be sure to use new-style password hashing:
+# http://dev.mysql.com/doc/refman/5.0/en/old-client.html
development:
- adapter: postgresql
- encoding: unicode
+ adapter: mysql2
+ encoding: utf8
database: postgres_to_mysql_development
pool: 5
- username: postgres_to_mysql
+ username: root
password:
-
- # Connect on a TCP socket. Omitted by default since the client uses a
- # domain socket that doesn't need configuration. Windows does not have
- # domain sockets, so uncomment these lines.
- #host: localhost
-
- # The TCP port the server listens on. Defaults to 5432.
- # If your server runs on a different port number, change accordingly.
- #port: 5432
-
- # Schema search path. The server defaults to $user,public
- #schema_search_path: myapp,sharedapp,public
-
- # Minimum log levels, in increasing order:
- # debug5, debug4, debug3, debug2, debug1,
- # log, notice, warning, error, fatal, and panic
- # Defaults to warning.
- #min_messages: notice
+ socket: /tmp/mysql.sock
# Warning: The database defined as "test" will be erased and
# re-generated from your development database when you run "rake".
# Do not set this db to the same as development or production.
test:
- adapter: postgresql
- encoding: unicode
+ adapter: mysql2
+ encoding: utf8
database: postgres_to_mysql_test
pool: 5
- username: postgres_to_mysql
+ username: root
password:
+ socket: /tmp/mysql.sock
production:
- adapter: postgresql
- encoding: unicode
+ adapter: mysql2
+ encoding: utf8
database: postgres_to_mysql_production
pool: 5
- username: postgres_to_mysql
+ username: root
password:
+ socket: /tmp/mysql.sock
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment