The MySQL question.

[Thomas Zehetbauer]

On Fre, 2004-09-10 at 17:50 -0400, Lamar Owen wrote:
> > - MySQL has a fine grained access control
> 
> How fine do you need?  Checked out what you can do with pg_hba.conf lately? 
> What sort of fine-grained control do you need?  You might be surprized at 
> what you can do now.

No, but I doubt that you can restrict a user to read-only access of
single column.

> > - PostgrSQL fail to use the index for a simple 'SELECT MAX(column)'
> 
> Really?  Got any EXPLAIN output to prove that?

Fortunately I have no access to PostgreSQL any more but I have seen an
EXPLAIN output proving this; Besides it is on the PostgreSQL developers
todo list for a long time: http://developer.postgresql.org/todo.php

> > - PostgreSQL needs a complete dump restore for at least every minor
> >   version upgrade
> 
> Wrong.  PostgreSQL needs a dump restore for a major version upgrade.  Major is 
> like 7.2 to 7.3.  PostgreSQL's versioning is more like the Linux kernel than 
> other packages in versioning.  Even then, the Slony replication engine allows 
> you to replicate to a newer version and keep both up and running 
> concurrently.

Please correct me if I am wrong but I consider 7 to be the current major
and 4 to be the current minor version. But even when stepping from 7.4.x
to 7.4.2 the PostgreSQL developers recommend a dump/restore cycle.

> And PostgreSQL is not owned by or sponsored by any one company; nor is it an 
> issue to embed PostgreSQL in a commercial product.

AFAIK PostgreSQL is licensed as GPL with no exceptions, so it is a
problem for commercial applications.

Tom

-- 
  T h o m a s   Z e h e t b a u e r   ( TZ251 )
  PGP encrypted mail preferred - KeyID 96FFCB89
      finger thomasz at hostmaster.org for key

There's too much blood in my caffeine system.


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 481 bytes
Desc: This is a digitally signed message part
URL: <http://listman.redhat.com/archives/fedora-test-list/attachments/20040911/94c7c963/attachment.sig>