Linked by Eugenia Loli-Queru on Tue 21st Mar 2006 18:16 UTC, submitted by Jane Walker
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.
Thread beginning with comment 106690
To read all comments associated with this story, please click here.
To read all comments associated with this story, please click here.
Recent Original Stories
Recent Comments
Headlines
Random Comments
Random Stories
Random OS Link
Member since:
2005-10-20
But when I wanted to have some transaction features, I moved to PostgreSQL. For developers, version 8.1 provides very good API's.
With a default install a ODBC. .NET and JDBC driver is provided. Also got installed was a ver good client in the form of pgAdmin III. Connecting from C# Express was very easy, and I got all the features of Oracle that I normally use.
Apart from the excellent transaction support, the normal features like stored procedure, are very easy to implement. The GUI Client pgAdmin III provides an excellent interface for defining all the tables, functions, trigger, operator, procedures etc.
It also gives the corresponding SQL used in defining all the above created tables and functions.
Even a SQL novice will find it easy to define and use all these.
Then we have a query editor, where we can easily execute the normal queries, best part is the error descriptor. If there is any error in the query, the description is so detailed that I always find the error in the query.
Again, maybe from enterprise point of view we look for some specific properties in the SQL Server, but from developer point of view, I find it almost as usable as Oracle 10g.