> > What is the groups opinions regarding MySQL vs PostgreSQL?
> >
> > MySQL - Not free for commercial use
> > Not a full SQL implementation
> > Speedy(though I don't know how much this gap is with PgSQL 7.0 but
> > it has been closing with each new PgSQL release.)
> > Best used for simple read/write to tables (data storage)
> >
> > PgSQL - FREE!
> > Very close to full SQL compatibility (especially with 7.0)
> > Very nice additional PgSQL special features
> > Some stuff poorly documented
> > Best used for more complex uses (data manipulation) or where SQL
> > compatibility is important or because it's FREE!
This seems like a reasonably fair comparison. I'm a
postgresql user in part for political reasons (the MySQL
license is really squirrelly, and this kind of nonsense
just shouldn't be encouraged). I think a lot of younger
geeks are somewhat confused about this because Slashdot uses
MySQL, and they assume that (a) it must be technically slick
and (b) it must be politically correct (i.e. open/free).
My take on this is that MySQL's usefulness is limited to
something like Slashdot, which is a high hit-rate site
that has to push a lot of data around, and yet paradoxically
no one really cares about the data all that much (if you
drop a few comments out of a thread, no one is going to sue
you).
(This is presuming that MySQL really *is* fast... I haven't
benched it myself, and everyone I've talked to seems to be
relying on data posted on the MySQL site.)
I like the fact that postgresql is more of a "real" database
than MySQL... even if I don't have any plans to use
something like transactions at the moment, I like the fact
that I can incorporate them later without switching
databases (and that if I ever decided to upgrade to the
realest database -- which appears to still be Oracle -- the
feature set won't be a lot different than what I'm used
to).
> So would anyone like to start an emacs vs vi war next? ;)
Sure, I'm always up for a good emacs/vi war.
I think it's funny that for years vi users went around
saying they didn't need any fancy emacs features like
auto-saves and automatically generated backup files, but now
that they've got them in vim, all of a sudden they're
wonderful to have.
Think about it: why wait for another vim upgrade when
you could have the emacs features today?
--
To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe"
as the Subject.
