Dunc-IT

Changing Of The Guard

In working on another issue, recently, I was forced into a new dbms. Initially, I resisted the change - as I figured I had already worked with too many databases (Datacom, DB2, SQLServer, Oracle and MySQL). But the more I've played with this software the more I find that I like Postgres!

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