#342 Migrating to PostgreSQL

Apr 17, 2012 | 8 minutes | Active Record, Tools

Postgres is a feature-packed relational database that every Rails developer should consider using. Here you will learn how to install it, add it to a new application, and transition from an existing SQLite app using the "taps" gem.

Click to Play Video ▶

Download:
source codeProject Files in Zip (139 KB)
mp4Full Size H.264 Video (26.7 MB)
m4vSmaller H.264 Video (11.9 MB)
webmFull Size VP8 Video (10.4 MB)
ogvFull Size Theora Video (28.2 MB)

Browse Source Code

Resources

          terminal
        
psql --version
brew install postgresql
initdb /usr/local/var/postgres
pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
which psql
rails new blog -d postgresql
rake db:create:all
rails g scaffold article name content:text
rake db:migrate
psql blog_development
rails db
gem install taps
taps
taps server sqlite://db/development.sqlite3 rbates secret
taps pull postgres://rbates@localhost/store_development http://rbates:secret@localhost:5000

          rails db
        
select * from articles;
\d
\d articles
\?
\h
\h select
\q

          config/database.yml
        
development:
  adapter: postgresql
  encoding: unicode
  database: blog_development
  pool: 5
  username: rbates
  password:

test:
  adapter: postgresql
  encoding: unicode
  database: blog_test
  pool: 5
  username: rbates
  password:

          Gemfile
        
gem "pg"