Apalogretrieve 0.9.2

Apalogretrieve program retrieves data from an Apache logfile with a syntax, that is derived (a subset of) the SQL language.

The idea to make such an implementation came up at 17th of July 2007. I just started it then.

The basic idea of using an SQL-like dialect for logfile-analysis I had many years ago, but as there was no necessity, I didnt started a project like this.

The reason why I started to implement it now is, that the idea about SQL-querying of a logfile was now of interest to me, because I hated the way, how webalizer does it: you have graphical results very easy, but how to make detailed lookups to certain information? And: what about the delay until the (averaging) data can be seen in the graphs, and other problems, when changing a webalizer.conf-file?

So, this was the reason to start it.

As I not every day have the time to implement it, and only do it in a spare time window, it might need some time to make it ready, but reading Apaches common logfile-format as well as parsing simple SQL-like SELECT statements already works (19th of July 2007).

Usage Example:

SELECT host,date FROM "apache-commonlog.log" where size > 2000;
SELECT host,date,client,referrer FROM "apache-commonlog.log" where host = "foobar.host.net";