New version, database incompatible -retrain again!

[Matthias Andree]

Am 09.02.25 um 18:15 schrieb Adrian via bogofilter:
> I now realise that perhaps the only incompatibility is that the old
> wordlist was a Sqlite3 database and the new one a Berkeley DB one.
>
> And that bogofilter can be built in versions for either DB.  Ubuntu has
> packages for each.
>
> I guess the simplest solution is to install the sqlite flavour on a
> different machine and run the dump there.

That should work, at least assuming same endianness and word widths (32 
vs. 64 bits). There is some support in bogofilter to look at endianness 
properly, but that's been a while.

We've made the unfortunate decision or omission at the time that the 
sqlite3 database also uses the ".db" suffix as the Berkeley DB stuff does.
Berkeley DB itself should have been able to upgrade if the database was 
closed properly such that it would not need recovery, or were an intact 
non-transactional database.

OTOH since Oracle bought them, my interest in Berkeley DB has pretty 
much vanished. Patches disappearing from the website, licensing changes 
with DB 6, and more that annoys me,
so I think we should switch the default and mark it deprecated, and 
maybe keep them readable so distros can build Berkeley DB based bogoutil 
versions additionally and ship them so that users can migrate away.

-- 
Matthias Andree