Relational Databases and Python

[Steve Holden]

<ssthapa at harper.uchicago.edu> wrote in message
news:slrn96950d.2hn.ssthapa at ntcs-ip45.uchicago.edu...
> glinds - Greg Lindstrom <glinds at acxiom.com> wrote:
> >* What relational database to use?  I am constructing a routine to
> >track incident reports for the volunteer fire department I run with.  I
also
> >want to track personnel information, training records, equipment, etc.
It
> >will be a small to medium database (the databases I work with
professionally
> >run in the terabytes, but we spend millions on software).  I am looking
at
> >MySQL.  Whatever base I use must be free.
>
>     I suggest using postgresql instead.  I think mysql has limitations
such
> as not allowing subselects, foreign keys, and similar things that might
bite
> you latter on. Also I think that until recently mysql didn't have all the
ACID
> properties (it recently added transactions so it may have it now).
>
MySQL does appear very limited.

My reading of the PostgreSQL web site leads me to believe you'll be
"limited" to UNIX platforms, I can't remember far enough back in the thread
to determine whether this matters or not.

regards
 Steve