This is a little blast from the past. I played with Postgres decades ago, but I have not kept up with it. It looks very full featured and pretty impressive.
So, this has me wondering: Why does MySQL seem to have more mind share, and I assume more market share, than PostgreSQL?
I only did some database programming when I did a little web programming when I was in college. I did basic stuff and simple joins, so I learned a lot from this chapter. I haven't yet read Seven Languages in Seven Weeks: A Pragmatic Guide to Learning Programming Languages, so I wasn't sure how deep a book could get into seven different subjects. I'm really impressed with how much I learned from this chapter; it wasn't just a quick refresher or a light tutorial.
I think it was good overview of what to expect from using PostgreSQL. Day 3 discussion was most interesting as I had no idea that features like Metaphones and Multidimensional Hypercube were already built in RDMBS. Now I’m curious if they already have or planning to include an image or sound recognition systems. I mean, this chapter makes it clear that it makes more sense to perform heavy data processing where data lives. But it would be interesting to see what other data management systems in this book have to offer!
I didn’t know PostgreSQL is used by FAA and Skype. I think it was an interesting fact.
So, this has me wondering: Why does MySQL seem to have more mind share, and I assume more market share, than PostgreSQL?