Re: best small database?

David Isaac wrote:
I have no experience with database applications.
This database will likely hold only a few hundred items,
including both textfiles and binary files.

I would like a pure Python solution to the extent reasonable.

Suggestions?

You haven't provided enough requirements for us
to make any intelligent suggestions. Perhaps you
might learn something from reading through my old
EuroPython presentation.

http://www.thinkware.se/cgi-bin/thinki.cgi/DatabaseProgrammingWithPython

Relational databases with SQL syntax provides a convenient
way to store data with an appropriate structure. You can
always force a tool into handling things it wasn't designed
for, but SQL database work best when you have strict, well
defined structures, such as in accounting systems, booking
systems etc. It gives you a declarative query language,
transaction handling, typically multi user support and
varying degrees of scalability and high availability
features.

For you, it's probably overkill, and if you have files
to start with, keeping them in the file system is the
natural thing to do. That means that you can use a lot
of standard tools to access, manipulate, backup and search
through them. Perhaps you rather need a search engine for
the file system?

Do you intend to store information concerning how these
files relate to each other? Perhaps it's better in that
case to just keep that relationship information in some
small database system, and to keep the actual files in
the file system.

Perhaps it's enough to keep an XML file with the structure,
and to use something like ElementTree to manipulate that
XML structure.

You gain a lot of power, robustness and flexibility by
using some kind of plain text format. Simple files play
well with configuration management systems, backup systems,
editors, standard search tools, etc. If you use XML, it's
also easier to transform your structural information to
some presentable layout through standard techniques such
as XSL.

.

Relevant Pages

  • Re: Databases, Typed Datasets, and Flat Files oh my!
    ... file, get the right characters, and then manually add the rows to the ... This standard consists of a fixed ... dataset gets shoved into database (or vicea ... All of the stuff I see for typed datasets is "XML! ...
    (microsoft.public.dotnet.languages.vb)
  • Re: GEDOM as a database format
    ... Tony Proctor wrote: ... isn't complicated Peter, but that doesn't make it impossible, and it doesn't ... It also includes the operating system crashing for no apparent reason and also the disk on which your database resides going up the swanee. ... The standard I want to see is something not constrained by application program, operating system, or hardware and even at a pinch be implementatble as a paper-based manual system. ...
    (soc.genealogy.computing)
  • Re: Some free utilities for Java, with Hebrew support.
    ... a third-party MySQL client library that I know of. ... market at large. ... The JDBC and ODBC models are such that the database vendor ... provides exactly that adapter to fill in a standard API. ...
    (comp.lang.java.programmer)
  • Re: Application Speed Problem - VERY weird
    ... MDE front ends not MDB ... If the DB is reading in a lot of records, ... The data is linked with the standard Access "link ... add that we have only ever used the database on Access 2K. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: META: how-to ruin a perfectly good FGS
    ... search engine is friendlier to special characters. ... It is again impossible to search for the "standard". ... I have no interest in submitting my database to such destinations. ...
    (soc.genealogy.methods)