Re: Renovating debbugs (was Re: Interesting learnings about Guix contributor dynamics that apply to Debian?)
On Tue, 27 May 2025, Colin Watson wrote:n
> In my view, an absolute prerequisite for all of this is moving from the
> current flat-file structure to a proper database; the current data
> structures just don't perform well enough to be usable as the foundation for
> a modern web UI. Don has some branches on
> https://salsa.debian.org/debbugs-team/debbugs that make a start at switching
> to PostgreSQL, and he can probably fill you in on more details.
Absolutely.
My personal goal is to replace the entire codebase with
python+sqlalchemy+postgresql+fastapi, while keeping the flat file
system only for archiving the bug log (the .log files) for at least a
significant period of time, but that bug log would be write only.
The code for this is about 25% there, but I've been working on it for
years now in my very limited Debian development time, so I don't have
a realistic timeline for completion.
--
Don Armstrong https://www.donarmstrong.com
There is no mechanical problem so difficult that it cannot be solved
by brute strength and ignorance.
-- William's Law
Reply to: