Five Reasons To Use PostgreSQL

By Angsuman Chakraborty, Gaea News Network
Friday, August 18, 2006

PostgreSQLFive reasons, without the satire, for using PostgreSQL open source database.

Availability on multiple platforms
PostgreSQL is available on every modern Unix-compatible operating system, windows, and ports are also available for Novell NetWare and OS/2.

Professional development and administration tools

The following list summarizes just a few of the tools available to PostgreSQL developers:

  1. Database modeling: Several commercial and open source products are at your disposal for data modeling, some of which include Visual Case and Data Architect.
  2. Administration and development: There are numerous impressive efforts going on in this area, and three products are particularly promising. pgAdmin III has a particularly long development history and is capable of handling practically any task ranging from simple table creation to managing replication across multiple servers. Navicat PostgreSQL offers features similar to pgAdmin III and is packaged in a very well-designed interface. A good, Web-based tool is phpPgAdmin.
  3. Reporting: PostgreSQL interfaces with all mainstream reporting tools, including Crystal Reports, Cognos ReportNet, and the increasingly popular open source reporting package JasperReports.

Support for multiple programming languages
PostgreSQL supports C++, C#, JDBC, Perl, PHP, Python, Ruby, Tcl, Ada, Common Lisp, Pascal

Technical Support
Free support via IRC (irc.freenode.net #postgresql?), detailed downloadable documentation.
Paid incident or 24×7 support available too.

Supports enterprise requirements
Enterprise can choose EnterpriseDB, a version of PostgreSQL, which has reimplemented features such as data types, triggers, views and cursors that copy Oracle’s behavior, instead of significantly higher priced Oracle.

Summarized from TechTarget

Discussion

said
February 27, 2008: 3:42 am

je realise une application d un centre d ‘appel
tu peut m’aidez :
je realis� avec la language Java +postgreSQl

August 23, 2006: 6:31 am

Another good addition.
Good to see you blogging again.

– Angsuman

August 22, 2006: 8:25 pm

hi there,

how about bizgres, the BI engine on top of postgreSQL. they recently released a massively parallel DB cluster that impressed Tim O’Reilly a lot.

BR,
~A

YOUR VIEW POINT
NAME : (REQUIRED)
MAIL : (REQUIRED)
will not be displayed
WEBSITE : (OPTIONAL)
YOUR
COMMENT :