Postgres Workshop

1) Fork and clone this repo:

github.com/rbatta/img_blog

2) Use ruby 2.0.0

3) Run bundle install

Have Postgres (9.2+) running in the background

OMG Whaddup, Postgres?

Risa Batta

@mookiy

ʕ•̀ω•́ʔ✧

Fight!

SQLite

MySQL

PostgreSQL

MongoDB

SQLite

• Fast with read-only transactions

• Awesome for iOS & Android development

• Sucks with user concurrency

MySQL

• Most popular database

• Super fast with read-only

• Owned by Oracle

• Easy to install 

• Not totally ANSI SQL compliant

• Easy to scale

• May have some limited functionality

PostgreSQL

• Most advanced database

• Totally open-source

• Great for concurrent writing

• Not so good with read-only

• ANSI SQL and ACID compliant

MongoDB

• NoSQL database

• Documents as JSON

What ARE you, really?

Heroku

• Go-to free hosting solution

• Postgres vs MySQL

• Postgres vs SQLite

Let the DBAs do their job