PostgreSQL's place in the New World Order

PostgreSQL's place in the New World Order

Mainstream software development is undergoing a radical shift. Driven by the agile development needs of web, social, and mobile apps, developers are increasingly deploying to platforms-as-a-service (PaaS). A key enabling technology of PaaS is cloud-services: software, often open-source, that is consumed as a service and operated by a third-party vendor. This shift has profound implications for the open-source world. It enables new business models, increases emphasis on user-experience, and creates new opportunities.

PostgreSQL is an excellent case study in this shift. The PostgreSQL project has long offered one of the most reliable open source databases, but has received less attention than competing technologies. But in the PaaS and cloud-services world, reliability and open-ness become increasingly important. As such, we are seeing the beginning of a shift in adoption towards PostgreSQL.

The datastore landscape is particularly interesting because of the recent attention given to the so-called NoSQL technologies. Data is suddenly sexy again. This attention is largely governed by the same forces driving developers to PaaS, namely the need for agility and scalability in building modern apps. Far from being a threat to PostgreSQL, these technologies present an amazing opportunity for showing the way towards making PostgreSQL more powerful and more widely adopted.

D6e1f9a3270c7fb6c0cd8ad13d988826?s=128

mattsoldo

July 19, 2012
Tweet

Transcript

  1. PostgreSQL’s Place in the New World Order Matthew Soldo Friday,

    July 20, 12
  2. introductions Friday, July 20, 12

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

    12
  4. NoSQL Cloud Friday, July 20, 12

  5. NoSQL Cloud Friday, July 20, 12

  6. data is sexy again Friday, July 20, 12

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

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

  9. key / value documents cs geekery hstore json arrays... Friday,

    July 20, 12
  10. INSERT INTO users (data) VALUES (' name => Bob, email

    => bob@example.com '); Friday, July 20, 12
  11. SELECT data->'name' FROM users; Friday, July 20, 12

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

    July 20, 12
  13. scaling NoSQL is about Friday, July 20, 12

  14. Every startup expects to hit FaceBook scale Friday, July 20,

    12
  15. Friday, July 20, 12

  16. Postgres is adopting the best of noSQL Friday, July 20,

    12
  17. NoSQL Cloud Friday, July 20, 12

  18. NoSQL Cloud Friday, July 20, 12

  19. servers applications Friday, July 20, 12

  20. Friday, July 20, 12

  21. 0 500,000 1,000,000 1,500,000 2,000,000 Applications Running On Heroku Friday,

    July 20, 12
  22. De  Facto  Standards Access SQL Server C# .net FileMaker SQLite

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

    C MySQL SQLite PostgreSQL C Perl PHP Python Friday, July 20, 12
  24. addons.heroku.com Friday, July 20, 12

  25. postgres://user:pass@cloudprovider.com/dbname Friday, July 20, 12

  26. why cloud services? Friday, July 20, 12

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

    12
  28. backups testing restores fire drills pages on-call ... wash, rinse,

    repeat Friday, July 20, 12
  29. fire and forget heroku addons:add heroku-postgresql Friday, July 20, 12

  30. Easy Trusted Productized cloud service benefits Friday, July 20, 12

  31. Demo Time Friday, July 20, 12

  32. Easy Friday, July 20, 12

  33. cloud services requires Friday, July 20, 12

  34. Scalability Operability Open Source cloud services requires Friday, July 20,

    12
  35. you better trust your vendor closed source + cloud Friday,

    July 20, 12
  36. fire your vendor any time open source + cloud Friday,

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

    12
  38. the business model for open source (a brief aside) Friday,

    July 20, 12
  39. NoSQL Cloud Friday, July 20, 12

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

    12
  41. Postgres’ time has come (so use it in the cloud)

    Friday, July 20, 12
  42. one more thing Friday, July 20, 12

  43. Friday, July 20, 12

  44. Q & A Friday, July 20, 12