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

someone newsboost at gmail.com
Sat Apr 13 20:10:54 EDT 2013


On 04/14/2013 12:34 AM, Chris Angelico wrote:
> 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.

Ok, thank you very much... Sounds like PostgreSQL is the best option for 
me to go on to from here, after I've played a bit my sqlite...




More information about the Python-list mailing list