PostgreSQL's place in the New World Order

Slide 1

Slide 1 text

PostgreSQL’s Place in the New World Order Matthew Soldo Friday, July 20, 12

Slide 2

Slide 2 text

introductions Friday, July 20, 12

Slide 3

Slide 3 text

Postgres’ time has come (so use it) Friday, July 20, 12

Slide 4

Slide 4 text

NoSQL Cloud Friday, July 20, 12

Slide 5

Slide 5 text

NoSQL Cloud Friday, July 20, 12

Slide 6

Slide 6 text

data is sexy again Friday, July 20, 12

Slide 7

Slide 7 text

alternative data representation NoSQL is about Friday, July 20, 12

Slide 8

Slide 8 text

key / value documents cs geekery Friday, July 20, 12

Slide 9

Slide 9 text

key / value documents cs geekery hstore json arrays... Friday, July 20, 12

Slide 10

Slide 10 text

INSERT INTO users (data) VALUES (' name => Bob, email => [email protected] '); Friday, July 20, 12

Slide 11

Slide 11 text

SELECT data->'name' FROM users; Friday, July 20, 12

Slide 12

Slide 12 text

key / value documents cs geekery hstore json arrays... Friday, July 20, 12

Slide 13

Slide 13 text

scaling NoSQL is about Friday, July 20, 12

Slide 14

Slide 14 text

Every startup expects to hit FaceBook scale Friday, July 20, 12

Slide 15

Slide 15 text

Friday, July 20, 12

Slide 16

Slide 16 text

Postgres is adopting the best of noSQL Friday, July 20, 12

Slide 17

Slide 17 text

NoSQL Cloud Friday, July 20, 12

Slide 18

Slide 18 text

NoSQL Cloud Friday, July 20, 12

Slide 19

Slide 19 text

servers applications Friday, July 20, 12

Slide 20

Slide 20 text

Friday, July 20, 12

Slide 21

Slide 21 text

0 500,000 1,000,000 1,500,000 2,000,000 Applications Running On Heroku Friday, July 20, 12

Slide 22

Slide 22 text

De Facto Standards Access SQL Server C# .net FileMaker SQLite Objective C MySQL SQLite PostgreSQL C Perl PHP Python Friday, July 20, 12

Slide 23

Slide 23 text

Developer’s Choice Access SQL Server C# .net FileMaker SQLite Objective C MySQL SQLite PostgreSQL C Perl PHP Python Friday, July 20, 12

Slide 24

Slide 24 text

addons.heroku.com Friday, July 20, 12

Slide 25

Slide 25 text

postgres://user:[email protected]/dbname Friday, July 20, 12

Slide 26

Slide 26 text

why cloud services? Friday, July 20, 12

Slide 27

Slide 27 text

just the beginning sudo apt-get install postgresql Friday, July 20, 12

Slide 28

Slide 28 text

backups testing restores ﬁre drills pages on-call ... wash, rinse, repeat Friday, July 20, 12

Slide 29

Slide 29 text

ﬁre and forget heroku addons:add heroku-postgresql Friday, July 20, 12

Slide 30

Slide 30 text

Easy Trusted Productized cloud service beneﬁts Friday, July 20, 12

Slide 31

Slide 31 text

Demo Time Friday, July 20, 12

Slide 32

Slide 32 text

Easy Friday, July 20, 12

Slide 33

Slide 33 text

cloud services requires Friday, July 20, 12

Slide 34

Slide 34 text

Scalability Operability Open Source cloud services requires Friday, July 20, 12

Slide 35

Slide 35 text

you better trust your vendor closed source + cloud Friday, July 20, 12

Slide 36

Slide 36 text

ﬁre your vendor any time open source + cloud Friday, July 20, 12

Slide 37

Slide 37 text

cloud operators & users postgres great for Friday, July 20, 12

Slide 38

Slide 38 text

the business model for open source (a brief aside) Friday, July 20, 12

Slide 39

Slide 39 text

NoSQL Cloud Friday, July 20, 12

Slide 40

Slide 40 text

Multi-Master Extensions Foreign data wrappers The Future Friday, July 20, 12

Slide 41

Slide 41 text

Postgres’ time has come (so use it in the cloud) Friday, July 20, 12

Slide 42

Slide 42 text

one more thing Friday, July 20, 12

Slide 43

Slide 43 text

Friday, July 20, 12

Slide 44

Slide 44 text

Q & A Friday, July 20, 12