SQLite Forum

ANN: Blacklite, an SQLite logging appender
Login
Hi all,

I've written a Java project that uses xerial-jdbc to send log entries to SQLite, called Blacklite.  It's intended for intensive diagnostic logging where you want to query information from the logs produced as part of error reporting and forensics.

Boring technical details:

* No indices, batched commits, WAL & mmap for maximizing write performance
* Bounded circular buffer, _rowid_ hacks used for reaping older rows from https://stackoverflow.com/a/34018187/5266
* Archiving has codec support, using SQL custom functions to compress in SQL
* Database rollover using attach statements 

Blog post:

https://tersesystems.com/blog/2020/11/26/queryable-logging-with-blacklite/

SQL statements here:

https://github.com/tersesystems/blacklite/blob/main/blacklite-core/src/main/resources/com/tersesystems/blacklite/resources.properties

Example application:

https://terse-logback-showcase.herokuapp.com/

Announcement is here:

https://twitter.com/will_sargent/status/1330708076693913600

Let me know what you think!

Will