Path: csiph.com!usenet.pasdenom.info!gegeweb.org!de-l.enfer-du-nord.net!feeder1.enfer-du-nord.net!newsfeed.eweka.nl!eweka.nl!feeder3.eweka.nl!newsfeed.xs4all.nl!newsfeed5.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.001 X-Spam-Evidence: '*H*': 1.00; '*S*': 0.00; 'debug': 0.05; '(so': 0.07; 'python': 0.09; 'logic': 0.09; 'received:80.91': 0.09; 'received:80.91.229': 0.09; 'received:gmane.org': 0.09; 'received:list': 0.09; 'sep': 0.09; 'sqlite': 0.09; 'interfaces': 0.15; 'sat,': 0.15; 'in-memory': 0.16; 'low-level': 0.16; 'python;': 0.16; 'reason.': 0.16; 'received:80.91.229.3': 0.16; 'received:plane.gmane.org': 0.16; 'rivet': 0.16; 'sqlite3': 0.16; 'subject:simple': 0.16; 'versions': 0.20; 'raw': 0.27; 'developing': 0.28; 'header:X-Complaints-To:1': 0.28; 'attempting': 0.29; 'equivalent.': 0.29; 'relational': 0.29; 'served': 0.29; 'objects': 0.29; 'ease': 0.30; 'normally': 0.30; 'compatible': 0.30; 'code': 0.31; 'getting': 0.33; 'loading': 0.33; 'subject:data': 0.33; 'url:home': 0.33; 'to:addr:python- list': 0.33; 'data,': 0.35; 'filter': 0.35; 'there': 0.35; 'received:org': 0.36; 'charset:us-ascii': 0.36; 'level': 0.37; 'uses': 0.37; 'rather': 0.37; 'data': 0.37; 'subject:: ': 0.38; 'mark': 0.38; 'to:addr:python.org': 0.39; 'application': 0.40; 'header:Received:5': 0.40; 'think': 0.40; 'between': 0.63; 'become': 0.65; 'saving': 0.72; 'guaranteed': 0.76; 'dennis': 0.91; 'graphical': 0.91 X-Injected-Via-Gmane: http://gmane.org/ To: python-list@python.org From: Dennis Lee Bieber Subject: Re: simple client data base Date: Sat, 08 Sep 2012 17:42:52 -0400 Organization: > Bestiaria Support Staff < References: <5l6n489vo896k565a4m5bjgl714qgickqg@4ax.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Gmane-NNTP-Posting-Host: adsl-76-249-29-63.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: 26 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1347140580 news.xs4all.nl 6906 [2001:888:2000:d::a6]:50305 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:28747 On Sat, 08 Sep 2012 15:22:24 -0400, Mark R Rivet declaimed the following in gmane.comp.python.general: > Yes, that's the reason. I need to learn something. Without getting > into the complexities of relational database's for now. Given the ease of use of SQLite3, I think you'd be better served by using an RDBM rather then try to manage persistence of Python in-memory objects (pickle is not guaranteed to be compatible between versions of Python; and for all these schemes you become responsible for loading and saving a block of data using Python level instructions. RDBM interfaces normally take care of translating the low-level entities between Python and database format; you don't have to develop search and filter logic to manage subsets of the data, etc.). There is even a plugin for Mozilla -- SQLite Manager -- since Mozilla uses SQLite3 internally, which can give you rudimentary graphical access to raw databases (so you can debug the data in the database while developing the application code to "properly" access the data). Dabo is attempting to be a Python "Visual FoxPro" equivalent. -- Wulfraed Dennis Lee Bieber AF6VN wlfraed@ix.netcom.com HTTP://wlfraed.home.netcom.com/