4 ms·
As a long time user of both PostgreSQL and MySQL, I can't begin to compliment PostgreSQL enough. It runs just about everything in our company, from ticketing sy
by rufugee 17y ago
As a long time user of both PostgreSQL and MySQL, I can't begin to compliment PostgreSQL enough. It runs just about everything in our company, from ticketing systems to an ERP system with over 1000 users...and it does so without flinching or making a fuss.
It's stored procedure support is very nice, and allows you to write procedures in the built in PGPSQL. However, if that syntax doesn't sit well with you, you can also write them in Tcl, or Perl, or PHP, or Ruby, or Java, or...you get the idea. Our ERP's stored procedures are all written in Java, for the record.
The stability has been incredible...the community support, wonderful.
And it's really, really free, to boot.
I haven't really faced a lot of the problems others have with MySQL, but that's probably because for the applications that have mattered, I've always gone back to PostgreSQL. And the whole commercial/non-commercial licensing FUD MySQL AB historically spread about when you actually had to buy a license just left a bad taste in my mouth. I'm ok with buying licenses and am happy to, but don't enjoy or
appreciate that need being fabricated by sales staff.