[CLUE-Tech] Clue: Database

[Dave Hahn]

PosgreSQL is also the 'standard' DB for distros like RedHat.  Although
MySQL can be found, PostgreSQL is making better inroads...

However, I use MySQL.  I've found it to be faster than PostgreSQL on the
databases I run.  (Typically simple and not large data sets - sub
100,000 records.)

Many of the 'missing' functions Jason mentions are present in the new
MySQL 4.0 which should be out of testing soon.  I do sorely miss
sub-selects in the current 3.x.x versions.

I don't know how PosgreSQL handles replication, but the master-slave
binlog relationship in MySQL works well for this and has become more
'automagical' in the 4.0 series.

I expect to hear Grant weighing in soon and reminding me that 'real men
use PostgreSQL'.   ;-)

-Dave


On Fri, 2002-02-01 at 19:32, jason at matchingmoms.com wrote:

    My preference is Postgresql.  It has important features that MySQL lacks,
    such as transactions, sub-selects, constraints, and triggers.  MySQL claims
    to be faster, and that may be true, but going faster on the high wire
    without a net (transactions) is useful only for specialized applications.
    And the lack of sub-selects will make MySQL considerably slower where logic
    can be imbedded in a select as opposed to program code.
    
    
    ----- Original Message -----
    From: "Richard Knechtel" <rknech at pcisys.net>
    To: <clue-tech at clue.denver.co.us>
    Sent: Saturday, February 02, 2002 1:40 AM
    Subject: [CLUE-Tech] Clue: Database
    
    
    > I am working on a Kylix application and am wondering what would be the
    best
    > general databse to use for the application.  I have used Oracle and DB2 at
    > work mainly. But normal Linux users don't have these installed.  Which is
    > probably the best general database to use ?  MySQl or Progress? or is
    there
    > another that might be better.
    >
    > Thanks,
    >
    > _______________________________________________
    > CLUE-Tech mailing list
    > CLUE-Tech at clue.denver.co.us
    > http://clue.denver.co.us/mailman/listinfo/clue-tech
    >
    
    _______________________________________________
    CLUE-Tech mailing list
    CLUE-Tech at clue.denver.co.us

http://clue.denver.co.us/mailman/listinfo/clue-tech

    
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://cluedenver.org/pipermail/clue-tech/attachments/20020201/81456f66/attachment.html