Thread

1. Re: Open Source Database article

   Christoph Dalitz <christoph.dalitz@hs-niederrhein.de> — 2002-09-17T08:22:51Z

   On Tue, 17 Sep 2002 03:53:50 -0400
   pgsql-general-owner@postgresql.org wrote:
   >
   > Here is a nice article comparing open-source and commercial databases:
   > 
   > 	http://newsforge.com/article.pl?sid=02/09/14/1253246&tid=11
   > 
   Although I am myself very fond of PosgreSQL, I am not sure whether
   the superficial advocacy in this article is really helpful.
   
   I would rather prefer honest comments both on the strengths and flaws
   of PostgreSQL. Eg. PostgreSQl is particularly weak on security aspects
   (every user has CreateTable rights, no schema support, no role privileges),
   which make it inadequate for some production environments.
   This is a point that I have never seen mentioned in any review article.
   Maybe I am the only one who bothers...
   
   Christoph Dalitz
   
   

2. Re: Open Source Database article

   Jeff Davis <list-pgsql-general@empires.org> — 2002-09-17T10:18:50Z

   On Tuesday 17 September 2002 01:22 am, Christoph Dalitz wrote:
   > On Tue, 17 Sep 2002 03:53:50 -0400
   >
   > pgsql-general-owner@postgresql.org wrote:
   > > Here is a nice article comparing open-source and commercial databases:
   > >
   > > 	http://newsforge.com/article.pl?sid=02/09/14/1253246&tid=11
   >
   > Although I am myself very fond of PosgreSQL, I am not sure whether
   > the superficial advocacy in this article is really helpful.
   >
   > I would rather prefer honest comments both on the strengths and flaws
   > of PostgreSQL. Eg. PostgreSQl is particularly weak on security aspects
   > (every user has CreateTable rights, no schema support, no role privileges),
   > which make it inadequate for some production environments.
   > This is a point that I have never seen mentioned in any review article.
   > Maybe I am the only one who bothers...
   >
   
   I agree. Postgres pretty much leaves all that up to the clients. I get the 
   impression that most environments don't involve a large number of database 
   users accessing one DB. Otherwise that would come up more often, I would 
   think.
   
   Schema support, BTW, is alive and well (from what I can tell) in 7.3b1.
   
   That, by the way, bings up an interesting point. What versions of software 
   should people use to compare? Postgres will have all the features of 7.3 in a 
   short while. So many of the features are working so well... should they be 
   denied the coverage in an article? Then again, it's also not fair to compare 
   the working features of one database with the almost-working features of 
   another. Of course that brings up the whole concept of who's declaring the 
   feature to be working (presumably the developers of the project), and their 
   motivations.
   
   Well, it's certainly not easy to be fair, I suppose. 
   
   Regards,
   	Jeff
   
   
   
   

3. Re: Open Source Database article

   Yury Bokhoncovich <byg@center-f1.ru> — 2002-09-23T05:38:54Z

   Hello!
   
   On Tue, 17 Sep 2002, Christoph Dalitz wrote:
   
   > I would rather prefer honest comments both on the strengths and flaws
   > of PostgreSQL. Eg. PostgreSQl is particularly weak on security aspects
   > (every user has CreateTable rights, no schema support, no role privileges),
   
   It's better not have that weird way how role privileges work on Sybase.;-)
   Agreed, that it's bad that me as DBA can't restrict userz from CREATE/DROP
   tables.:-(
   
   And btw pg_hba.conf can be done in MySQL db/user/host tables way.:)
   
   
   -- 
   WBR, Yury Bokhoncovich, Senior System Administrator, NOC of F1 Group.
   Phone: +7 (3832) 106228, ext.140, E-mail: byg@center-f1.ru.
   Unix is like a wigwam -- no Gates, no Windows, and an Apache inside.
   
   
   
   

4. Re: Open Source Database article

   Bruce Momjian <pgman@candle.pha.pa.us> — 2002-09-23T14:37:27Z

   Yury Bokhoncovich wrote:
   > Hello!
   > 
   > On Tue, 17 Sep 2002, Christoph Dalitz wrote:
   > 
   > > I would rather prefer honest comments both on the strengths and flaws
   > > of PostgreSQL. Eg. PostgreSQl is particularly weak on security aspects
   > > (every user has CreateTable rights, no schema support, no role privileges),
   > 
   > It's better not have that weird way how role privileges work on Sybase.;-)
   > Agreed, that it's bad that me as DBA can't restrict userz from CREATE/DROP
   > tables.:-(
   
   This will be available in 7.3.
   
   -- 
     Bruce Momjian                        |  http://candle.pha.pa.us
     pgman@candle.pha.pa.us               |  (610) 359-1001
     +  If your life is a hard drive,     |  13 Roberts Road
     +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073