Berkeley DB vs Sqlite3
gour at mail.inet.hr
Sat Oct 18 09:34:25 EDT 2008
>>>>> "Matthias" == Matthias Andree <matthias.andree at gmx.de> writes:
Matthias> which one has given you problems?
None (so far).
Matthias> Not all of the bf_* utilities are required for sqlite3
Matthias> databases though, most of them came into existence to help
Matthias> users handle Berkeley DB idiosyncrasies.
Matthias> If there are contrib/* scripts that don't work with sqlite3,
Matthias> then please tell us which one you wanted to use and how it
Matthias> failed (error messages perhaps) so we can ask the contributor
Matthias> if he wants to update/fix them.
I was looking at e.g. man for bf_compact which says it is meant for
Berkeley, but it probably does not apply for sqlite3.
Matthias> I do /not/ recommended the Berkeley DB version over an
Matthias> established sqlite3. In your situation, I'd suggest to stick
Matthias> with sqlite3.
Thank you for the hint.
Matthias> The speed difference but SQLite3 does not, IMO, matter on
Matthias> personal computers (Berkeley DB has been faster when I
Matthias> compared them long ago, but sqlite3 has been optimized since).
Right and I'm fetching mail via cron (getmail).
Matthias> sqlite3 is easier to handle (there are less points on the
Matthias> checklists to care) - read through README.db and see for
OK. Will do.
>> Is it possible to switch from Sqlite to DB?
Matthias> Yes, it is. The procedure is:
Matthias> - stop your mail system - dump all your *.db files to text
Matthias> files with bogoutil -d. - install the berkeleydb-based
Matthias> bogofilter - load the text files back into *.db files - test -
Matthias> if everything works, start your mail system and remove the old
Matthias> *.db files - backup the dumped text files instead.
Thank you for giving it although I may not need it ;)
Gour | Zagreb, Croatia | GPG key: C6E7162D
More information about the Bogofilter