[Fedora-infrastructure-list] PackageDB

[Toshio Kuratomi]

I've updated the wiki page to my latest schema from the weekend:

http://www.fedoraproject.org/wiki/Infrastructure/PackageDatabase/Schema

And included information on how to check out revisions from a bzr
repository I've put up.  I made some changes that I perceive as
tradeoffs with Elliot's original design.  I think it's time to create
some of the frontend and see whether we run into those tradeoffs more
often than we think we should.

I did some more testing of the schema with TurboGears over the weekend
and I stumbled across a bug:
  https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=205894

Basically, Foreign Key constraints are broken in the current TurboGears
stack (sqlobject is the package that maps python objects to SQL tables).
With mysql and sqlite, this doesn't matter as foreign keys aren't doing
constraint checking at all (another sqlobject bug) but postgreSQL has
working constraint checking and needs the dependency ordering patch from
the bug report applied.

-Toshio
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
URL: <http://listman.redhat.com/archives/fedora-infrastructure-list/attachments/20060911/8e5b3ab9/attachment.sig>