Path: csiph.com!fu-berlin.de!uni-berlin.de!not-for-mail
From: Peter Otten <__peter__@web.de>
Newsgroups: comp.lang.python
Subject: Re: Tie dictionary to database table?
Date: Fri, 10 Jun 2016 14:25:22 +0200
Organization: None
Lines: 25
Message-ID: <mailman.134.1465561692.2306.python-list@python.org>
References: <drt5r8Ft1maU1@mid.individual.net> <CAO1D73Hb9_guWHxjer226APrFqTFM3eCWxmW4570Hpt5smvFmQ@mail.gmail.com> <CAGgTfkN6vSY-hSSqmRjxioOYJGDrO6HshNLHJGPtM_tOB8wdFw@mail.gmail.com> <mailman.126.1465512052.2306.python-list@python.org> <drv8l8Fb7nnU1@mid.individual.net> <njdqq7$cr5$1@dont-email.me> <drvkmoFdk2vU3@mid.individual.net> <njebji$ba1$1@ger.gmane.org>
Mime-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 7Bit
X-Trace: news.uni-berlin.de 2FTLkfm6dJIBzErx3LAaRQrvlAfMOYH01+hOTNIvI8Wg==
Return-Path: <python-python-list@m.gmane.org>
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; 'modified': 0.05; 'concurrent': 0.09; 'orm': 0.09; 'received:80.91': 0.09; 'received:80.91.229': 0.09; 'received:gmane.org': 0.09; 'received:list': 0.09; 'python': 0.10; 'dictionary,': 0.16; 'meanwhile': 0.16; 'perl.': 0.16; 'processes.': 0.16; 'received:80.91.229.3': 0.16; 'received:dip0.t-ipconnect.de': 0.16; 'received:io': 0.16; 'received:plane.gmane.org': 0.16; 'received:psf.io': 0.16; 'received:t-ipconnect.de': 0.16; 'recipe': 0.16; 'sqlite3': 0.16; 'wrote:': 0.16; "wouldn't": 0.16; '>>>': 0.20; 'code.': 0.23; 'bit': 0.23; 'header:User-Agent:1': 0.26; 'header:X-Complaints-To:1': 0.26; 'define': 0.27; 'module.': 0.27; 'values': 0.28; 'looks': 0.29; 'url:activestate': 0.29; 'task': 0.30; 'table': 0.32; 'class': 0.33; 'url:python': 0.33; 'michael': 0.33; 'url:code': 0.34; 'but': 0.36; 'url:org': 0.36; 'url:library': 0.36; 'to:addr:python-list': 0.36; 'subject:?': 0.36; 'subject:: ': 0.37; 'received:org': 0.37; 'christian': 0.38; 'does': 0.39; 'rather': 0.39; 'to:addr:python.org': 0.40; 'received:de': 0.40; 'url:3': 0.60; 'your': 0.60; 'skip:u 10': 0.61; 'between': 0.65; 'gollwitzer': 0.84; 'tie': 0.84; 'url:recipes': 0.84
X-Injected-Via-Gmane: http://gmane.org/
X-Gmane-NNTP-Posting-Host: p57bd95f3.dip0.t-ipconnect.de
User-Agent: KNode/4.13.3
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.22
Precedence: list
List-Id: General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe: <https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive: <http://mail.python.org/pipermail/python-list/>
List-Post: <mailto:python-list@python.org>
List-Help: <mailto:python-list-request@python.org?subject=help>
List-Subscribe: <https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
X-Mailman-Original-Message-ID: <njebji$ba1$1@ger.gmane.org>
X-Mailman-Original-References: <drt5r8Ft1maU1@mid.individual.net> <CAO1D73Hb9_guWHxjer226APrFqTFM3eCWxmW4570Hpt5smvFmQ@mail.gmail.com> <CAGgTfkN6vSY-hSSqmRjxioOYJGDrO6HshNLHJGPtM_tOB8wdFw@mail.gmail.com> <mailman.126.1465512052.2306.python-list@python.org> <drv8l8Fb7nnU1@mid.individual.net> <njdqq7$cr5$1@dont-email.me> <drvkmoFdk2vU3@mid.individual.net>
Xref: csiph.com comp.lang.python:109781

Peter Heitzer wrote:

> Christian Gollwitzer <auriocus@gmx.de> wrote:
>>Am 10.06.16 um 09:30 schrieb Peter Heitzer:
>>> Michael Selik <michael.selik@gmail.com> wrote:
>>>> An ORM might be overkill. If you just want a persistent dictionary,
>>>> just use the shelve module.
>>>> https://docs.python.org/3/library/shelve.html
>>> That looks like tie in Perl. Unfortunately I have to use mysql as
>>> database and I need concurrent read/write as the table may be modified
>>> by other processes.
>>> Meanwhile I have analized my demans a bit and modified the task so that
>>> I need not read values but rather make updates to the tables.
> 
>>It wouldn't be that difficult to roll your own thing which does that;
>>you just need to define __setitem__ and __getitem__ in your class which
>>translates between the SQL call and the Python code.
> That's a good idea.

There's an old recipe for sqlite3

http://code.activestate.com/recipes/576638-draft-for-an-sqlite3-based-dbm/

that you might adapt.