Berkeley DB vs Sqlite3

[Gour]

>>>>> "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.

I see.

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
Matthias> yourself.

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 ;)


Sincerely,
Gour

-- 

Gour  | Zagreb, Croatia  | GPG key: C6E7162D
----------------------------------------------------------------