Vote tallying...

Lie Ryan lie.1296 at gmail.com
Sat Jan 19 12:58:17 CET 2013


On 19/01/13 00:43, Andrew Robinson wrote:
> On 01/18/2013 08:47 AM, Stefan Behnel wrote:
>> Andrew Robinson, 18.01.2013 00:59:
>>> I have a problem which may fit in a mysql database
>> Everything fits in a MySQL database - not a reason to use it, though.
>> Py2.5
>> and later ship with sqlite3 and if you go for an external database,
>> why use
>> MySQL if you can have PostgreSQL for the same price?
> MySQL is provided by the present server host.  It's pretty standard at
> web hosting sites.
> It works through "import MySQLdb" -- and it means an IP call for every
> action...

That is not quite true. With most client libraries, including MySQLdb, 
connection to localhost goes through a local unix socket (or named pipe 
in Windows) instead of the TCP stack.

> But
> it wants to lock the entire database against reads as well as writes
> when any access of the database happens.  Which is bad...

Which is the same restriction as when using XML/JSON. What it means by 
locking the entire database is that an sqlite database can only be 
read/written by a single program at any moment in time. For batch 
processing, locking the entire database is never going to be a problem; 
for CGI scripts (and their variants), it may be a performance bottleneck 
for extremely high volume websites.





More information about the Python-list mailing list