[Tutor] Re: Tutor digest, Vol 1 #1417 - 19 msgs
Charlie Clark
charlie@begeistert.org
Mon, 11 Feb 2002 10:05:37 -0500
>Options:
>1. dictionary + pickle
>2. dictionary + shelve
>3. Gadfly
>4. Berkeley DB + Python bindings
>5. Postgres, MySQL + Python bindings
>
>The first couple of options relate reading in the file, creating a
>dictionary, and making it persistent. The Gadfly option looks good,
but I'm
>not sure whether or not it is still supported and works under later
versions
>of Python. The last couple of options are for 'true' database manager
>packages: perhaps overkill for this application.
>
Add
6) ZODB Standalone
just released and supported by Zope Corporation
7) mxODBC and any ODBC database
Speed=3F You will need to provide more information about how fast you
need: how many records in how short a time. Are you just going to be
reading from the database or will you be adding to it or changing it=3F
Do you need support for transactions=3F, etc.This is really a database
question and should be addressed at database gurus.
It shouldn't make much difference in Python which database you use as
the interfaces (the way you talk to the database) are very standard.
It's also worth looking at Marc-Andr=E9 Lemburgs mxODBC library which
gives you quick access to any database for which you also have an ODBC
driver.
Charlie.