"Greg Wright" <[EMAIL PROTECTED]> wrote:
> On 5/07/00 at 17:49 Ivan Jager wrote:
>
> >What are the main differences between MySQL and postgresql? I would like
> >to keep squid's logs in a database to be able to make some queries and
> >all that. :)
> >
> >I was going to use postgres, but now that MySQL is Free it makes me
> >wonder...
> >
> >What are the advantages/disadvantages of current versions of postgres
> >and MySQL?
> >
>
> PostgreSQL is more of a full featured database, MySQL is fast and light
> because its a "cut down" SQL server if you like
>
> For logging, MySQL would be more than sufficient in my limited database
> opinion
But by the same token, PostgreSQL (with an excellent stable
version under the BSD license!) is also likely to be
sufficient. Whatever speed advantage MySQL (with a GPL
version that is merely beta!) has is likely to be
irrelevant.
Allow me to indulge in a bit of philosophy here:
Do you always know the scope of the job when you start
working on it? If so, then you can ask a question like
"What's the bare minimum that I need to get this job done?"
For example, when I started working on a small job, I used
to tell myself things like "Oh, I don't need perl for this,
I'll just write a little shell script." Then the shell
script starts getting bigger, I start thinking of other
things I'd like it to do, and I start running into some
painful walls (not insurmountable, but painful -- though
it's funny, one of the worst is the poor docs for grep
vs. perl) and it dawns on me that I'm going to have to throw
the damn thing away and re-write it in perl anyway, and I
start wondering where did I ever get the notion that it's
best to work with the simplest possible tool...
(CS geeks seem really obsessed with minimalism to me, which
is okay I guess, as long as you don't minimize the wrong
quantity.)
Anyway, I think the question here isn't "Which tool is right
for the job"... as far as we know at this point, both tools
are okay. A more important question might be "Which culture
do you want to buy into?"
MySQL, until very recently, wasn't really commited to open
source, but they did a good job of convincing web kids that
they were the good guys.
Postgresql, on the other hand, is a serious database, a
really professional quality tool, and it's been BSD
throughout it's existence.
_______________________________________________
Redhat-devel-list mailing list
[EMAIL PROTECTED]
https://listman.redhat.com/mailman/listinfo/redhat-devel-list
