Poster of Linux kernelThe best gift for a Linux geek
ASQL

ASQL

Section: Perl Programmers Reference Guide (8) Updated: 2010-10-04
Local index Up
 

NAME

asql - Provide an SQL interface to Apache logfiles.  

SYNOPSIS

  asql [options]

  General Options:

   --help       Show brief help intstructions.
   --manual     Show more complete help.
   --version    Show the version of the software.

  Scripting Options:

   --load       Load the named file, or glob.
   --execute    Execute a single query then exit.

  Options:

   --file       Rather than running as a shell read commands from a named file.
   --quiet      Don't show the banner at startup.

 

DESCRIPTION

  asql provides a simple console interface to allow a user to
 query the contents of an Apache logfile via an SQL interface.

  The shell features include:

Persistent alias definitions.
Command line completion
Command history
Simple scriptability
 

INTRODUCTION

  The asql shell will create a temporary SQLite database based upon
 any number of Apache logfiles.  This temporary database may then
 be interactively queried using common SQL syntax.

  To get started you should load your logfiles into the database:

   load /var/log/apache2/acces*

  (The tool will automatically decompress files which have been
 compressed with gzip or bzip2.)

  Once you've loaded at least one file you may run queries, for
 example:

  SELECT source,SUM(size) AS Number FROM logs GROUP BY source ORDER BY Number DESC, ip

  This example shows all the clients connecting to your webserver
 and the size of files/requests that they have downloaded in total.

  As you can see we've selected two columns "source" and "SUM(size)".
 To see which other columns are available you may execute the "show"
 command.

  Because parsing the Apache logfile(s) specified might be quite
 slow there is the option of dumping the temporary SQLite database
 to a known filename with the 'save' command.  The analog to the
 save command is the 'restore' command, which will read in an
 existing SQLite database and allow future queries to be executed
 against it.

 

FILES

 When the shell starts up it will read and intepret the initialisation
 file of ~/.asqlrc if it exists.  Any commands present in that file
 will be executed prior to the launch of the interactive session.

 All aliases will be read and written to the file ~/.asql.aliases.

 All interactive history will be written to the file ~/.asql.

 

AUTHOR

 Steve
 --
 http://www.steve.org.uk/

 

LICENSE

Copyright (c) 2007,2008,2009,2010 by Steve Kemp. All rights reserved.

This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. The LICENSE file contains the full text of the license.  

AUTHOR

 Steve
 --
 http://www.steve.org.uk/

 

LICENSE

Copyright (c) 2007-2020 by Steve Kemp. All rights reserved.

This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. The LICENSE file contains the full text of the license.


 

Index

NAME
SYNOPSIS
DESCRIPTION
INTRODUCTION
FILES
AUTHOR
LICENSE
AUTHOR
LICENSE

This document was created by man2html, using the manual pages.
Time: 22:01:17 GMT, April 16, 2011