|
|
SELECT 0.1 (Default branch)
02-26-2008
SELECT allows you to execute SQL queries on text files. It works by loading the text file into an in-memory SQLite database and then executing the query on that. It supports some popular log file formats like access_log and generically every kind of log file.|
|
ASQL(8) Perl Programmers Reference Guide ASQL(8) 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. perl v5.10.1 2010-10-04 ASQL(8)