Querylog is a console-based software tool that enables users to execute SQL queries on a log file. It is a simple yet powerful tool for parsing and analyzing log files.
The Querylog project is a powerful console tool specifically designed for performing SQL queries on a log file. With support for matching lines from one or more text files, as well as standard input, this tool uses regular expressions that facilitate an in-memory database on which SQL queries can be executed.
With the ability to specify queries like SELECT's, INSERT's, CREATE VIEW's, and more in the configuration file, it is very easy to manipulate the data as needed. In addition, any queries that generate output are currently printed to stdout in plain text.
This tool is written in C++ and uses the boost program options and regex library, as well as the sqlite libraries for the in-memory database. Originally created to extract accounting information from cups page log files, the tool's generic nature means it can be used in many other situations too.
Building the project requires the boost headers and libraries for program_options and regex, as well as the sqlite3 headers and libraries. If you have all the necessary dependencies, building the project is as simple as running '> bjam'. You can also use g++ to compile and link the single source file.
To run the tool, you must specify options on the command line or in a config file. For more information, run 'querylog --help'. Lastly, it is important to note that the tool works even if the input file is not specified, in which case data will be read from stdin until the end of the file.
With the ability to specify queries like SELECT's, INSERT's, CREATE VIEW's, and more in the configuration file, it is very easy to manipulate the data as needed. In addition, any queries that generate output are currently printed to stdout in plain text.
This tool is written in C++ and uses the boost program options and regex library, as well as the sqlite libraries for the in-memory database. Originally created to extract accounting information from cups page log files, the tool's generic nature means it can be used in many other situations too.
Building the project requires the boost headers and libraries for program_options and regex, as well as the sqlite3 headers and libraries. If you have all the necessary dependencies, building the project is as simple as running '> bjam'. You can also use g++ to compile and link the single source file.
To run the tool, you must specify options on the command line or in a config file. For more information, run 'querylog --help'. Lastly, it is important to note that the tool works even if the input file is not specified, in which case data will be read from stdin until the end of the file.
What's New
Version 0.1: N/A