Re: [PHP] MySQL vs PostgreSQL

2003-01-08 Thread Krzysztof Dziekiewicz
What about transactions ? In all the discussion noone points that PostgreSQL uses them. Maybe noone uses transactions so they have no matter. -- Krzysztof Dziekiewicz -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] MySQL vs PostgreSQL

2003-01-06 Thread Krzysztof Dziekiewicz
I'm just deciding which DB to use for my projects and I'm not clear with one thing... When considering a database for web, is MySQL good enough? I read it only supports table locking, which is not very satisfying in such a multiuser environment as the internet.. PostgreSQL has transactions

Re: [PHP] MySQL vs PostgreSQL

2003-01-06 Thread Jim
is MySQL good enough? I read it only supports table locking, which is not very satisfying in such a multiuser environment as the internet.. Read all of http://www.mysql.com/doc/en/ANSI_diff_Transactions.html You'll find an explanation of what atomic operations are and how they compare to true

Re: [PHP] MySQL vs PostgreSQL

2003-01-06 Thread Jeffrey B. Ferland
I'm just deciding which DB to use for my projects and I'm not clear with one thing... When considering a database for web, is MySQL good enough? I read it only supports table locking, which is not very satisfying in such a multiuser environment as the internet.. PostgreSQL has

Re: [PHP] MySQL vs PostgreSQL

2003-01-06 Thread John Wells
See MySQL 4.x. They also have subselects now (HUGE!). As for an Well, not really. Nested queries are scheduled for 4.1. 4.0 is in gamma, 4.1 isn't even available for download as alpha. You'll have to go with Postgres for now if you need subselects. Regarding row locking and transactions,

Re: [PHP] MySQL vs PostgreSQL

2003-01-06 Thread Jason Sheets
Not to cause a flame war, but, MySQL and PostgreSQL are both excellent choices, MySQL tends to be a lighter less feature rich database while PostgreSQL tends to have more features, perform better under load, etc. You can read a lot about the two databases at google.com and also at postgresql.org.

Re: [PHP] MySQL vs PostgreSQL

2003-01-06 Thread Jeffrey B. Ferland
Not to cause a flame war, but, MySQL and PostgreSQL are both excellent choices, MySQL tends to be a lighter less feature rich database while PostgreSQL tends to have more features, perform better under load, etc. Under differing types of load, yes. MySQL is more hit-based, while PostgreSQL

Re: [PHP] MySQL vs PostgreSQL

2002-12-24 Thread Sean Burlington
email list. - Original Message - From: Miro Kralovic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 23, 2002 9:10 AM Subject: [PHP] MySQL vs PostgreSQL Hi, I'm just deciding which DB to use for my projects and I'm not clear with one thing... When considering a database

Re: [PHP] MySQL vs PostgreSQL

2002-12-24 Thread Jason Sheets
: Miro Kralovic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 23, 2002 9:10 AM Subject: [PHP] MySQL vs PostgreSQL Hi, I'm just deciding which DB to use for my projects and I'm not clear with one thing... When considering a database for web, is MySQL good enough? I

[PHP] MySQL vs PostgreSQL

2002-12-23 Thread Miro Kralovic
Hi, I'm just deciding which DB to use for my projects and I'm not clear with one thing... When considering a database for web, is MySQL good enough? I read it only supports table locking, which is not very satisfying in such a multiuser environment as the internet.. Based on your experience,

Re: [PHP] MySQL vs PostgreSQL

2002-12-23 Thread Rick Emery
You accidentally published this to the wrong email list. I assume you meant to send this to the MySQL email list. - Original Message - From: Miro Kralovic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 23, 2002 9:10 AM Subject: [PHP] MySQL vs PostgreSQL Hi, I'm just

Re: [PHP] MySQL vs PostgreSQL

2002-12-23 Thread David T-G
Miro, et al -- ...and then Miro Kralovic said... % % Hi, Hello! % % I'm just deciding which DB to use for my projects and I'm not clear with one % thing... When considering a database for web, is MySQL good enough? I read % it only supports table locking, which is not very satisfying in such

[PHP] MySql vs PostgreSQL

2001-05-08 Thread Brent Langston
So, I've noticed that most of you talk about PHP/MySQL almost exclusively. Does anyone use PHP and PostgreSQL? What are the advantages of MySQL over PostgreSQL, other than it's easier to pronounce... Thanks, Brent -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail:

Odp: [PHP] MySql vs PostgreSQL

2001-05-08 Thread Tomasz Wasiluk
So, I've noticed that most of you talk about PHP/MySQL almost exclusively. Does anyone use PHP and PostgreSQL? What are the advantages of MySQL over PostgreSQL, other than it's easier to pronounce... I'v been using Postgres for some time now and I think I'm going to swicth to MySQL because