Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!feeds.phibee-telecom.net!newsfeed.xs4all.nl!newsfeed4a.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.000 X-Spam-Evidence: '*H*': 1.00; '*S*': 0.00; 'mysql,': 0.07; 'postgresql': 0.07; 'start-up': 0.07; 'if,': 0.09; 'latter': 0.09; 'received:80.91': 0.09; 'received:80.91.229': 0.09; 'received:gmane.org': 0.09; 'received:list': 0.09; 'subject:module': 0.09; 'gui': 0.12; "wouldn't": 0.14; 'windows': 0.15; '>unless': 0.16; 'concurrency': 0.16; 'database).': 0.16; 'db2,': 0.16; 'feasible': 0.16; 'message-id:@4ax.com': 0.16; 'received:80.91.229.3': 0.16; 'received:plane.gmane.org': 0.16; 'subject:access': 0.16; 'system-wide': 0.16; 'subject:python': 0.16; 'library': 0.18; 'looked': 0.18; 'app': 0.19; 'backend': 0.19; 'seems': 0.21; 'feb': 0.22; 'machine': 0.22; 'install': 0.23; 'closely': 0.24; 'integrate': 0.24; 'issue,': 0.24; 'url:home': 0.24; 'environment': 0.24; "i've": 0.25; 'task': 0.26; 'gets': 0.27; 'header:X-Complaints-To:1': 0.27; 'chris': 0.29; 'unix': 0.29; '(which': 0.31; 'once,': 0.31; 'option.': 0.31; 'probably': 0.32; 'compatible': 0.32; 'stuff': 0.32; 'option': 0.32; 'run': 0.32; 'running': 0.33; 'guess': 0.33; 'candidate': 0.34; 'subject:the': 0.34; 'advice': 0.35; 'something': 0.35; 'but': 0.35; 'there': 0.35; 'version': 0.36; 'really': 0.36; 'installing': 0.36; 'skip:> 10': 0.36; "didn't": 0.36; 'charset :us-ascii': 0.36; 'subject:?': 0.36; 'received:76': 0.38; 'server': 0.38; 'needed': 0.38; 'to:addr:python-list': 0.38; 'that,': 0.38; 'embedded': 0.39; 'visual': 0.39; 'to:addr:python.org': 0.39; 'received:org': 0.40; 'how': 0.40; 'simple': 0.61; "you've": 0.63; 'home': 0.69; 'desired?': 0.84; 'purchasers': 0.84; 'subject:SQL': 0.84; 'subject:recommended': 0.84; 'absolutely': 0.87 X-Injected-Via-Gmane: http://gmane.org/ To: python-list@python.org From: Dennis Lee Bieber Subject: Re: What is the recommended python module for SQL database access? Date: Sun, 09 Feb 2014 10:40:14 -0500 Organization: IISS Elusive Unicorn References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Gmane-NNTP-Posting-Host: adsl-76-249-26-199.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: 36 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1391960438 news.xs4all.nl 2949 [2001:888:2000:d::a6]:59368 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:65766 On Sun, 9 Feb 2014 22:00:58 +1100, Chris Angelico declaimed the following: >Broad recommendation: Single application, tiny workload, concurrency >not an issue, simplicity desired? Go SQLite. Big complex job, need >performance, lots of things reading and writing at once, want >networked access? Go PGSQL. And don't go MySQL if PG is an option. > >And definitely don't go for a non-free option (MS-SQL, DB2, etc) >unless you've looked into it really closely and you are absolutely >thoroughly *sure* that you need that system (which probably means you >need your app to integrate with someone else's, and that other app >demands one particular database). > Any opinion on Firebird? Just curiosity given how often the advice seems to be "start with SQLite, avoid MySQL, end with PostgreSQL" (and I might have ended with the latter if, at the time, there had been some native Windows compatible version -- installing a slew of stuff to create an emulated UNIX environment in which to build PostgreSQL was not something feasible for the underpowered machine of the age, nor for a home dabbler... MySQL had a simple install [even on Win9x where it needed a login-time start-up task as the Win9x didn't support it as a system-wide service], and GUI management/query programs; you can probably guess where I ended ). Over the years I've downloaded, but never really tried, Firebird. My current view is that, if Wholly Genes ever gets around to dropping Visual FoxPro for The Master Genealogist, Firebird might be a candidate as it has an embedded model -- purchasers of TMG wouldn't have to learn how to install a database backend to run as a server in addition to running TMG. (Though I see that MySQL now supports an embedded library versus only the client/server library) -- Wulfraed Dennis Lee Bieber AF6VN wlfraed@ix.netcom.com HTTP://wlfraed.home.netcom.com/