postgres presentation

32
MySQL, PostgreSQL and Rails A polemic

Upload: gisborne

Post on 19-May-2015

3.364 views

Category:

Technology


6 download

DESCRIPTION

A polemic regarding the virtues of Postgres compared with MySQL.

TRANSCRIPT

Page 1: Postgres Presentation

MySQL, PostgreSQL and

RailsA polemic

Page 2: Postgres Presentation

Pity the poor programmer

Page 3: Postgres Presentation

Slaving away in the bit mines

Page 4: Postgres Presentation

Just store my data!

Page 5: Postgres Presentation

<polemic>

Page 6: Postgres Presentation

Network effect

Page 7: Postgres Presentation

Features

Page 8: Postgres Presentation

PostgreSQL

MySQL

Features

Page 9: Postgres Presentation

MySQL

Multiple table types

Clustering

..?

Page 10: Postgres Presentation

PostgreSQL

Genetic Query Optimizer

ProceduralLanguages

Functional/Partial Indexes

OracleCompatibility

Advanced Rules,Stored Procedures, Triggers

•pgSQL (Oracle)•Tcl•Perl•Python

•Java•PHP•R•Ruby•Scheme•sh

Page 11: Postgres Presentation

Speed

Page 12: Postgres Presentation

http://tweakers.net/reviews/657/5/database-test-dual-intel-xeon-5160-pagina-5.html

Page 13: Postgres Presentation
Page 14: Postgres Presentation
Page 15: Postgres Presentation

http://www.spec.org/jAppServer2004/results/jAppServer2004.html

Page 16: Postgres Presentation

Licence

Page 17: Postgres Presentation

From the MySQL website

Page 18: Postgres Presentation

From the MySQL website

Page 19: Postgres Presentation

http://www.kitebird.com/articles/ruby-mysql.html

Gue

ss w

hat

licen

se?

Page 20: Postgres Presentation

The PostgreSQL license

PostgreSQL Data Base Management System

Portions Copyright (c) 1996-2008, PostgreSQL Global Development Group Portions Copyright (c) 1994-1996 Regents of the University of California

Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs

appear in all copies.

IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING

LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA HAS BEEN ADVISED OF THE POSSIBILITY OF

SUCH DAMAGE.

THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS ON AN "AS IS" BASIS, AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO PROVIDE

MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.

Page 21: Postgres Presentation

</polemic>

Page 22: Postgres Presentation

On clever databases

Page 23: Postgres Presentation

— DHH

We took a pretty radical stand: Stored procedures and all things

that make your database clever are evil

Page 24: Postgres Presentation

Application database

Page 25: Postgres Presentation

Integration database

Page 26: Postgres Presentation

Integration database

Page 27: Postgres Presentation

Complex processes

Page 28: Postgres Presentation

Recursive structures (etc)

Page 29: Postgres Presentation

Smart databases & Rails

•Maintain with migrations

• ..?

Page 30: Postgres Presentation

Fin

Page 31: Postgres Presentation

Questions

Page 32: Postgres Presentation

Postgres with Rails