Top End Devs Logo Top End Devs Logo
Dashboard Podcasts Screencasts Courses Coaching Calendar
Sign In
Dashboard Podcasts Screencasts Courses Coaching Calendar
Sign In

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

Teach Me To Code

Subscribe

  • RSS

Follow

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

Download MP3
Published : Jul 24, 2011
Duration : 55 Minutes

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

Footer

Top End Devs

Facebook Instagram Twitter GitHub YouTube

Content & Events

  • Authors, Hosts, & Guests
  • Meetups
  • Commerce
  • Insights

Support

  • Pricing
  • Documentation
  • Guides
  • API Status

Company

  • About
  • Blog
  • Jobs
  • Press
  • Partners

Legal

  • Claim
  • Privacy
  • Terms

© 2023 Intentional Excellence Productions, LLC. All rights reserved.