[Sqlgrey-users] sqlgrey easier data mining

[Max D. <Max...@lr...>]

Hi Lionel,

what do You think about the following issues to ease data mining:

-> field 'client_name' in connect
-> field 'first_seen' in from_awl, domain_awl
-> logging (now()-first_seen) within 'too early' - statements in the 
logfile (easier to grep)
-> putting all info concerning a single transaction into one single line
instead of two lines (makes it easier to grep)

BTW, could You rename connect.ip_addr into host_ip for consistency with 
from_awl and domain_awl? I understand, that, from a point of view of 
smart or c-class greylisting, these are different concepts. But from the 
sql schema point of view I find it rather uncomfortable to use different
names for this field.

LBNL, hope You enjoyed skiing and returned in good health when You read 
this (I start my first skiing holiday in my life tonight!)

Max