[Python-Dev] New bugtracker project

Gordon McMillan gmcm@hypernet.com
Thu, 23 May 2002 15:33:18 -0400


On 23 May 2002 at 7:35, Matthias Urlichs wrote:

> Looking through the roundup code, a SQL backend
> looks like a good idea. The code for finding
> elements needs to be rewritten (currently it's not
> database specific and just scans everything -- that
> doesn't scale), but other than that it should be
> relatively straightforward. 

The *straightforward* way of doing an SQL backend
would be to have (almost) everything in one table,
defined as (int key, binary stuff). That's utterly
useless for querying, since even the DB doesn't
know what it contains.

Contrast with Bugzilla's data model:
 http://www.bugzilla.org/docs/html/dbschema.html

[That's not to say the problem is unsolvable -
just not straightforward.]

-- Gordon
http://www.mcmillan-inc.com/