python-noob - which container is appropriate for later exporting into mySql + matplotlib ?

Chris Angelico rosuav at gmail.com
Sat Apr 13 18:34:51 EDT 2013


On Sun, Apr 14, 2013 at 5:34 AM, someone <newsboost at gmail.com> wrote:
> I think maybe I'll experiment a bit with both mySql (small/medium sized
> databases) and for critical/important stuff I should go with PostgreSQL

PostgreSQL isn't majorly slower than MySQL, and it's a lot more
trustworthy in terms of database constraints and so on. MySQL is
designed as a place for a single application to store its data, and it
assumes that the application is king; PostgreSQL is designed as a
database against which application(s) may execute queries, therefore
it assumes that the database administrator is king.

With heavy read/write workloads, I'd put my money on PostgreSQL every
time; MySQL has a much greater problem with wide locks (eg
table-level) and consequent loss of concurrency.

ChrisA



More information about the Python-list mailing list