> -----Original Message----- > From: Sven Riedel [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 18, 2006 12:49 AM > To: [email protected] > Subject: Rules from Database > > Hi, > I'm currently working on a (among other frontends) SA > frontend for work, which stores a lot of the configuration > information in a database, including the rule set. > > My current approach is going to be to generate a rules.cf > file from the rules table, and load that into SA. I might > work on a patch for SA to read the ruleset directly from the > database table instead (I think this would complement the > Bayes/AWL in an SQL database nicely). >
When you say 'read the ruleset directly', I hope you mean loading rules from SQL on spamd startup (which would require a patch), because loading 800 ish rules from SQL via ConfSQL.pm per msg would incur quite a lot of unneeded overhead when the rules do not change often enough to warrant it (bayes and awl do). I think you would be better off developing your SQL schema and then cron'ing a perl script to read the DB and write a rules.cf (hourly/daily whatever), and then HUP the spamd when you do. That way your schema that you need for your web frontend doesn't have to marry to SA necessarily, since you have an intermediary script making it work the way SA wants. Just my $0.02, since I've done a lot of what you are talking about here. Dallas
