b4fun/ku

Toolkit for collecting and exploring logs using pipelined query lanaguage and sqlite.

Toolkit for collecting and exploring logs using pipelined query language.

Ku (/ko͞o/) collects logs from program output and persists in a sqlite database. It provides a web browser interface for exploring the logs using PRQL.

Why PRQL? PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement. Different than typical SQL syntax, PRQL forms a logical pipeline of transformations, and supports abstractions such as variables and functions, which provides better reading / writing experience. Learn more about on prql-lang.org.

Why sqlite? Sqlite is a lightweight, self-contained RDBMS with rich features set. It can be used in local and in the cloud. Ku uses sqlite as data backend to archive data persistency and portability.

Why Ku? It's a common challenge that querying logs form cloud-native applications in both local and production. One straightforward way is to use tools like grep to perform quick searching - however, in most of the cases we need more powerful querying languages to explore the data. Ku aims to fulfill this scenario by brining PRQL and sqlite together.

Project Status Ku is in a very early stage of development (bugs inside ™). Any contribution is welcome. Please feel free to open an issue or pull request.

Next: Getting Started | LICENSE