Re: PostgreSQL Advocacy, Thoughts and Comments

Chris Travers wrote:
>
> Here is a paper I have written for the purposes of providing some
> additional educational material for the MySQL crowd.

Here's my contribution:

Why I choose PostgreSQL (PostgreSQL in 21 Seconds)

I choose referential integrity, meaning my lookups always work.

I choose stored procedures, meaning all my developers - Windows or Unix,
Perl, C++ or Java - can access the database in the same way, using the
same locking, with the same checking and cleaning

I choose subselects and outer joins, which allow me to build complex
queries to get exactly the information I want from the database, rather
than wasting my time munging data in my code. Even better, I can put
those common queries into stored procedures, so other developers can get
the same results as I do!

I choose partial indexes, so lookups on NULL fields are just as fast if
not faster.

I choose a user community that believes getting the results right is
more important than getting them quickly.

I choose getting the right results, right now!

I choose funny capitalisation, and a name that can't be pronounced!

I choose PostgreSQL.