If you're looking to use it with OSS projects there's still a big MySQL bias. If you plan on using it like MySQL, you'll quickly run into casting problems because Postgres is much stricter with types, which is good. Basically, all the downsides are actually upsides.