Postgre

I am currently using the windows version and to let you in on a secret...





It is good stuff =)

Now.

I have yet to ascertain if it is good in huge databases, but I can say it is definitely better than mySQL. Which is a shadow of itself ever since Oracle took over.

Here is hoping that Postgre will go the distance =)




A few bits o' weirdness though.


1) You really need to work out the SQL statements (with ' or or ").
2) Standard SQL - no funny vendor specific syntax


Both are not Postgre's fault but can be a little irritating when you are converting.

BUT!

having said that, i think it is good to have standard syntax.

1) It maintains the Open Source as Open (i.e. it is really FREE OPEN SOURCE)
(again free as in Libre and not Beer)

2) Once you use standard syntax, you will be enlightened. =) (My colleague did remark that Postgre is actually easy to use and reliable once you get the hang of it, before using, my colleague was rather despondent about the whole thing : She needed to get perl and php to talk to Postgre - which all worked out in the end =))

3) I think Postgre's current implementation is in a good compromised stage. It is alot more accessible due to its (very good) port to windows. In the past Postgre was the cream of the crop in the FREE source world, mySQL was the popular kid due to its accessibility to the windows crowds. The problem was windows users (who tend to be a little softer - yes I admit i am a wussie) find that mySQL hits a bottleneck in performance, then switch to some "Enterprise" commercial software. Not cool. Nobody went to Postgre from this crowd, as the crowd rarely bit the bullet and jumped into the Linux oasis. (Granted I am being unfair here, there are many reasons not to use linux, incumbent environment, incumbent software, administrator's expertise, management view of software and its management etc). But now with its newfangled port to windows! Kazaam!!! I luvz it it =D


Keep it up FOSS!!!!