Bug#102214: changelogs on packages.debian.org
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
Reply to: