"Apalogretrieve software retrieves Apache logfile data using a SQL-like syntax." (13 words)
Apalogretrieve is a software program that enables users to retrieve data from an Apache logfile with a syntax that is a subset of the SQL language. The idea to create this program came about on July 17th, 2007, and the developer started working on it then. The basic concept of using an SQL-like dialect for logfile analysis has been around for many years. However, as there was no urgency to implement such a solution, the developer didn't undertake the project until now.
The reason why the developer decided to implement the program at this time is that the idea of SQL-querying of a logfile became of interest due to the limitations of webalizer. While webalizer provides graphical results easily, it lacks the ability to make detailed lookups to certain information. Additionally, there are issues with the delay until the averaged data can be seen in the graphs, and the difficulties of changing a webalizer.conf-file. These deficiencies were the impetus for the developer to begin work on this software program.
As the developer doesn't have the luxury of working on the program every day, it may take some time to finalize it. As of July 19th, 2007, Apalogretrieve is capable of reading Apache's common logfile-format as well as parsing simple SQL-like SELECT statements.
Using Apalogretrieve is simple. Users can run queries such as "SELECT host,date FROM 'apache-commonlog.log' where size > 2000;" and "SELECT host,date,client,referrer FROM 'apache-commonlog.log' where host = 'foobar.host.net';". These queries enable users to retrieve data from the Apache logfile based on certain criteria.
The newer version of Apalogretrieve comes with the following features:
- Reading from gzipped logfiles transparently is possible now.
- Output can be redirected to a file.
- The output format was changed to aligned ASCII (with blanks between the entries), HTML (table), or LATEX (tabular).
- An error was corrected in the documentation and logscanner and language-parser: the Combined Logfile Format is now parsed completely, even with the seldom used fields "logname" and "userid".
In conclusion, Apalogretrieve is a useful software program for anyone looking to retrieve data from an Apache logfile based on SQL-like queries. With its recent update, it provides even more features for users to enjoy.
The reason why the developer decided to implement the program at this time is that the idea of SQL-querying of a logfile became of interest due to the limitations of webalizer. While webalizer provides graphical results easily, it lacks the ability to make detailed lookups to certain information. Additionally, there are issues with the delay until the averaged data can be seen in the graphs, and the difficulties of changing a webalizer.conf-file. These deficiencies were the impetus for the developer to begin work on this software program.
As the developer doesn't have the luxury of working on the program every day, it may take some time to finalize it. As of July 19th, 2007, Apalogretrieve is capable of reading Apache's common logfile-format as well as parsing simple SQL-like SELECT statements.
Using Apalogretrieve is simple. Users can run queries such as "SELECT host,date FROM 'apache-commonlog.log' where size > 2000;" and "SELECT host,date,client,referrer FROM 'apache-commonlog.log' where host = 'foobar.host.net';". These queries enable users to retrieve data from the Apache logfile based on certain criteria.
The newer version of Apalogretrieve comes with the following features:
- Reading from gzipped logfiles transparently is possible now.
- Output can be redirected to a file.
- The output format was changed to aligned ASCII (with blanks between the entries), HTML (table), or LATEX (tabular).
- An error was corrected in the documentation and logscanner and language-parser: the Combined Logfile Format is now parsed completely, even with the seldom used fields "logname" and "userid".
In conclusion, Apalogretrieve is a useful software program for anyone looking to retrieve data from an Apache logfile based on SQL-like queries. With its recent update, it provides even more features for users to enjoy.
What's New
Version 0.9.6: N/A