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
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
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
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
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,
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.
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
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
: 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
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,
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
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
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:
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
14 matches
Mail list logo