Episode 67: TMTC 66 Josh Berkus (PostgreSQL Core Team)

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