Return-Path: X-Original-To: python-list@python.org Delivered-To: python-list@mail.python.org X-Spam-Status: OK 0.011 X-Spam-Evidence: '*H*': 0.98; '*S*': 0.00; "subject:' ": 0.07; 'think,': 0.07; 'latter': 0.09; 'postgresql.': 0.09; 'received:80.91': 0.09; 'received:80.91.229': 0.09; 'received:gmane.org': 0.09; 'received:list': 0.09; 'concurrency': 0.16; 'concurrent': 0.16; 'finney': 0.16; 'permissions,': 0.16; 'received:80.91.229.3': 0.16; 'received:plane.gmane.org': 0.16; 'sqlite': 0.16; 'subject:dates': 0.16; 'subject:sqlite3': 0.16; 'where?': 0.16; 'header:User-Agent:1': 0.23; 'mind.': 0.24; 'header:X-Complaints-To:1': 0.27; 'priorities': 0.31; 'writes:': 0.31; 'interface': 0.32; 'run': 0.32; 'knowledge': 0.35; 'subject: (': 0.35; 'something': 0.35; 'case,': 0.35; 'requirement': 0.35; 'easily': 0.37; 'ben': 0.38; 'needed': 0.38; 'to:addr:python- list': 0.38; 'little': 0.38; 'does': 0.39; "couldn't": 0.39; 'to:addr:python.org': 0.39; 'enough': 0.39; 'received:org': 0.40; 'major': 0.40; 'access,': 0.60; 'skip:n 10': 0.64; 'more': 0.64; 'relatively': 0.65; 'skip:\xe2 10': 0.65; 'believe': 0.68; 'hoping': 0.75; 'complex,': 0.84; 'received:125': 0.84; 'upset': 0.84 X-Injected-Via-Gmane: http://gmane.org/ To: python-list@python.org From: Ben Finney Subject: Re: 'Lite' Databases (Re: sqlite3 and dates) Date: Thu, 19 Feb 2015 15:09:56 +1100 References: <4154cc37-0bb0-4bf2-a52c-b728c737357c@googlegroups.com> <54E517B4.4000409@stoneleaf.us> <85lhjuahsm.fsf@benfinney.id.au> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Gmane-NNTP-Posting-Host: jigong.madmonks.org X-Public-Key-ID: 0xAC128405 X-Public-Key-Fingerprint: 517C F14B B2F3 98B0 CB35 4855 B8B2 4C06 AC12 8405 X-Public-Key-URL: http://www.benfinney.id.au/contact/bfinney-pubkey.asc X-Post-From: Ben Finney User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/24.4 (gnu/linux) Cancel-Lock: sha1:sQ/sdg+/D0RoKVnVuh9V33ehbnM= 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: 30 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1424318992 news.xs4all.nl 2939 [2001:888:2000:d::a6]:43670 X-Complaints-To: abuse@xs4all.nl Path: csiph.com!usenet.pasdenom.info!bete-des-vosges.org!feed.ac-versailles.fr!nerim.net!novso.com!newsfeed.xs4all.nl!newsfeed2a.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail Xref: csiph.com comp.lang.python:85852 memilanuk writes: > At this point... I don't think concurrency is going to be a major > requirement for what I have in mind. What's the difference betwen a “requirement” and a “major requirement”? If you want networked access, you need concurrent access and access permissions, etc. SQLite does not have concurrent access. Once you require concurrent access, you need something more complex, like PostgreSQL. > I have a hard time picturing that few people stressing a modern > computer system enough to where SQLite couldn't keep up (thinking > web-based interface using Flask or something similar). In the latter > case, one of the over-arching priorities is that it be easily > distributable, as in that people with relatively little knowledge of a > database be able to set it up and run it. Set it up where? Are you hoping that a network-accessible service can be set up without knowledge of the specific concurrent authenticated networked access is needed in each installation? -- \ “Broken promises don't upset me. I just think, why did they | `\ believe me?” —Jack Handey | _o__) | Ben Finney