general purpose database cleanup tools (design patterns or Python)?

Lee Harr missive at
Sat Feb 17 05:03:55 CET 2001

On Wed, 14 Feb 2001 17:25:43 -0600 (CST), Skip Montanaro <skip at> wrote:

I can't really tell what you are wanting to do, but I get the sense that
what you are looking for is a relational database which allows you to 
maintain relational integrity.

Take a look at postgres( )

>A side effect of people using the Mojam and Musi-Cal web sites is that a
>fairly complex MySQL database gets built.  There are several tables in the
>database (venues, concerts, cities, etc) that can accumulate errors fairly
>rapidly because the system allows anyone with concerts to publicize to add
>them to our database.  Because of the size of the tables and their
>interdependencies, manually correcting all but the most straightforward
>errors is impossible.
>I'm looking for pointers to design patterns or tools (preferably in Python)
>that might be applicable to the task.  I think such tools would separate the
>description of the database's structure from the rules about deleting and
>merging rows, which would, in turn, be separate from the engine that
>actually manipulates the database.
>We have a tool now that works reasonably well but is very difficult to
>maintain and enhance because none of the three functions are separate.
>Before I launch into a complete redesign, I thought I'd see what already
>exists.  This can't be a problem unique to our environment.
>Skip Montanaro (skip at
>Support Mojam & Musi-Cal:

More information about the Python-list mailing list