On Sun, Aug 31, 2003 at 07:31:00PM -0400, Matt Zimmerman wrote: > On Sun, Aug 31, 2003 at 06:42:23PM -0400, Matt Zimmerman wrote: > > > Joy mentioned on IRC that you were working on this. Is there anything I can > > do to help? I've been wanting to add support for something like this to > > apt-listchanges for a long time now. > > Never mind, I have just noticed #102214 which has information about this. > > In one of the threads on the mailing lists about this, I posted my thoughts > about how it would work best, and a small hackish script I wrote some time > ago to import changelogs into a SQL database. This solves the problem of > having multiple branches of development, and allows for searching based on > simple criteria like maintainer, date, etc. If you are interested in this > approach, I would be glad to help.
In fact, I just spent a little time rewriting the import script to clean it up and testing it, and if someone could create a postgresql database for me on auric, I could have this up and running very quickly. The CGI needs some cleanup, but it's pretty trivial. The schema I'm using looks like this: CREATE TABLE entries (package VARCHAR(100) NOT NULL, version VARCHAR(100) NOT NULL, distribution VARCHAR(100), urgency VARCHAR(100), uploader VARCHAR(100), timestamp VARCHAR(100), content TEXT NOT NULL, PRIMARY KEY(package, version)); -- - mdz
