Best database to use with Python

[Johannes Stezenbach]

D'Arcy J.M. Cain <darcy at vex.net> wrote:
>‘5ÛHH575-UAZWKVVP-7H2H48V3 <thomas at cintra.no> wrote:
>> What database-system is easiest, fastest etc. to use with Python? I`ve
>> looked at MySQL, but it seems a little overkill just to get a little
>> more functionality than Berkley DB-functionality. What about Postgres?
>> mSQL? 
>
>> Postgres comes with my Linux distro and seem smaller than MySQL. How
>
>Actually I think you will find PostgreSQL larger than MySQL.
>
>> does it compare to MySQL when it comes to administration and speed,
>> scalability etc. ?
>
>I don't use MySQL as I find that PostgreSQL has more features and works
>fast enough for my needs.  Like most RDBMSs in its class the expensive
>part is updates and inserts but the retrievals are quite snappy.  The
>one time I tried to administer a MySQL system I was a little horrified.
>PostgreSQL was easier to understand.  That could just be me, of course.

The one fundamential difference between MySQL and PostgreSQL (apart
from the license) is that PostgreSQL has a focus on preserving
data integrity and dealing with concurrency issues (using transactions,
triggers, etc.) while MySQL omits these features in favor of raw speed.
The MySQL folks claim to be 10 times faster for UPDATEs.

Johannes