Databases: Which one's right for me?
stevewilliams at wwc.com
Sat Jan 10 04:10:12 CET 2004
> Hi all,
> Basically I need a db that will travel with my executable script and
> faithfully store and edit the data needed in that script. People using
> this script will need to be stand alone users. Having a client/server
> arrangement is not possible over a network.
> Also, installing some type of db engine outside of Python is also not
> Or, if there exists
> another solution other than the two I mentioned, please throw that out
> there because it's almost impossible to completely examine every
> possibility out there. All suggestions are helpful.
> Thanks ahead of time,
Firebird 1.5 has a nice stand-alone database capability I use for demos.
You don't have to install anything on the target machine, but it's not
something that can be packed up in a python exe, as far as I know. You
have to have the Firebird database, its dll, config file and message
file in the same directory as your Python program, but that's all.
Firebird, as a database, is worth a look. I'd spend an hour evaluating
it before using ACCESS and DAO.
You might run into deployment problems with ACCESS 2, 3, 4, 5, 7,
2000/DAO on Windows 95, Windows 98, Windows NT, Windows XP, service
packs 1-5, plus corruption/compaction headaches. But that's just my
experience. "You have moved the mouse, please insert the ACCESS
If you just want some data persistency, use pickle.
More information about the Python-list