Terry Hancock wrote: [...]
That's interesting. Most sources I've read seemed to suggest that postgresql is slower than MySQL, at least for modest size tables. There must, I suppose, be some turnover point on the size of the database? Or are you arguing that postgresql is now faster than MySQL in the general case? Can you suggest sources for investigating that formally?
It's just possible that I should reconsider Postgresql compatibility. I would assume that using the Python DB API would make portability between the two easier in any case, wouldn't it?
Cheers, Terry
-- Terry Hancock ( hancock at anansispaceworks.com ) Anansi Spaceworks http://www.anansispaceworks.com
I don't know about the whole picture, but I know form evidence on this group that there are PostgreSQL driver modules (the name "psycopg" comes to mind, but this may be false memory) that appear to take diabolical liberties with DBAPI-2.0, whereas my experience with MySQLdb has been that I can interchange the driver with mxODBC (for example) as a drop-in replacement (modulo the differing paramstyles :-().
regards Steve -- Steve Holden +1 703 861 4237 +1 800 494 3119 Holden Web LLC http://www.holdenweb.com/ Python Web Programming http://pydish.holdenweb.com/
-- http://mail.python.org/mailman/listinfo/python-list