Path: csiph.com!usenet.pasdenom.info!aioe.org!news.stack.nl!newsfeed.xs4all.nl!newsfeed4a.news.xs4all.nl!xs4all!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.035 X-Spam-Evidence: '*H*': 0.93; '*S*': 0.00; 'amounts': 0.07; 'postgresql': 0.07; "subject:' ": 0.07; 'received:80.91': 0.09; 'received:80.91.229': 0.09; 'received:gmane.org': 0.09; 'received:list': 0.09; 'anyway': 0.14; 'concurrency': 0.16; 'concurrent': 0.16; 'finney': 0.16; 'fits': 0.16; 'rdbms': 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; 'do,': 0.16; 'header:User-Agent:1': 0.23; 'case.': 0.24; 'laws': 0.24; "haven't": 0.24; 'question': 0.24; 'distribute': 0.26; 'header:X-Complaints-To:1': 0.27; "doesn't": 0.30; "skip:' 10": 0.31; 'that.': 0.31; 'commonly': 0.31; 'writes:': 0.31; 'probably': 0.32; 'quite': 0.32; 'subject: (': 0.35; 'point.': 0.35; 'but': 0.35; 'there': 0.35; "i'll": 0.36; 'too': 0.37; 'two': 0.37; 'ben': 0.38; 'to:addr:python-list': 0.38; 'anything': 0.39; 'itself': 0.39; 'to:addr:python.org': 0.39; 'received:org': 0.40; 'serving': 0.60; 'most': 0.60; 'tell': 0.60; 'full': 0.61; 'new': 0.61; 'matter': 0.61; 'offering': 0.63; 'different': 0.65; 'between': 0.67; 'capable': 0.67; 'determine': 0.67; 'deeply': 0.69; 'sharing': 0.69; 'obvious': 0.74; 'music': 0.75; 'footprint': 0.84; 'lighter': 0.84; 'loses': 0.84; 'received:125': 0.84; '\xe2\x80\xa6': 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 11:03:53 +1100 References: <4154cc37-0bb0-4bf2-a52c-b728c737357c@googlegroups.com> <54E517B4.4000409@stoneleaf.us> 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:riicrYfNtPzXe41s0ImDTdQXt8w= 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: 31 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1424304273 news.xs4all.nl 2874 [2001:888:2000:d::a6]:45455 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:85835 memilanuk writes: > Okay... this might be a question with a blindingly obvious answer, but > I haven't seen any recommendations otherwise so I'll ask anyway ;) > > Is there anything *good* that sits in between the two extremes of > SQLite and PostgreSQL? What do you need a RDBMS to do, and what do you not need? The answers to those questions vary hugely between different people (and most people probably don't think too deeply about them). They will determine what “good” means for your case. > Is there nothing that amounts to a 'PostgreSQLite'? PostgreSQL itself fits that mould quite well; it is quite capable of serving a small footprint while still offering full concurrency. I don't know of a free-software concurrent RDBMS which can be considered lighter than that. (No, MySQL doesn't count; its concurrency is *unreliable* and it commonly loses data silently. Don't use MySQL.) But perhaps you don't need concurrency? Only you can tell us. -- \ “It's up to the masses to distribute [music] however they want | `\ … The laws don't matter at that point. People sharing music in | _o__) their bedrooms is the new radio.” —Neil Young, 2008-05-06 | Ben Finney