PostgreSQL, I wish
Posted Aug 20, 2012 23:15 UTC (Mon) by khim
In reply to: PostgreSQL, I wish
Parent article: MariaDB: Disappearing test cases or did another part of MySQL just become closed source?
Perhaps the shadow of MySQL is what is keeping PostgreSQL from greater acceptance
Nope. It's the same thing which keeps PHP alive: availability on cheap hosting. Now, just why MySQL is available on cheap hosting and PostgreSQL is premium? First of all is of course, speed: on tiny databases and trivial requests MySQL is still faster. Another important capability: upgradeability. MySQL can be upgraded and downgraded in seconds. The latter capability is important for cheap hosters: they can plan for upgrades, but they can not test these upgrades. They really need the ability to migrate clients to new version and back in seconds. You can easily install two versions from MySQL and PostgreSQL side-by-side, but with MySQL you can easily go back and forth (depending on the reaction of clients) while PostgreSQL requires dump/restore cycle. Not acceptable.
Now, you may say that for "serious users" this is not an important capability. And I agree. But "serious users" are not born that way. They start from some position. And usually they start from MySQL. And then few years down the road PostgreSQL is fighting with users who knows MySQL, who lives with MySQL and for whom PostgreSQL is technology from Mars. Why will they switch without really serious reasons?
It's much easier to attract newbie rather then attract someone who've invested time and money in the competitor technology - and PostgreSQL developers for years refuse to admit that.
to post comments)