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
