Hello from PostgreSQL East

Today is the first day of the PostgreSQL Conference in Philadelphia, PA. I’m here specifically to attend training on Sunday, but since we had to pay the conference fee to take the training, it would be silly not to sit in on the sessions.

I’ve been learning a lot, probably because I have very limited experience with PostgreSQL before now. I’ve been playing with it for a couple of weeks in my spare time, and I’m really liking the feature set. If you’re solely a MySQL person, let me encourage to give you a shot. The installation isn’t difficult at all (in fact, most distros include it via the local package manager, which is great for playing around with).

Before now, I’d only really played with MySQL. I’m already envisioning things to do with PostgreSQL, and I keep thinking back to all of the times I was writing PHP code and wished the database could natively store arrays. Well, PostgreSQL can. Also, geometric shapes, and IP addresses, MAC addresses, etc etc. Really, you should just go check out the list of data types. It’s…*ahem* extensive.

Anyway, as I said, I’m having a good time. I met Jason Dixon, finally, after we’ve talked on twitter for ages. He was demoing Circonus, which is a SaaS monitoring / trending service. From what I saw, the interface looks nice. I’m guessing it’ll have a lot of business from people who don’t want to deal with monitoring on their own. In any event, their interface is slick.

So I’ve got a few more days here, and I’m going to try to make the most of them. If you’re here, let me know and we’ll meet up for dinner or drinks some night. If not, then I’m sure I’ll catch you at PICC in May. right? Right!

  • denish

    see you tomorrow for sure.

  • Pingback: Tweets that mention Hello from PostgreSQL East | Standalone Sysadmin -- Topsy.com()

  • john

    i’m coming from an mssql background and i’m going to be implementing a postgres instance on site to support a vendor app. the only problem i’m having is choosing a clustering solution as it seems there are close to 100 available. pgpool seems to be the most popular. whenever i look at feature set comparisons between mysql and postgres i’m always suprised by the extent to which mysql is more popular.

  • Matt – congratulations on discovering PostgreSQL. I’ve been a fan of it for a decade now, and have generally preferred it to MySQL. For some reason PostgreSQL seems more comfortable to me (maybe because way back in the distant past as a system administrator I worked from time to time with Ingres databases, and there’s some common ancestry there). Having recently worked with MySQL on a project, I have to say I was surprised at how frustrating I found it after years of PostgreSQL habits. Both however are getting increasing visibility in enterprise situations though, which is great.

  • Gianluca Riccardi

    @Matt, ciao

    i’m glad you’re having a good “DB” time ;)

    keep on and bring PostgreSQL into production! ;)