Queryable Logging with Blacklite

Queryable Logging with Blacklite

Will Sargent describes how he built Blacklite, a Java library for diagnostic logging that writes log events (as zstd compressed JSON objects) to a SQLite database and maintains 5,000 entries in a "live" database while entries beyond that range are cycled out to an archive.db file, which is cycled to archive.timestamp.db when it reaches 500,000 items.

Lots of interesting notes here on using SQLite for high performance logging.

"SQLite databases are also better log files in …

beyond database diagnostic events java json library logging objects sqlite