On Tue, 10 Aug 2010 20:57:31 +0200 Alban Hertroys <dal...@solfertje.student.utwente.nl> wrote:
> On 10 Aug 2010, at 18:56, Stevan Bajić wrote: > > >> So i was thinking about a solution without having quarantines in the > >> database. It would be easy. > >> Everytime something has to be done the webui could write into a todo > > table > >> and a cronjob on the system looks there every 30 sec or so and do the > >> requests. > >> > > Uha. This Mainframe (aka 1960) technology. Doing batch processing. > > > This reminded me of an idea I once had that's entirely going the opposite > way: Moving the classification engine entirely into the database. It seems a > really cool idea, but I just never seem to get around to it. > If done well you could not only classify mails as spam/ham by sending them > through a function in your database, but you could also pass on forum posts > or all kinds of other data and have them classified as spam or ham - or maybe > even other classification choices, although it seems to me that would > increase the complexity factor by a factor N (with N being the number of > options). > > A library and a few function wrappers in, for example, Postgres sounds > entirely possible, does it not? The dspam daemon could then simply talk to > the classification engine in the database and operate based on the query > result. > Should be possible but only if the database allows you to code functions that are done in another language than SQL. However... extending a database to do all kind of things that an Anti-Spam solution is doing, is going to be a hell of a task. RBL, RHBL, DNSWL, tokenizing, etc... all this in a database? A lot of work and I don't think you will gain any huge benefit. The other thing is that not every RDBMS is capable to deliver that extended functionallity. How for example would you build that solution into SQLite? Or how would you implement that into MySQL? For PostgreSQL things are much easier because PostgreSQL supports scripting languages and compiled languages that other DBMS are lacking. > Alban Hertroys > > -- > Screwing up is an excellent way to attach something to the ceiling. > > > !DSPAM:1155,4c61a126967631698419972! > > > > ------------------------------------------------------------------------------ > This SF.net email is sponsored by > > Make an app they can't live without > Enter the BlackBerry Developer Challenge > http://p.sf.net/sfu/RIM-dev2dev > _______________________________________________ > Dspam-devel mailing list > Dspam-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspam-devel ------------------------------------------------------------------------------ This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev _______________________________________________ Dspam-devel mailing list Dspam-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-devel
