Screencast: Migration nach PostgreSQL

Downloads in verschiedenen Formaten:

mp4 m4v webm ogg

Resourcen:

• PostgreSQL
• PostgreSQL Manual
• Homebrew
• Taps
• Texticle
• pg_search
• queue_classic
• Hstore

terminal

[bash] 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 [/bash]

rails db

[ruby] select * from articles; d d articles ? h h select q [/ruby]

config/database.yml

[text] 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: [/text]

Gemfile

[ruby] gem “pg” [/ruby]