[pygresql] Please suggest

[Bo Vandenberg]

> (database) to choose. AFAIK PostgreSQL is not really an Object Database,
> though it may have some features that go in this direction.

I'm just looking at Postgres now and, on paper certainly, it has a lot to
recommend it. ACID Compliance and rollbacks seem really important to me for
almost anything.

You can inherit table structures.

The new 7.2 version promises up to 1gb records and 17tb databases and a
whole heap of improvements.

I'm just reading _PostgreSQL Developers Handbook_ from SAMS by Ewald
Geschwinde and Hans-Jurgen Schonig which seems to be very python friendly. I
recomend it.


I would recommend an SQL structure if you want your data to be portable.
Although I'm sure you could massage any coherant data structure into any
other with some work.

>
> I basically see two options
> 1) a relational database, like PostgreSQL
> 2) an object database, like ZODB (for Python, part of Zope). There are
> also several open-source object databases for Java

I agree

> But to say which one is more appropriate, we'd have to know more of the
> requirements.

Chiefly I'd wonder how many concurrant users you would have, what your
backup requirements are, and what sort of data you would be using.
Remember that the datastore should be a flexible backend that your users
might never see directly.

I'd love to hear from anyone using postgres and python.