RES: Advantages of PostgreSQL over MySQL 5.0

Hi James :

I am mysql user for 5 years. An a this time i am trying to go out from
mysql.

What i am living mysql?
Becouse my php bases systems require some features that mysql is
inplementing in the vercion 5.0, like store procedures and functions,
trrigers, transaction, views, and some others features.
Dou you now how to lock a counter table to users have no access to this
table mysql ?

Table two field, identerprise and counter

Mysql, to lock write, you have to lock entire table for write.

LOCK TABLES co_nro_notas WRITE.

SELECT counter
FROM co_nro_notas
WHERE identerprise = 1

Update co_nro_notas
SET counter = counter + 1

UNLOCK TABLES

This is a problem when do you have two or more enterprise runing in the same
database, an each with more than 10 users.

In postgresql each enterprise have your own record, and eachone can lock his
record.

You use a SELECT with a FOR UPDATE.

Try postgresql, is better than mysql.

I am dice to migrate all my systems to postgresql.

PD:

I try postgresql in 2002, but a this time postgresql does not have windows
vercion, this is the reason for use mysql,
have not other reason.

Alejandro M.S.
Porto Alegre
Brasil

-->-----Mensagem original-----
-->De: pgsql-general-owner(at)postgresql(dot)org
-->[mailto:pgsql-general-owner(at)postgresql(dot)org] Em nome de Jimbo1
-->Enviada em: quarta-feira, 22 de março de 2006 08:06
-->Para: pgsql-general(at)postgresql(dot)org
-->Assunto: [GENERAL] Advantages of PostgreSQL over MySQL 5.0
-->
-->
-->Hello there,
-->
-->I'm a freelance Oracle Developer by trade (can almost hear
-->the boos now ;o)), and am looking into developing my own
-->Snowboarding-related website over the next few years.
-->Anyway, I'm making some decisions now about the site
-->architecture, and the database I'm going to need is
-->obviously included. If my site works out, I'm expecting
-->reasonably heavy traffic, so want a database that I'm
-->confident can cope with it.
-->
-->It is out of the question for me to use Oracle, although I am a
-->(biased) 'fan' of that RDBMS. I definitely need to go for a
-->cheaper route, and to that end I'm looking at either MySQL
-->or PostgreSQL.
-->
-->Regarding MySQL, I've been put off by Oracle's recent
-->purchase of InnoDB and realise this could badly impact the
-->latest version of the MySQL database. I can almost hear
-->Larry Ellison's laughter from here (allegedly)! I've also
-->been put off by the heavy marketing propaganda on the MySQL website.
-->
-->Recently, I've been taking a look at PostgreSQL, and am very
-->impressed by what I've read, although I've not yet
-->investigated the database first-hand. To cut to the chase, I
-->would be interested in anybody's feedback on the advantages
-->that PostgreSQL has over MySQL.
-->
-->Also, I've recently read the "Inside MySQL 5.0" (marketing
-->propaganda) document, and it makes the following claim:
-->
-->"With MySQL, customers across all industries are finding
-->they can easily handle nearly every type of database
-->workload, with performance and scalability outpacing every
-->other open source rival. As Los Alamos lab (who uses MySQL
-->to manage their terabyte data warehouse) said, "We chose
-->MySQL over PostgreSQL primarily because it scales better and
-->has embedded replication.".".
-->
-->If any PostgreSQL devotees on this group can comment on the
-->above and its accuracy/inaccuracy, I'd really appreciate it.
-->
-->Thanks in advance.
-->
-->James
-->
-->
-->---------------------------(end of
-->broadcast)---------------------------
-->TIP 6: explain analyze is your friend
-->
-->
-->--
-->No virus found in this incoming message.
-->Checked by AVG Free Edition.
-->Version: 7.1.385 / Virus Database: 268.2.6/287 - Release
-->Date: 21/3/2006
-->
-->
-->--
-->No virus found in this incoming message.
-->Checked by AVG Free Edition.
-->Version: 7.1.385 / Virus Database: 268.2.6/287 - Release
-->Date: 21/3/2006
-->
-->

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.2.6/287 - Release Date: 21/3/2006

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.2.6/287 - Release Date: 21/3/2006