Version 1.23 of LogMiner, my Apache/IIS log analysis package, is now available. This release mainly fixes some build problem on modern distributions. Also it finally includes the cleanup function I was talking about some days ago…
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, …
How much would it cost to rewrite it?
I’ve just added LogMiner to Ohloh, a site that offers an interesting feature: it can analyse a project source code and estimate how much it would cost to hire a development team to recreate the project from scratch. I think that it’s a simple way to estimate the effort you put over the time in …
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 ) …
Mac OS X version statistics through CFNetwork analysis
Recently I needed to gather some statistics about the distribution of the different Mac OS X versions installed by users of a certain application. Since the application has an update-check feature, I thought I’d use the web server logs to infer the data I was interested in. The only thing I could use was the …