changeset 254:bcca41003e84

Use postgres 'cuz mysql is shit. - utf8 isn't utf8 (hint: utf8mb4) - index key too loooooooooooong Nope.
author edogawaconan <me@myconan.net>
date Tue, 15 Oct 2013 01:47:19 +0900
parents 1e2e999f586a
children a894d7696b7e
files Gemfile Gemfile.lock config/database.yml.example
diffstat 3 files changed, 11 insertions(+), 12 deletions(-) [+]
line wrap: on
line diff
--- 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'
 
--- 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)
--- 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