Created
September 4, 2013 05:12
-
-
Save unicornrainbow/6432979 to your computer and use it in GitHub Desktop.
Differences between rails projects generated with --database with postgresq| versus mysql.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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