Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #37098

Re: Vote tallying...

Show key headers only | View raw

On Sat, 19 Jan 2013 22:58:17 +1100, Lie Ryan <lie.1296@gmail.com>
declaimed the following in gmane.comp.python.general:

> 
> 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.
>
	Named pipe is only available is MySQL was configured to use one.
Named pipes are only available on the NT-derived Windows OS (which is
likely all still running) -- MySQL could be run on W9x without named
pipes, and even on WinXP my installation does not activate named pipes.
 
> 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 

	Actually, SQLite3 will happily permit multiple readers (or did, the
newest version may have a new locking scheme). However, the first
connection that seeks to write will block as long as open readers are
active, yet will also block /new/ readers. When the open readers close,
the write can complete, and then new readers can enter. Conclusion:
ensure that even read-only operations have a "commit" operation to close
them
-- 
	Wulfraed                 Dennis Lee Bieber         AF6VN
        wlfraed@ix.netcom.com    HTTP://wlfraed.home.netcom.com/

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

Re: Vote tallying... Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2013-01-19 16:22 -0500

csiph-web