database in python ?
Ola Natvig
ola.natvig at infosense.no
Mon Apr 11 07:13:09 EDT 2005
Pierre-Frédéric Caillaud wrote:
>
>> MySQL is an excellent option is very well documented. It is also a
>> defacto standard for OpenSource databases.
>
>
> MySQL sucks for anything but very very basic stuff as it supports
> no transactions, foreign keys, procedures, triggers, concurrency, etc.
> Postgresql is a lot better, free, and the psycopg adapter for
> Postgres is *very very* fast (a lot faster than the MySQL one) and it
> has a dictfetchall() method which is worth its weight in donuts !
MySQL has support for transactions and foreign keys in it's InnoDB
engine. In 5.0 it supports views procedures. Some people seems to hate
MySQL :-) but a whole lot of other people like it a lot.
The thing is, if you don't spesificaly state that you want triggers,
concurrency and procedures I guess that your needs are quite basic.
However you won't be be disappointed with either MySQL or postgree in
your trunk :)
ola
--
--------------------------------------
Ola Natvig <ola.natvig at infosense.no>
infoSense AS / development
More information about the Python-list
mailing list