First of all, it's open source and being the cheap guy that I am I love that! I also love, and appreciate, the fact that it runs on a variety of hardware so I wont be locked into anything. But most of all, I love the embedded language(s) for stored procedures. In my opinion, the lack of an embedded language is MySQL's greatest shortcoming. PL/PgSQL is syntactically very similar to PL/SQL - which is wonderful! So, that I don't have to learn yet another language. But even better then PL/PgSQL is the way that other languages can be used for database events and stored procedures - such as, PL/Pythonu and best of all PL/Perl and PL/Perlu! It's going to take some time, but my plan is to convert all of my local databases over to Postgres - something that I, essentially, knew nothing about only a week or so ago.
Leave a comment