RE: MySQL or Postgres

[Ben Edwards <ben@videonetwork.org>]

"Where MySQL loses points in the daemon robustness department, it makes up 
for it by apparently never corrupting its data files. The last thing you 
want is your precious data files fouled randomly, and MySQL does well here. 
In over a year of running MySQL, I haven't ever seen a single case of 
database or index corruption. In the same timeframe, I have done 2 or 3 
recoveries of a couple different Postgres databases. (irregardless, backups 
are always your best friend, as shown by the database fiasco here on 
PHPBuilder) "

This clinched it.  Although I was keen to use postages due to its better 
functionality, the issue with it corrupting data files means I will be 
going for MySQL.

At 12:04 24/03/2003 +0100, Snijders, Mark wrote:

> sorry the url I gave was of a weird language..
>
> this one is better:
>
> http://www.phpbuilder.com/columns/tim20000705.php3
>
>
>
> -----Original Message-----
> From: Ben Edwards [mailto:ben@videonetwork.org]
> Sent: maandag 24 maart 2003 12:03
> To: php-db@lists.php.net
> Subject:  MySQL or Postgres
>
>
> Could someone please point me in the correct direction for a decent
> comparison of the two in respect of:-
>
>    Reliability
>    Scalability
>    Speed
>    Functionality
>
> These are actually in order or importance to me (I know both are fairly
> fast).
>
> I am also interested in how easy it would be to migrate from MySQL to
> Postgress.
>
> Proples general experiences/comments also welcome.
>
> Beb
>
> ****************************************************************
> * Ben Edwards                              +44 (0)117 968 2602 *
> * Critical Site Builder    http://www.criticaldistribution.com *
> * online collaborative web authoring content management system *
> * Get alt news/views films online   http://www.cultureshop.org *
> * i-Contact Progressive Video      http://www.videonetwork.org *
> * Smashing the Corporate image       http://www.subvertise.org *
> * Bristol Indymedia               http://bristol.indymedia.org *
> * Bristol's radical news             http://www.bristle.org.uk *
> * PGP : F0CA 42B8 D56F 28AD 169B  49F3 3056 C6DB 8538 EEF8     *
> ****************************************************************
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003

****************************************************************
* Ben Edwards                              +44 (0)117 968 2602 *
* Critical Site Builder    http://www.criticaldistribution.com *
* online collaborative web authoring content management system *
* Get alt news/views films online   http://www.cultureshop.org *
* i-Contact Progressive Video      http://www.videonetwork.org *
* Smashing the Corporate image       http://www.subvertise.org *
* Bristol Indymedia               http://bristol.indymedia.org *
* Bristol's radical news             http://www.bristle.org.uk *
* PGP : F0CA 42B8 D56F 28AD 169B  49F3 3056 C6DB 8538 EEF8     *
****************************************************************

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php