Database Reference
In-Depth Information
To that end, following is a list of the products that I have used extensively with Post-
greSQL:
•
Pentaho Data Integration (kettle)
: This is an outstanding
Extract
Transform and Load
(
ETL
) tool
•
Pentaho Report Server
: This is a great reporting engine
•
PgAdmin3
: This is an awesome database administration tool
•
php5-postgesql
: This is a package to allow native access to PostgreSQL
from PHP
•
Qcubed
: This is the PHP development framework with PostgreSQL sup-
port
•
Yii
: This is another great PHP development framework
•
Talend
: This is another ETL tool that works, but was not my favorite
•
BIRT
: This is a great JAVA reporting tool with easy report creation envir-
onment
•
psycopg2
: This is the Python bindings for PostgreSQL
These tools have made the PostgreSQL development experience a breeze and is
no where near a complete list. We could fill this topic with just a list of applications
that support PostgreSQL and thanks to its liberal license, PostgreSQL is embedded
in many commercial applications and you never really know it.
Lesson learned
: Don't worry too much about how many tools are out there for the
product. The ones that matter are available.
Platform compatibility
SQL Server is a Microsoft product. As such, it was and will always be a Microsoft
platform tool. It is accessible to some limited degree via ODBC, but is not a serious
choice for cross-platform development.
MySQL and PostgreSQL support every operating system currently available today.
This ability (or lack of limitation) is a strong argument for long term stability. If any
particular operating system is no longer available, or no longer supports open source
software, it is fairly trivial to move the database server to another platform.
Lesson learned
: In the commercial operating system wars, just say no.
