Обсуждение: PostgreSQL vs Mysql for website?

In a discussion with a local Linux enthusiast we were discussing which
would be better for a small website project to be driven by PHP and hosted by
nix/nuz and apache.  I have seen that Mysql does not support unions,
transactions, subselects.  PostgreSQL supports subselects and transactions. I
don't know about unions.  In any case
performance is not an issue because of size of project so primary considerations
would be:

1.  learning curve/ease of use/functions supported
1b. quality of documentation
2.  reliability
3.  availability of prewritten apps for reuse
4.  others overlooked?


Also, while looking at the PostgreSQL website we noticed this curious
comment at the page containing their comparison chart against competitors which
omitted Mysql.

"This comparison is only a comparison of RDBMSs so MySQL is missing. It may be
added at a later date. "

PostgreSQL Features Comparison Chart -
http://www.postgreSQL.org/doxlist.html

It would appear that  Mysql is not a "RDBMS". Anyone know what it is lacking
that causes it to not be?

Are there major differences in indexing support between the PostgreSQL and
Mysql?

If there is anything sensitive about any of this please email me directly.
Thanks

Scott Perkins, Atlanta, GA  770/973-3860
Director, VULA (Vintage Ultra and Lightplane Assoc.)

> In a discussion with a local Linux enthusiast we were discussing which
> would be better for a small website project to be driven by PHP and hosted by
> nix/nuz and apache.  I have seen that Mysql does not support unions,
> transactions, subselects.  PostgreSQL supports subselects and transactions. I
> don't know about unions.  In any case
> performance is not an issue because of size of project so primary considerations
> would be:
>
> 1.  learning curve/ease of use/functions supported
> 1b. quality of documentation
> 2.  reliability
> 3.  availability of prewritten apps for reuse
> 4.  others overlooked?
>

Please see the FAQ item on the web site discussing comparisons between
PostgreSQL and other dbms's.  I can answer any questions you have.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026