RE: [PHP-DB] MySQL or Postgres
| From: | Ben Edwards | Date: | Mon, 24 Mar 2003 11:17:03 +0000 |
| Subject: | RE: [PHP-DB] MySQL or Postgres | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-26591@lists.php.net to get a copy of this message | ||
"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: [PHP-DB] 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 *
****************************************************************