News for hackers. Stuff that matters.
Re:Simple Anomaly Detection Using Plain SQL by tstack on Monday January 11, 2021 @06:31PM (#25739687)
> 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

* lnav -- 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.

There are no comments on this comment yet.