The authors of “Beginning PHP and PostgreSQL 8: From Novice to Professional” explain how, when and why PostgreSQL tops commercial database systems, as well as its suitability for enterprises and why end users have more control with this open source DMBS.
Why PostgreSQL Can Best SQLServer, Oracle
Submitted by Jane Walker 2006-03-21 Databases 9 Comments
The article mainly shows PostgreSQL can be a good choice (since there are people who use it successfully).
Obviously there’s probably situations where PostgreSQL is even the best choice, but the article doesn’t specify in which situation that is the case. And I guess that’s a good thing, since that’s probably impossible to specify correctly.
The “postgresql is not backed by any one company, so you can get postgresql support from many companies” is a bit weak though: you can get mysql support from many companies, too, right? I really doubt the postgresql consultancy market is a very big one.
In other words, some of the common pitfalls often found in articles like this are avoided, but we’re left with a piece that doesn’t tell us much new. Nicely written though.
another big misconception is the lack of nice GUI admin tools and this is just not true.
If you are a windows user, one of the best is PG Lightning admin, and they have a 5 dollar sale going on right now. check it out at http://www.amsoftwaredesign.com