You've already seen the messages on where PostGres docs are. My
choices have been:
1. If it's transactional - use PostgresSQL (MySQL doesn't do)
2. Speed is important, not transactions - use MySQL
3. "Need" commercial choice - Oracle or DB2
Note that both Oracle and DB2 have lots of "enterprise" features, such
as remote syncing, etc.
I probably use Postgres more than MySQL, simply because I started with
it. Gnome-db front end is making it much more friendly (Gnome-db
works with any DB, I just use it with Postgres). Also, Postgres was
designed to be object-oriented (it started as a UC OODB project), so
it has nifty "inheritance" of data types, etc. It's close to SQL92
conformant, and even conforms to many SQL99 features (which add object
oriented stuff to SQL).
Now that MySQL is GPL'd, expect to see a lot of features added. I've
heard rumors that there's a addition to make it transactional, but I
haven't found it yet.
Another option, if you're building a directory service, go with
OpenLDAP (www.openldap.org) - it's open source, and designed to meet
the LDAP standards for directories
jeff
On Sun, 24 Sep 2000, Tom Rauschenbach wrote:
> Date: Sun, 24 Sep 2000 19:42:36 -0400
> From: Tom Rauschenbach <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: database choice
>
>
>
>
> For a variety of reasons I want a relational database for Linux. As far as I
> know my choices are
> MySQL (which has huge and confusing doc)
> Oracle 8i (which has a huge and confusing download)
> DB2 (which has an advertized download that I can't find)
> Postgress (which appears to have no doc whatsoever).
>
> What are you folks using, if anything ? What's good what's bad ?
> My needs are so modest that I might just do what I need in C and be done with
> it, but I'd like to have a real database engine just because.
>
> Besides, this seems like a nice discussion topic for this group.
>
>
>
------------------------------------------------------------------------
Jeffry Smith Technical Sales Consultant Mission Critical Linux
[EMAIL PROTECTED] phone:603.930.9739 fax:978.446.9470
------------------------------------------------------------------------
Thought for today: bit decay n.
See bit rot. People with a physics
background tend to prefer this variant for the analogy with
particle decay. See also computron, quantum bogodynamic
**********************************************************
To unsubscribe from this list, send mail to
[EMAIL PROTECTED] with the following text in the
*body* (*not* the subject line) of the letter:
unsubscribe gnhlug
**********************************************************
