Re: Berkeley DB vs Sqlite3
Gour <[email protected]>
| Newsgroups | gmane.mail.bogofilter.general |
|---|---|
| Message-ID | <[email protected]> |
>>>>> "Matthias" == Matthias Andree <[email protected]> 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 ---------------------------------------------------------------- _______________________________________________ Bogofilter mailing list [email protected] http://www.bogofilter.org/mailman/listinfo/bogofilter