3 ms·
> very few places AFAIK actually process their HTTP server logs into a form that can be queried by SQL. There are at least two tools that support directly quer
by tstack 6y ago
> very few places AFAIK actually process their HTTP server logs into a form that can be queried by SQL.
There are at least two tools that support directly querying log files with SQL:
* logparser -- https://en.wikipedia.org/wiki/Logparser https://en.wikipedia.org/wiki/Logparser
* lnav -- https://lnav.org https://lnav.org
lnav uses SQLite and provides quite a few extensions, so quite a lot is possible. The logs are exposed via virtual tables, so there is no separate import step.
- deleted 6y ago[deleted]