Handling SPAM

Well it’s not a new debate, thats for sure, and I have very strong views on this topic (especially blacklists and ISP’s restricting trade), as well as an approach to a new Protocol termed ‘Authenicated Mail’ or ‘amail’. I’ll need to put my notes on my blog one day.

The purpose for note, is the ongoing increasing spam and inappropiateness of mail that is coming to a general web accessible email address for a client.
I’ve proposed they move to a Challenge Response System for at least general listed email addresses on web sites. This will at least cut down the amount received at the mailbox, however it doesn’t eliminate the mail, the traffic, time, money and space used in mail.

What other approaches can you try. Well, not having a mailto link on your site is a good start. The use of an image to display an email address and not text is also a sound entry approach. I’d also recommend that for general web inquiries, you rotate your names, for example: website@domain.com , inquiries@domain.com , contactus@domain.com etc. As the address is only used on the website, changing the email, and turning the old name into an invalid mailbox will help.

I’ve also found another novel approach, this is the second time I’ve seen this. The website asks you to please add predefined characters into the subject line. Here’s and example.

http://r0.unctad.org/ecommerce/ecommerce_en/contact_en.htm

Tagged with: General

Producing IQR and Outlier statistics with SQL

The interquartile range (IQR) measures the spread of the middle 50% of a distribution — the distance between the first quartile (Q1) and the third quartile (Q3). Combined with Tukey’s 1.

Producing Mode statistics with SQL

The mode is the value or values that appear most frequently in a dataset. Unlike the mean or median, it applies naturally to categorical and ordinal data — star ratings, product codes, survey responses — and reveals what is most common, not what is average.

Extending MySQL Capabilies with UDFs, Plugins and Components - Part 2

MySQL offers three different approaches to extending the SQL capabilities with the default product you download and install. These are: User Defined Function (UDF) MySQL Manual MySQL Plugin MySQL Manual MySQL Component MySQL Manual In my prior post I provided a new uuidv function that accepted a numeric argument to return a string of the version of UUID specified.