Le 2025-05-29 02:43, Colin Watson a écrit :
While it might be possible to carry on doing without, the data
fundamentally has many relational properties and an RDBMS would make
life a lot easier. I wish I'd known what I know now about PostgreSQL
when I was in my period of working on debbugs very actively; I would
100% have switched to it.
That's valuable input, thank you.
Right now we have an implementation that is dated but mostly works so I
think that there is no need to rush a move. Working on it for a while
and experimenting with the real data in there will certainly help with
figuring out what could be done about the storage.
That data is somewhat transactional, moderately relational, also with
relations like bugs that are merged with bugs, block bugs, affect
packages which are dependencies of packages, are found in versions which
have versions as successors ... and SQL is not that great at recursivity
or working with graphs. Or handling large binary objects. Or doing
finely tunable full-text indexing and search. That's an implementation
detail anyway (well, maybe not right now, but that's how it should be
ideally).
Cheers,
--
Julien Plissonneau Duquène
