Path: csiph.com!usenet.pasdenom.info!gegeweb.org!de-l.enfer-du-nord.net!feeder2.enfer-du-nord.net!feeds.phibee-telecom.net!newsfeed.xs4all.nl!newsfeed2.news.xs4all.nl!xs4all!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.012 X-Spam-Evidence: '*H*': 0.98; '*S*': 0.00; 'forgive': 0.05; 'subject: + ': 0.07; 'global,': 0.09; 'received:80.91': 0.09; 'received:80.91.229': 0.09; 'received:gmane.org': 0.09; 'received:list': 0.09; 'subject:into': 0.09; 'ah,': 0.16; 'received:80.91.229.3': 0.16; 'received:plane.gmane.org': 0.16; 'subject:which': 0.16; 'subject:python': 0.16; 'attach': 0.16; 'files.': 0.16; 'subject: ?': 0.16; 'file,': 0.19; '(the': 0.22; 'select': 0.22; 'url:home': 0.24; 'connected': 0.24; 'file.': 0.24; 'tables': 0.26; 'second': 0.26; 'header:X-Complaints-To:1': 0.27; 'chris': 0.29; 'file': 0.32; 'skip:d 20': 0.34; 'could': 0.34; 'problem.': 0.35; 'but': 0.35; 'charset:us-ascii': 0.36; "i'll": 0.36; 'work?': 0.38; 'to:addr:python-list': 0.38; 'files': 0.38; 'to:addr:python.org': 0.39; 'enough': 0.39; 'received:org': 0.40; 'first': 0.61; "you'll": 0.62; 'information': 0.63; 'name': 0.63; 'more': 0.64; 'between': 0.67; 'of:': 0.68; 'qualified': 0.72; 'evening': 0.84; 'edition': 0.86; 'received:108': 0.93; '2013': 0.98 X-Injected-Via-Gmane: http://gmane.org/ To: python-list@python.org From: Dennis Lee Bieber Subject: Re: python-noob - which container is appropriate for later exporting into mySql + matplotlib ? Date: Sat, 13 Apr 2013 19:42:26 -0400 Organization: > Bestiaria Support Staff < References: <5168b87f$0$29977$c3e8da3$5496439d@news.astraweb.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Gmane-NNTP-Posting-Host: adsl-108-73-118-117.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: 35 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1365896553 news.xs4all.nl 2686 [2001:888:2000:d::a6]:53550 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:43555 On Sun, 14 Apr 2013 08:44:28 +1000, Chris Angelico declaimed the following in gmane.comp.python.general: > > Ah, that'd be a problem. What if each row is in its own file, though? > Would that work? That is, instead of: > > UPDATE durability_test_table SET counter=counter+1 WHERE id=:random_value > > you use: > > UPDATE durability_test_:random_value SET counter=counter+1 > SQLite3 requires one to "attach" other files. ATTACH "file.spec" AS internalname If tables in the files share names, you have to use a qualified name to access them: select * from internalname.table {the original connected database file can be qualified as "main"} I'll admit I don't know enough about SQLite3 to know if the locks are global, or per attached file. The information may be in the book (the first edition is actually larger than the second edition! and may have more of the gritty internals described) -- but you'll forgive me if I don't spend the evening reading to find out. If per file, you could have an update on each file with no locking conflict between them. -- Wulfraed Dennis Lee Bieber AF6VN wlfraed@ix.netcom.com HTTP://wlfraed.home.netcom.com/