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)

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

  • Title: Teach Me To Code

    Type:PODCAST

    Description:

  • Teach Me To Code Episode 67: TMTC 66 Josh Berkus (PostgreSQL Core Team)

  • Teach Me To Code Episode 47: TMTC 46 – Evan Light

  • Teach Me To Code Episode 74: 073 TMTC Grant Ingersoll – Lucene & Solr

  • Teach Me To Code Episode 69: Nginx with Igor Sysoev and Andrey Alexeev

  • Teach Me To Code Episode 78: 077 TMTC Karl Wright – ManifoldCF

  • Teach Me To Code Episode 21: TMTC 20 – Miles Forrest – Part 1

  • Teach Me To Code Episode 79: 078 TMTC Chris Mattmann – OODT/NASA

  • Teach Me To Code Episode 36: TMTC 35 – Joe Ferris from Thoughtbot

  • Teach Me To Code Episode 13: RC 13 – Interview with Chad Fowler – Part 1

  • Teach Me To Code Episode 10: RC 10 – Understanding and Growing Business

  • Teach Me To Code Episode 24: TMTC 23 – Bryan Liles

  • Teach Me To Code Episode 33: TMTC 32 – Mike Moore & Ruby Web Conf

  • Teach Me To Code Episode 34: TMTC 33 – Corey Haines

  • Teach Me To Code Episode 39: TMTC 38 – BDD and TDD: Integration and Unit Tests

  • Teach Me To Code Episode 4: RC 4 – Interview with Ben Johnson (binarylogic)

  • Teach Me To Code Episode 50: TMTC 49 – Hiring Developers

  • Teach Me To Code Episode 37: TMTC 36 – Legacy Code

  • Teach Me To Code Episode 63: Gregory Brown Interview – Teach Me To Code Podcast

  • Teach Me To Code Episode 7: RC 7 – Practice Makes Perfect – Coding Exercises

  • Teach Me To Code Episode 56: 55 TMTC – Finding Freelance Clients

  • Teach Me To Code Episode 5: RC 5 – Interview with James Edward Gray II

  • Teach Me To Code Episode 59: 058 TMTC Tyler Bye (ABC Network iPad App)

  • Teach Me To Code Episode 55: 54 TMTC When to Stop Testing and Get Stuff Done

  • Teach Me To Code Episode 40: TMTC 39 – Ben Curtis

  • Teach Me To Code Episode 42: TMTC 41 – Andy Hunt

  • Teach Me To Code Episode 43: TMTC 42 – Readable Code

  • Teach Me To Code Episode 46: TMTC 45 – Michael Hartl – Rails Tutorial

  • Teach Me To Code Episode 48: TMTC 47 – What is an Expert?

  • Teach Me To Code Episode 49: TMTC 48 – David Heinemeier Hansson

  • Teach Me To Code Episode 15: RC 15 – Pair Programming

  • Teach Me To Code Episode 22: TMTC 21 – Miles Forrest – Part 2

  • Teach Me To Code Episode 27: TMTC 26 – My Journey

  • Teach Me To Code Episode 28: TMTC 27 – Geoffrey Grosenbach

  • Teach Me To Code Episode 2: RC 2 – Interview with Gregg Pollack

  • Teach Me To Code Episode 3: RC 3 – Finding a mentor

  • Teach Me To Code Episode 68: Interview with Josh Berkus – Part 2

  • Teach Me To Code Episode 35: TMTC 34 – Writing Code is the Easy Part

  • Teach Me To Code Episode 44: TMTC 43 – Dave Hoover

  • Teach Me To Code Episode 71: Acceptance Testing with Evan Light and Jorge Dias

  • Teach Me To Code Episode 73: 072 TMTC Charles Max Wood on Freelancing Interview

  • Teach Me To Code Episode 62: Ryan Smith Interview – Teach Me To Code Podcast

  • Teach Me To Code Episode 9: RC 9 – Work Fulfillment

  • Teach Me To Code Episode 65: Pivotal Labs’ Javascript Setup

  • Teach Me To Code Episode 70: Rocky Mountain Ruby Conferences with Marty Haught and Charley Baker

  • Teach Me To Code Episode 32: TMTC 31 – Time Management

  • Teach Me To Code Episode 20: TMTC 19 – Kevin Rutherford Interview

  • Teach Me To Code Episode 45: TMTC 44 – Finding Balance

  • Teach Me To Code Episode 18: RC 17 – Interview with Dave Thomas from the Pragmatic Programmers – Part 1

  • Teach Me To Code Episode 12: RC 12 – Test Driven Design and Behavior Driven Development

  • Teach Me To Code Episode 53: 52 TMTC The DHH RSpec (and other) Debates

  • Teach Me To Code Episode 8: RC 8 – Interview with Pratik Naik

  • Teach Me To Code Episode 29: TMTC 28 – Agile Retrospectives

  • Teach Me To Code Episode 16: RC 15a – Pair Programming – Take Two

  • Teach Me To Code Episode 31: TMTC 30 – Agile Estimating

  • Teach Me To Code Episode 26: TMTC 25 – Eric Malamisura from AgileDash

  • Teach Me To Code Episode 54: 53 TMTC Learn Something New

  • Teach Me To Code Episode 61: Gary Bernhardt Interview – Teach Me To Code Podcast

  • Teach Me To Code Episode 19: TMTC 18 – Dave Thomas Interview – Part 2

  • Teach Me To Code Episode 80: 079 TMTC Peter Ledbrook – VMWare, Groovy, Grails

  • Teach Me To Code Episode 60: Know Your Text Editor – Teach Me to Code Podcast

  • Teach Me To Code Episode 72: State of the Podcast – What’s up with Teach Me To Code

  • Teach Me To Code Episode 51: TMTC 50 – Chad Fowler and The Passionate Programmer

  • Teach Me To Code Episode 6: RC 6 – Conferences

  • Teach Me To Code Episode 11: RC 11 – Testing Your Application

  • Teach Me To Code Episode 38: TMTC 37 – Peter Cooper

  • Teach Me To Code Episode 14: RC 14 – Chad Fowler Interview – Part 2

  • Teach Me To Code Episode 76: 075 TMTC Jim Jagielski – Apache Software Foundation

  • Teach Me To Code Episode 77: 076 TMTC Pranta Das and Bhaskar Sunkara (AppDynamics)

  • Teach Me To Code Episode 75: 074 TMTC Jonathan Ellis – Cassandra

  • Teach Me To Code Episode 57: 056 TMTC – Tom Preston-Werner (Github Co-founder)

  • Teach Me To Code Episode 66: Investing in Your Knowledge Portfolio

  • Teach Me To Code Episode 58: 057 TMTC Jamis Buck Interview

  • Teach Me To Code Episode 25: TMTC 24 – Continuous Integration

  • Teach Me To Code Episode 23: TMTC 22 – Agile Roots & Andrew Shafer

  • Teach Me To Code Episode 52: 51 TMTC Being Nice (MINASWAN)

  • Teach Me To Code Episode 1: RC 1 – What Makes a Great Developer?

  • Teach Me To Code Episode 64: Freelancing Advice – Teach Me To Code Podcast

  • Teach Me To Code Episode 17: RC 16 – The DRY Principle (Don’t Repeat Yourself)

  • Teach Me To Code Episode 41: TMTC 40 – RubyConf 2010

  • Teach Me To Code Episode 30: TMTC 29 – Ron Stephens from python411

Footer

Top End Devs

Facebook Instagram Twitter GitHub YouTube

Content & Events

  • Authors, Hosts, & Guests
  • 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.