1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
|
alias
-----
Define a persistent alias, or list those aliases currently defined.
If no arguments are given all current aliases, as loaded from the
alias file are displayed.
Aliases persist by default and may be created by running something
like this:
alias agents SELECT distinct(agent) FROM logs
Once this has been entered the new command 'agents' will run the given
query.
To remove the alias run:
alias agents
alter
-----
Run an ALTER query against the database.
create
------
Run a CREATE query against the database.
delete
------
Run a DELETE query against the database.
drop
----
Run a DROP query against the database.
exit
----
Exit the shell.
help
----
If a command is given then show help about that command.
If no command is specified give an overview of all available commands.
insert
------
Run an INSERT query against the database.
load
----
Load an Apache logfile into the currently open table.
You may either specify a single file, or a glob pattern.
Files with a .gz, or .bz2 suffix will be automtically decompressed and loaded.
To save time parsing the logfile(s) specified you may save the database once
it has been populated via 'save' and 'restore'.
quit
----
Exit this shell.
restore
-------
Load a SQLite database which was previously saved via 'save'.
This immediately makes any previously saved records available, without the need to reload the logile(s).
save
----
Save the temporary SQLite database which was create at startup time.
This means you won't need to wait for the relatively slow logfile parsing
at startup. Use the 'restore' command to reload this database in the future.
select
------
Run a SELECT query against the database.
Example queries
SELECT distinct(source) FROM logs
SELECT referer,COUNT(referer) AS number from logs GROUP BY referer ORDER BY number DESC,referer
etc.
show
----
Show the structure of the database.
update
------
Run an UPDATE query against the database.
|
