The MySQL question.
Luciano Miguel Ferreira Rocha
strange at nsk.no-ip.org
Sat Sep 11 00:06:52 UTC 2004
On Sat, Sep 11, 2004 at 02:00:25AM +0200, Thomas Zehetbauer wrote:
> 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.
BSD
>
> 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.
>
>
> --
> fedora-test-list mailing list
> fedora-test-list at redhat.com
> To unsubscribe:
> http://www.redhat.com/mailman/listinfo/fedora-test-list
--
Consciousness: that annoying time between naps.
More information about the fedora-test-list
mailing list