Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.postgresql > #317

Re: MySQL

Show all headers | View raw

On Sat, 18 Feb 2012 22:07:09 +0100, Hans Castorp wrote:

> Having the choice is a good thing, but I wouldn't want to use a DBMS
> that is so crippled when it comes to SQL features as MySQL (CTE,
> recursive queries, windowing functions, partial indexes, function based
> indexes, check constraints, ...)

Well, many more people are still using MySQL than PostgreSQL. I wonder 
why?

> 
> Putting priority on certain features is one thing - everyone has
> different requirements.

Hints have been requested many times, by many people.


> 
> Constantly ranting about the fact that something is missing in a product
> is another thing.

It's far from constantly. As a matter of fact, I haven't been active on 
this group for months, which can be easily checked.

> 
> And that's exactly what Mladen is doing - and he only does it in the PG
> groups.

Postgres groups seem to be the right place to complain about Postgres. 
Where do you suggest I should complain about Posgtgres? 


> I have never seen him complain about all the things that MySQL doesn't
> have.

MySQL did not adopt bait and switch approach. By that, I mean the 
following: I was lead to believe that Postgres is "the most advanced open 
source database in the world" and then "forcefully directed" to buy the 
proprietary version. When I needed a feature that is really necessary in 
project development and supported by all other open source databases. I 
refused to play the game and decided to warn any other possible suckers 
and prevent them from wasting a fair amount of time to study a product 
which doesn't really deserve attention.

I also noticed that these attacks are increasingly personal, dealing with 
me personally. I was given the status of "an enemy", almost a religious 
approach. Religious approach in the arena of relational databases is 
quite strange, which is one more reason for being very careful when 
adopting Postgres.

I am an Oracle DBA with a very long history and a reputation to match. It 
is in my power to vote for or against open source products to evaluate. 
My CIO usually respects my opinion. I am exactly the kind of person that 
software vendors are trying very hard to appease when offering software. 
Trying to exorcise me from the Postgres community only shows how bad 
things are and what kind of single-minded religious zealots rule the 
church of Postgres these days.

There is something badly broken in Postgres community because MySQL is 
much more heavily used than Postgres, despite all of its deficiencies. 
The sheer number of users is sufficient to prove that statement beyond 
reasonable doubt.

I know that this will not make me very popular with the Postgres 
faithful, but this database will wither and die, unless something is 
done. I am afraid, however, that nothing can be done. Postgres is still 
heavily influenced by Michael Stonebraker, who has already been beaten by 
Oracle an is on its way to lose the rematch as well. May Stonebraker be 
with you, my friend.

Instead of adding ridiculous features like range types or pg_dump which 
can use both the primary and the standby at the same time, Postgres 
developers would do well to add hints and parallelism. That would make 
the database more popular and them look less ridiculous or religulous, to 
use the nice new word coined by Bill Maher.



-- 
http://mgogala.byethost5.com

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Find similar

Thread

MySQL Mladen Gogala <gogala.mladen@gmail.com> - 2012-02-16 22:05 +0000
  Re: MySQL Harry Tuttle <OTPXDAJCSJVU@spammotel.com> - 2012-02-17 15:49 +0100
    Re: MySQL Mladen Gogala <gogala.mladen@gmail.com> - 2012-02-18 03:06 +0000
      Re: MySQL Hans Castorp <hans.castorp@xyz.de> - 2012-02-18 07:56 +0100
        Re: MySQL Mladen Gogala <gogala.mladen@gmail.com> - 2012-02-18 18:40 +0000
  Re: MySQL Don Y <this@isnotme.com> - 2012-02-18 12:17 -0700
    Re: MySQL Hans Castorp <hans.castorp@xyz.de> - 2012-02-18 22:07 +0100
      Re: MySQL Don Y <this@isnotme.com> - 2012-02-18 15:13 -0700
      Re: MySQL Mladen Gogala <gogala.mladen@gmail.com> - 2012-02-18 22:29 +0000

csiph-web