Heroku Postgres Webinar

Transcript

1. Heroku  Postgres  Webinar Craig  Kerstiens Matt  Soldo
2. Architecture Heroku Runtime Database.com Heroku Postgres Force.com Other Platforms
3. Heroku  Postgres Social  Enterprise  DBaaS SQL  Database-­‐as-­‐a-­‐Service Database.com
4. Let’s  Provision  a  Database
5. Heroku Postgres Management Services Postgres Value-Added Features
6. Heroku Postgres Management Services Postgres Value-Added Features
7. Management  Services
8. Setup Manage Security Backup Scale Query DBA  Tasks
9. Setup Manage Security Backup Scale Query DBA  Tasks
10. We  hold  the  pager Health  Checks Continuous  Protection
11. Heroku Postgres Management Services Postgres Value-Added Features
12. Heroku Postgres Management Services Postgres Value-Added Features
13. 100%  Compatible
14. Why  Postgres?
15. Users Purchases Products
16. CREATE  TABLE  products  (        id  integer  NOT  NULL,        title  character  varying(255),        description  text,        price  numeric(10,2) );
17. CREATE  TABLE  users  (        id  integer  NOT  NULL,        first_name  character  varying(50),        last_name  character  varying(50),        email  character  varying(255),        data  hstore,        created_at  timestamp  without  time  zone,        updated_at  timestamp  without  time  zone,        last_login  timestamp  with  time  zone );
18. CREATE  TABLE  purchases  (        id  integer  NOT  NULL,        user_id  integer,        items  decimal(10,2)  [][],        occurred_at  timestamp );
19. CREATE  TABLE  purchases  (        id  integer  NOT  NULL,        user_id  integer,        items  decimal(10,2)  [][],        occurred_at  timestamp );
20. CREATE  TABLE  purchases  (        id  integer  NOT  NULL,        user_id  integer,        items  decimal(10,2)  [][],        occurred_at  timestamp ); items[x][0] = item_id items [x][1] = qty items [x][2] = price
21. Data  Types INSERT  INTO  purchases  VALUES  (    2,  2,  '{{11.0,  1.0,  4.99}}',  now() );
22. Data  Types smallint bigint integer numeric float serial money char varchar text bytea timestamp timestamptz date time timetz interval boolean enum point line polygon box circle path inet cidr macaddr tsvector tsquery array XML UUID
23. Other  Languages CREATE  OR  REPLACE  FUNCTION  total(decimal(10,2)[][])   RETURNS  decimal(10,2)  AS  $$ DECLARE    s  decimal(10,2)  :=  0;    x  decimal[]; BEGIN    FOREACH  x  SLICE  1  IN  ARRAY  $1    LOOP        s  :=  s  +  (x[2]  *  x[3]);    END  LOOP;    RETURN  s; END; $$  LANGUAGE  plpgsql;
24. Other  Languages FOREACH  x  SLICE  1  IN  ARRAY  $1    LOOP        s  :=  s  +  (x[2]  *  x[3]);    END  LOOP;    RETURN  s;
25. Other  Languages python ruby pgsql SQL tcl sh R V8 Java javascript lolcode scheme php j lua psm
26. Extensions CREATE  EXTENSION  hstore; CREATE  TABLE  users  (        id  integer  NOT  NULL,        first_name  character  varying(50),        last_name  character  varying(50),        email  character  varying(255),        data  hstore,        created_at  timestamp  without  time  zone,        last_login  timestamp  without  time  zone );
27. Extensions INSERT  INTO  users   VALUES  ( 1,   'Craig',   'Kerstiens',   'craig.kerstiens@gmail.com',   'sex  =>  "M",  state  =>  "CA"',   now(),   now() );
28. Extensions dblink hstore citext ltree isn cube pgcrypto tablefunc uuid-ossp earthdistance trigram fuzzystrmatch pgrowlocks pgstattuple btree_gist dict_int dict_xsyn unaccent
29. Heroku Postgres Management Services Postgres Value-Added Features
30. Heroku Postgres Management Services Postgres Value-Added Features
31. Data  Clips The  easiest  way  to  share  your  data
32. SELECT * FROM sales WHERE amount > 1 + Your Live Production Data
33. https://postgres.heroku.com/dataclips/{unique  &  secure  hash}
34. Followers Master Database Follower  1 Follower  2 Write  Transactions Read  Transactions
35. Followers Master Database Follower  1 Follower  2 Write  Transactions Read  Transactions
36. Followers Master Database New  Master Follower  2 Write  Transactions Read  Transactions
37. Pricing  and  Availability
38. Learn  More Try  It  free:      https://postgres.heroku.com Code:                        https://github.com/craigkerstiens/postgres-­‐demo Survey:                http://bit.ly/herokupostgressurvey matt@heroku.com    |    craig@heroku.com