Devchat.tv Episode Roundup

TMTC 66 Josh Berkus (PostgreSQL Core Team)

Listen Later

Here’s a list of several of the things we discussed:

  • How PostgreSQL got started
  • Ingres
  • The Apache Foundation
  • The PostgreSQL core team and it’s role.
  • Data Warehousing
  • It’s community property like Linux
  • The SQL Query Language
  • The C Programming Language
  • gcc
  • Standardization
  • Google Summer of Code
  • XML Indexing
  • XPath Support
  • ISN/ISBN Data Type
  • Array Data Types
  • HStores (Dictionary or Hash)
  • Full Text Search
  • Tri-grams
  • Sphinx
  • Lucene
  • Why people switch from MySQL
    • Performance
    • Reliability
    • Special Features
    • Supports really complex queries
    • Worry about the future of MySQL
    • Skype – 200 Postgres servers
    • Sky tools clustering platform
    • Heroku
    • San Francisco PostgreSQL User Group
    • Differences between MySQL and PostgreSQL
      • MySQL was originally written to please web developers
      • Postgres was written by DBA’s
      • Postgres will throw out a feature they can’t stabilize
      • MySQL will accept a feature and then try to stabilize it
      • Postgres really allows you to run code inside the database
      • Postgres is more reliable and secure
      • Lowers admin cost due to better uptime
      • Rails was originally built around MySQL
      • You can get some boosts by bypassing the ORM and going directly to the database
      • Full JSON support is upcoming
      • Django
      • The PostgreSQL Ruby driver
      • ByteA binary data type
      • Simplified data types (Text data type)
      • Why people switch from PostgreSQL to MySQL
        • MySQL has been commercially successful longer than postgres
        • Vendor tools
        • Cheap hosting for MySQL
        • A lot of things are designed to work out of the box with PostgreSQL
        • PGSQL Novice list
        • Postgres Open
        • Postgres has a new version coming out soon (changelog)
        • Postgres 9.2
        • Multi-core support
        • Postgres included documentation
        • Beginning Databases with Postgres – Dated but gives the basics

          • To hire Josh’s guys, go to http://pgexperts.com.

          Download 6.08 MB

          Download (iPod & iPhone) 4.61 MB

          ...more
          View all episodesView all episodes
          Download on the App Store
          Devchat.tv Episode RoundupBy Devchat.tv