Home > Archive > PHP SQL > April 2004 > PostGreSQL
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| White Wolf 2004-04-09, 8:30 pm |
| Hi,
It is probably FAQ, if it is please just point me to it. Reading what mySQL
can do and what PostGreSQL I could not figure it out why do people choose
mySQL and not PostGreSQL. I thought it is a licensing issue, but PostGre is
open source (BSD IIRC). With PostGre and the views, triggers, stored
procedures etc. there seems to be just so much more power at hand to make a
robust database. Could you tell me what is the reason why every is using
mySQL? I am not trying to promote PostGre, I am just puzzled.
--
WW aka Attila
:::
It takes one tree to make 10,000 matches, but one match to burn 10,000
trees.
| |
| Nikolai Chuvakhin 2004-04-10, 8:30 pm |
| "White Wolf" <wolof@freemail.hu> wrote in message
news:<c57c77$v4$1@phys-news1.kolumbus.fi>...
>
> It is probably FAQ, if it is please just point me to it. Reading what mySQL
> can do and what PostGreSQL I could not figure it out why do people choose
> mySQL and not PostGreSQL.
1. If I remember correctly, PostgreSQL still needs to run SWEEP
every once in a while.
2. If I remember correctly, PostgreSQL data table formats are
incompatible across versions.
3. PostgreSQL is distributed only in source codes. The server does not
have a Windows native version, so you have to run it under Cygwin;
there is a native client for Windows, but you still have to compile
it yourself.
4. MySQL AB does a decent job at promoting its products, including
conferences, advertising in trade press, participation in benchmark
tests (e.g., "the database clash"), etc.
Cheers,
NC
| |
| White Wolf 2004-04-10, 10:30 pm |
| Nikolai Chuvakhin wrote:
> "White Wolf" <wolof@freemail.hu> wrote in message
> news:<c57c77$v4$1@phys-news1.kolumbus.fi>...
>
> 1. If I remember correctly, PostgreSQL still needs to run SWEEP
> every once in a while.
What is this SWEEP? I could not find any documentation.
> 2. If I remember correctly, PostgreSQL data table formats are
> incompatible across versions.
Hm. I wonder why is that. That means basically money, because either you
stop to upgrade or you will need two parallel datbases running... :-(
> 3. PostgreSQL is distributed only in source codes. The server does not
> have a Windows native version, so you have to run it under Cygwin;
> there is a native client for Windows, but you still have to compile
> it yourself.
In theory that is not a problem for me.
> 4. MySQL AB does a decent job at promoting its products, including
> conferences, advertising in trade press, participation in benchmark
> tests (e.g., "the database clash"), etc.
I see. :-)
Thank you!
--
WW aka Attila
:::
Not one shred of evidence supports the notion that life is serious.
| |
| White Wolf 2004-04-10, 10:30 pm |
| Nikolai Chuvakhin wrote:
> 3. PostgreSQL is distributed only in source codes.
After answering to your post I just have found several binaries for
PostgreSQL on their FTP. It seems that they do have binary distro for
several linux versions, although they say (for SuSe at least) you are better
off getting a build from SuSe.
--
WW aka Attila
:::
Many of the truths we cling to depend greatly on our own point of view.
-Ben Kenobi, 'The Return of the Jedi'
|
|
|
|
|