Show Notes
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