Path: csiph.com!usenet.pasdenom.info!aioe.org!news.stack.nl!newsfeed.xs4all.nl!newsfeed2a.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.000 X-Spam-Evidence: '*H*': 1.00; '*S*': 0.00; 'sufficient': 0.05; 'deny': 0.07; 'error:': 0.07; 'postgresql': 0.07; 'socket': 0.07; "subject:' ": 0.07; 'anticipate': 0.09; 'parameter': 0.09; 'received:80.91': 0.09; 'received:80.91.229': 0.09; 'received:gmane.org': 0.09; 'received:list': 0.09; 'developer': 0.10; '>in': 0.16; '>the': 0.16; '>to': 0.16; 'exists"': 0.16; 'message-id:@4ax.com': 0.16; 'received:80.91.229.3': 0.16; 'received:plane.gmane.org': 0.16; 'skip:> 20': 0.16; 'somewhere.': 0.16; 'sqlite': 0.16; 'subject:dates': 0.16; 'subject:sqlite3': 0.16; 'apps': 0.16; 'app': 0.19; 'backend': 0.19; 'thu,': 0.19; 'feb': 0.22; 'machine': 0.22; 'rules': 0.22; 'install': 0.23; 'installation': 0.23; 'url:home': 0.24; 'looks': 0.24; 'developers': 0.25; 'task': 0.26; 'header:X-Complaints-To:1': 0.27; "doesn't": 0.30; 'probably': 0.32; 'run': 0.32; 'running': 0.33; 'updated': 0.34; '"the': 0.34; 'subject: (': 0.35; 'common': 0.35; 'something': 0.35; 'there': 0.35; 'version': 0.36; 'charset :us-ascii': 0.36; 'half': 0.37; 'server': 0.38; 'problems': 0.38; 'handle': 0.38; 'to:addr:python-list': 0.38; 'files': 0.38; 'anything': 0.39; 'does': 0.39; 'embedded': 0.39; 'to:addr:python.org': 0.39; 'either': 0.39; 'received:org': 0.40; 'users': 0.40; 'how': 0.40; 'more': 0.64; 'yourself': 0.78; '2015': 0.84; 'dealt': 0.91; 'dozen': 0.91; 'received:108': 0.93 X-Injected-Via-Gmane: http://gmane.org/ To: python-list@python.org From: Dennis Lee Bieber Subject: Re: 'Lite' Databases (Re: sqlite3 and dates) Date: Fri, 20 Feb 2015 09:16:16 -0500 Organization: IISS Elusive Unicorn References: <54e546b5$0$11119$c3e8da3@news.astraweb.com> <54e58ba8$0$11121$c3e8da3@news.astraweb.com> <4d7a8fd2-144a-4400-b012-1967f6deeded@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Gmane-NNTP-Posting-Host: adsl-108-79-216-110.dsl.klmzmi.sbcglobal.net X-Newsreader: Forte Agent 6.00/32.1186 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: 37 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1424441772 news.xs4all.nl 2829 [2001:888:2000:d::a6]:47208 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:85971 On Thu, 19 Feb 2015 20:20:42 -0800 (PST), rurpy@yahoo.com.dmarc.invalid declaimed the following: > >Do they all install and run their own independent server? Each >with its own set of more than a half dozen processes running all >the time? Each that has to be started up at system boot? Each >with their own directory of Postgresql software and backend data >directory? Where do these files all go and how do app developers >agree on some standard to avoid chaos? How does each app find a >network port or socket that doesn't conflict with the others or >with things the machine owner may run? For a Sqlite app you are >installing files for which the rules are all pretty well established. > >And if the Postresql apps share a server who arbitrates when >app X decides it needs to set some parameter that breaks app Y? >Or change anything else on the server; things shared in common >by all the apps like users or (as you yourself mentioned) log >file settings? > >The complexities you deny exist do exist and have to be dealt >with somewhere. Either you, the developer have to handle them >in the installation and anticipate problems like "Install error: >/var/lib/pgsql/data: already exists" or "data directory contain >wrong version of Postresql" or you shove the task off onto your >users in which case they will have to have sufficient expertise >to deal with them. > The middle-ground is probably something like the embedded version of Firebird (pity there has been no updated book -- "The Firebird Book" came out in 2004, v1.5 while 2.5 is current [Whoops, looks like there /is/ an update, print-on-demand in three overpriced volumes]) -- Wulfraed Dennis Lee Bieber AF6VN wlfraed@ix.netcom.com HTTP://wlfraed.home.netcom.com/