Re: Postgress and MYSQL

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Matt Davies <matt(at)mattdavies(dot)net>
Cc: Dustin Sallings <dustin(at)spy(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Postgress and MYSQL
Date: 2004-01-14 18:45:07
Message-ID: 40058E33.5020302@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-general


>1. Replication: Like it or not most people regard their data and access to their
>data as 'invaluable'. If not, why are they storing it. Having a secondary
>server (read slaves) on which you can perform backups, load balance RO traffic,
>and eventually use as a failover has been one of the great selling points of
>MySQL for my specific applications. I wish there were a Master-Master
>replication scheme out there, but that is not the case.
>
>
>
Replication exists in multiple manners for PostgreSQL. There is Mammoth
replicator (our product),
ErServer (pgsql.com's product), dbmirror, Rserv, and pgCluster.

>2. Documentation: In delving deeper into the Postgress database I have tried to
>find whatever I can to learn more. I have found an Oreilly book out there, but
>the TOC reads almost the exact same as the online documentation. I ask myself -
>have they lifted the documentation and are now trying to sell me it bound in
>book form?
>
I am sorry but I am the co-author of that book and I can tell you the
only thing in that
book that reads like the documentation is the reference chapter and the
appendixes.
Not to mention that PostgreSQL.Org has some of the most complete
documentation
of any software out there.

There are also several books on PostgreSQL including the O'Reilly one,
the Addison
Wesley one, the Sams one... and I think even a PTR one.

>MySQL marketing has done much to help the average database user out there feel
>like they are getting a powerful and feature-rich database. The average user
>out there is doing nothing more than address books and recipe books. They,
>
>
MySQL has what 19 million in the bank?

>I have ranted about this for a point. It is not what the seasoned 20 year UNIX
>veteran knows about a database/OS that really matters in terms of adoption - it
>is what the general mass of people __THINKS__ matters. They are becoming ever
>present in high levels of decision making functions. Perception is the key.
>
>
>
This is very true. Perception is the key.

Sincerely,

Joshua D. Drake

>My $0.02.
>
>
>
>
>
>
>Quoting Dustin Sallings <dustin(at)spy(dot)net>:
>
>
>
>>On Jan 14, 2004, at 0:08, Anton(dot)Nikiforov(at)loteco(dot)ru wrote:
>>
>>
>>
>>>around. To make PG known there should be more and more products that
>>>relay on PG. And this should be not Banking or other mission critical
>>>projects. It should be a simple forums, picture bases i do not know
>>>
>>>
>> This is very insightful. mySQL is not popular in the enterprise
>>because it's known to solve big problems, but because it's known to
>>solve little ones. It seems so wrong, but makes so much sense.
>>
>>--
>>Dustin Sallings
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 4: Don't 'kill -9' the postmaster
>>
>>
>>
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
>

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Ben 2004-01-14 19:02:51 Re: Postgress and MYSQL
Previous Message Peter Eisentraut 2004-01-14 18:35:42 Re: Postgress and MYSQL

Browse pgsql-general by date

  From Date Subject
Next Message ezra epstein 2004-01-14 18:57:27 Re: Quoting for a Select Into - Please Help
Previous Message Joshua D. Drake 2004-01-14 18:40:25 Re: Pl/Perl speed