[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.