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.
>> 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
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.
> 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