SQLite Forum

ANN: Blacklite, an SQLite logging appender

ANN: Blacklite, an SQLite logging appender

(1.1) By Will Sargent (wsargent) on 2020-11-29 17:59:24 edited from 1.0 [source]

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:


SQL statements here:


Example application:


Announcement is here:


Let me know what you think!