Re: PostgreSQL or MySQL ?

jag skrev:
Hiya,

I'm planning to build an enterprise-level php web app which will be
used to manage a large amount of users and which will get a lot of
hits.

so, which database setup should i use?

got 2 choices,

PostgreSQL or MySQL

have used MySQL before but heard good stuff about PostgreSQL.

I have used both. Love Postgres. Hate MySQL.

People may tell you that Mysql has better performance. I believe a lot
of this comes from people doing single-table selects or simple joins
from ISAM tables. I have often been writing queries in Postgres that I
could never have done in MySQL - so when I was using MySQL, I would have
to code them procedurally on the webserver.

The documentation for Postgres is excellent. They have separate copies
online for the different versions, and clearly indicate the changes and
any deviations from the SQL standards.

The documentation for MySQL covers all versions at once. This means you
cannot just look at the syntax diagrams and assume that they apply to
the version you are running.

Postgres supports transactions, subselects, foreign keys, constraints,
updatable views (via RULES or TRIGGERS) and stored procedures/functions
in several languages - all in the standard configuration.

MySQL ... may support some of these out of the box, and most of them
with a little tweaking. Often they are implemented with gotcha's - "you
can't use a subselect there", "foreign keys only work with INNODB
tables" etc.

Postgres gives you meaningful error messages most of the time. MySQL
mostly just says "You have an error in your SQL syntax;"

And, IMNSHO, if you don't have time/money for a trained DBA - Postgres
beats Oracle as well, when it comes to maintenance AND performance.
Simply because it works out of the box, and the documentation is easy to
read and follow.

Enough evangelism, have a nice day

Nis

.

Relevant Pages

  • Re: DB newbie needs suggestions for bsd-based {db + frontend} ports
    ... It's a matter of documentation. ... >>MySQL PHP) in mind, so most documentation you'll find regarding PHP and ... >>something like Postgres, which really is overkill for your situation anyway. ... > I run both MySQL and PostgreSQL databases (PG for my core business stuff, ...
    (comp.unix.bsd.freebsd.misc)
  • Re: PostgreSQL or MySQL ?
    ... PostgreSQL or MySQL ... I have often been writing queries in Postgres that I ... any deviations from the SQL standards. ... in several languages - all in the standard configuration. ...
    (comp.databases)
  • Re: PostgreSQL or MySQL ?
    ... Did 4.0 not have documentation? ... MySQL and PostgreSQL. ... MySQL does not support deferred constraint checks. ...
    (comp.databases)
  • Re: MySQL permission
    ... Are you referring to the MySQL Reference Manual ... Even I was unaware one can become any system user ... I don't see how you can think documentation is very good ... Much of Linux documentation is poor, ...
    (comp.os.linux.misc)
  • [opensuse] Re: [SUSE Linux Users] Help getting MySQL to work
    ... That's in the documentation, too. ... The MySQL website has the complete text of the 500-page reference ... because Nico didn't invest ...
    (SuSE)
Quantcast