Path: csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!newsreader4.netcologne.de!news.netcologne.de!newsfeed.freenet.ag!news2.euro.net!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail Return-Path: X-Original-To: python-list@python.org Delivered-To: python-list@mail.python.org X-Spam-Status: OK 0.002 X-Spam-Evidence: '*H*': 1.00; '*S*': 0.00; 'socket': 0.05; 'read- only': 0.07; 'stack.': 0.07; 'newest': 0.09; 'received:80.91': 0.09; 'received:80.91.229': 0.09; 'received:gmane.org': 0.09; 'received:list': 0.09; 'restriction': 0.09; 'sqlite': 0.09; 'sat,': 0.15; 'conclusion:': 0.16; 'did,': 0.16; 'happily': 0.16; 'localhost': 0.16; 'pipes': 0.16; 'received:80.91.229.3': 0.16; 'received:plane.gmane.org': 0.16; 'sqlite3': 0.16; 'tcp': 0.16; 'jan': 0.18; '(or': 0.18; 'windows': 0.19; 'pipe': 0.22; 'installation': 0.23; '(which': 0.26; 'header:X-Complaints-To:1': 0.28; 'run': 0.28; 'complete,': 0.29; 'locking': 0.29; 'seeks': 0.29; 'connection': 0.30; 'could': 0.32; 'goes': 0.33; 'ryan': 0.33; 'true.': 0.33; 'url:home': 0.33; 'to:addr:python-list': 0.33; 'likely': 0.33; 'operations': 0.33; 'version': 0.34; 'open': 0.35; 'received:org': 0.36; 'client': 0.36; 'charset:us-ascii': 0.36; 'does': 0.37; 'moment': 0.37; 'quite': 0.37; 'subject:: ': 0.38; 'instead': 0.39; 'to:addr:python.org': 0.39; 'header:Received:5': 0.40; 'most': 0.61; 'first': 0.61; 'close': 0.63; 'subject:...': 0.63; 'readers': 0.65; '2013': 0.84; 'actually,': 0.84; 'readers.': 0.84; 'windows)': 0.84; 'dennis': 0.91 X-Injected-Via-Gmane: http://gmane.org/ To: python-list@python.org From: Dennis Lee Bieber Subject: Re: Vote tallying... Date: Sat, 19 Jan 2013 16:22:57 -0500 Organization: > Bestiaria Support Staff < References: <50F8906D.9040203@r3dsolutions.com> <50F9518E.3040509@r3dsolutions.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Gmane-NNTP-Posting-Host: adsl-76-253-98-163.dsl.klmzmi.sbcglobal.net X-Newsreader: Forte Agent 3.3/32.846 X-No-Archive: YES X-BeenThere: python-list@python.org X-Mailman-Version: 2.1.15 Precedence: list List-Id: General discussion list for the Python programming language List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Newsgroups: comp.lang.python Message-ID: Lines: 28 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1358630580 news.xs4all.nl 6990 [2001:888:2000:d::a6]:34615 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:37098 On Sat, 19 Jan 2013 22:58:17 +1100, Lie Ryan 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/