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