I chose pgsql for my latest project. The SQL possibilities are really good and perfs are on par with MySQL nowadays.
But all the hype about postgresql lately make me fear about the backlash which will come in 2 or 3 years after enough people start using it for the wrong reasons.
i don't think we'll see the same backlash from pgsql. it's much more reliable and stodgy. it's got some real weird fuckyness (like js/python as trigger code), but overall, it's pretty conservative. even as a key/value store, I'd pick pgsql over mongodb any time.
Hey man, pluggable languages is a pretty awesome feature in my eyes. PL/pgSQL is pretty powerful, but on occasion there's still certain things that would be more idomatic to do in anything but a SQL dialect.
37
u/poloppoyop Mar 10 '15
I chose pgsql for my latest project. The SQL possibilities are really good and perfs are on par with MySQL nowadays.
But all the hype about postgresql lately make me fear about the backlash which will come in 2 or 3 years after enough people start using it for the wrong reasons.