Tag: logminer

Who’s linking to your site?

If you’re using LogMiner to analyse your Apache/IIS logs, here’s an easy recipe to be notified of sites that send visitors your way. First, let’s define a Pg/PLSQL function to extract the new referrers: 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748CREATE TYPE new_referrer AS (     site_id         int8,     site_name       text,   …

Read more

LogMiner: purging old accesses

I’ve just committed a function to easily purge old data from LogMiner’s database, useful to prevent it from growing too much. It’ll appear in the next version, but since its release might still be far from now, here’s the code for those who need it: 123456789101112131415161718192021222324252627282930313233343536373839CREATE OR REPLACE FUNCTION cleanup( _site int8, _upToDate DATE ) …

Read more