# HG changeset patch # User edogawaconan # Date 1381769239 -32400 # Node ID bcca41003e8432288b0354ffa84856290d422e01 # Parent 1e2e999f586ad37adfd997ab7558cd591d1fe182 Use postgres 'cuz mysql is shit. - utf8 isn't utf8 (hint: utf8mb4) - index key too loooooooooooong Nope. diff -r 1e2e999f586a -r bcca41003e84 Gemfile --- a/Gemfile Thu Oct 10 04:56:19 2013 +0000 +++ b/Gemfile Tue Oct 15 01:47:19 2013 +0900 @@ -6,8 +6,8 @@ # Bundle edge Rails instead: # gem 'rails', :git => 'git://github.com/rails/rails.git' -gem 'mysql2', platforms: :ruby -gem 'activerecord-jdbcmysql-adapter', platforms: :jruby +gem 'pg', platforms: :ruby +gem 'activerecord-jdbcpostgresql-adapter', platforms: :jruby gem 'jruby-openssl', platforms: :jruby gem 'actionpack-page_caching' diff -r 1e2e999f586a -r bcca41003e84 Gemfile.lock --- a/Gemfile.lock Thu Oct 10 04:56:19 2013 +0000 +++ b/Gemfile.lock Tue Oct 15 01:47:19 2013 +0900 @@ -21,11 +21,11 @@ activesupport (= 4.0.0) arel (~> 4.0.0) activerecord-deprecated_finders (1.0.3) - activerecord-jdbc-adapter (1.3.1) + activerecord-jdbc-adapter (1.3.2) activerecord (>= 2.2) - activerecord-jdbcmysql-adapter (1.3.1) - activerecord-jdbc-adapter (~> 1.3.1) - jdbc-mysql (>= 5.1.22) + activerecord-jdbcpostgresql-adapter (1.3.2) + activerecord-jdbc-adapter (~> 1.3.2) + jdbc-postgres (>= 9.1) activesupport (4.0.0) i18n (~> 0.6, >= 0.6.4) minitest (~> 4.2) @@ -44,7 +44,7 @@ execjs (2.0.2) hike (1.2.3) i18n (0.6.5) - jdbc-mysql (5.1.25) + jdbc-postgres (9.2.1002.1) jquery-rails (3.0.4) railties (>= 3.0, < 5.0) thor (>= 0.14, < 2.0) @@ -57,8 +57,8 @@ mime-types (1.25) minitest (4.7.5) multi_json (1.8.1) - mysql2 (0.3.13) newrelic_rpm (3.6.8.164) + pg (0.17.0) polyglot (0.3.3) puma (2.6.0) rack (>= 1.1, < 2.0) @@ -125,12 +125,12 @@ DEPENDENCIES actionpack-page_caching - activerecord-jdbcmysql-adapter + activerecord-jdbcpostgresql-adapter anjlab-bootstrap-rails (~> 2.3.0) jquery-rails jruby-openssl - mysql2 newrelic_rpm + pg puma quiet_assets rails (~> 4.0.0.rc1) diff -r 1e2e999f586a -r bcca41003e84 config/database.yml.example --- a/config/database.yml.example Thu Oct 10 04:56:19 2013 +0000 +++ b/config/database.yml.example Tue Oct 15 01:47:19 2013 +0900 @@ -1,8 +1,7 @@ # Copy this to "database.yml" and adjust the fields accordingly. # Should work with any adapter. login: &login - adapter: mysql2 - encoding: utf8 + adapter: postgresql pool: 5 username: zp password: silica