SpamAssassin uses local databases for each user by default in the ~/.spamassassin directory. There are three types of databases: user preferences, the auto-whitelist, and the Bayesian database. SpamAssassin can use an SQL database to store any or all of these details.
When using SpamAssassin in a distributed environment where SpamAssassin may be run from one of many machines, using a single SQL database is an ideal solution. Using a centralized database also assists in centralized backup of the preferences, and gives the administrators the opportunity to modify many accounts easily.
SpamAssassin uses the modularity of Perl that allows the usage of different databases to be used without any changes to the application. SpamAssassin has been tested with MySQL, PostgreSQL, and SQLite. Due to the nature of the Perl database interface, most relational databases that are supported by Perl will work with SpamAssassin. The database driver modules are available on CPAN and have names beginning...
