mike watkins dot ca : Python Database Interfaces

Python Database Interfaces

Python object databases need some love too

Flávio Coelho recently performed an examination of various Python database API and ORM interfaces to MySQL, Postgres, and SQLite, and included a benchmark for cPickle.

Here's an addition to Flávio's Fastest Python Database Interface article and script to include Durus: performance.py.

I also pointed out on Flávio's blog that his cPickle benchmark needed to include pickling 100,000 "Person" classes, in addition to 100,000 simple tuples - this to show the overhead of class instantiation and serialization / deserialization which all of the ORM's and object databases share in some form or another. An example of both can be found in performance.py.