Projects / Apache SQL analyser

Apache SQL analyser

asql allows you to run SQL queries against log files formatted in the Apache common log file format. You may load multiple log files into a session, then run queries using a full SQL implementation, to find things such as the most common referers to your site, the greediest downloaders, and much more. Internally, each log file is parsed and imported into a temporary SQLite database, so performance is very good.

Operating Systems

Recent releases

  •  20 Feb 2010 15:27

    Release Notes: This release was made specifically to update the Debian package to the newer quilt format. No actual changes to the code or the project have been made.

    •  11 Jan 2009 22:08

      Release Notes: This release ensures that when importing Apache logs into the temporary SQL table that the HTTP status code is treated as an integer and not a string.

      •  30 Nov 2008 20:27

        Release Notes: This release updates the script such that it may be executed non-interactively from within cron jobs, without a controlling terminal.

        •  21 Oct 2008 21:04

          Release Notes: This release correctly handles dates when importing log files; previously, the month of December was not handled correctly.

          •  04 Jul 2008 13:29

            Release Notes: This release allows ad-hoc queries to be conducted directly from the commandline, without launching the interactive shell at all. This is achieved via a new commandline flag "--execute".


            Project Spotlight


            A Fluent OpenStack client API for Java.


            Project Spotlight

            TurnKey TWiki Appliance

            A TWiki appliance that is easy to use and lightweight.