Re: Building enterprise websites with apache

jasen wrote:

AKA "LAMP" , we do Postgresql instead of Mysql at work, but it's mostly the
same.

I haev to so strongly disagree with this! In fact, I'm shocked that
someone that uses PostgreSQL could even suggest that it's about the
same --- PostgreSQL is a solid, enterprise-grade mature product;
MySQL... well, I've seen it compared to Access... True that at this
point in time, the comparison probable is unfair.

Every major and absolutely necessary feature for enterprise-grade
applications is either absent in MySQL, or is extremely new, non-mature
and therefore recommended to stay away from it (and I'm talking about
MySQL's own documentation for the latest version).

These include:

- Transactions (and no, manually locking rows doesn't even remotely
look like an excuse for not having transactions)

- Views (in a world where security is becoming the #1 issue,
particularly with web applications, it's the most unforgivable
thing, not having solid support for views)

- Sub-queries (perhaps this one is now *relatively* mature?)

And perhaps the biggest joke of all:

- Referential integrity

(I wonder if they decided to stop bragging about not having referential
integrity, or if they will always stubbornly insist that they know
better that the rest of the world and the entire scientific community
that over the past several decades have agreed on what a *relational*
database system should be)

Carlos
--
.

Relevant Pages

  • Re: EJB persistence versus Database persistence?
    ... > probably want reliable transactional and referential integrity, ... > creating your database schema, but if you do something wrong, the ... > database will pretend to be giving you transactions and referential ... I have determined that after installing MySQL 4. ...
    (comp.lang.java.programmer)
  • Re: database in python ?
    ... Transactions only supported on slow database types like innodb. ... If you ever tried it you cannot say that mysql supports transactions. ... also slower than firebird if you do some real work. ...
    (comp.lang.python)
  • Re: using php to move rows from text file into mysql table
    ... I used phpmyadmin to run an sql to insert a record into the table. ... INSERT INTO transactions ... MySQL will accept 2 or 4 digit years, ... the insertion of the quotes around $dateandtime allowed it to be accepted. ...
    (comp.lang.php)
  • Re: Python does not play well with others
    ... to OpenSSL, MySQL, and Apache all exist, but have major ... If you're doing web applications, ... they've all used mod_python and either MySQL or Postgres. ...
    (comp.lang.python)
  • Re: php or asp.net for this?
    ... >> I don't know how you can just flat out recommend MySQL for the ... MySQL 4.1 is still alpha release, ... > 2-phase commit required for distributed transactions. ... MySQL beat SQL Server, DB2, and Sybase. ...
    (comp.lang.php)