tracing-subscribe-sqlite

A tracing Subscriber to send log to sqlite database (WIP).

Usage

[dependencies]
tracing-subscriber-sqlite = "0.1"

use rusqlite::Connection;
use tracing_subscriber_sqlite::prepare_database;

fn main() -> Result<(), Box<dyn std::error::Error>> {
    let conn = Connection::open("log.db")?;

    tracing::subscriber::set_global_default(
        tracing_subscriber_sqlite::SubscriberBuilder::new() // builder pattern
            .with_black_list(["h2::client", "h2::codec"]) // filter logs from `h2::client` and `h2::codec`
            .with_white_list(["h2"]) // only enable logs from `h2`
            .build_prepared(Arc::new(Mutex::new(conn)))?, // prepare database and build the subscriber
    )?;

    tracing::info!(x = 1, "test"); // structured data is stored as JSON

    tracing::debug!("debug");

    Ok(())
}

log Compatibility

Use tracing-log to send log's records to tracing ecosystem.

[dependencies]
tracing-subscriber-sqlite = { version = "0.1", features = ["tracing-log"]}

use rusqlite::Connection;
use tracing_subscriber_sqlite::prepare_database;

fn main() -> Result<(), Box<dyn std::error::Error>> {
    let conn = Connection::open("log.db")?;

    prepare_database(&conn)?;

    tracing_log::LogTracer::init().unwrap(); // handle `log`'s records
    tracing::subscriber::set_global_default(tracing_subscriber_sqlite::Subscriber::new(conn))?;

    log::warn!("log warning");

    Ok(())
}