# tracing-subscribe-sqlite
A tracing Subscriber to send log to sqlite database (WIP).
## Usage
```toml
[dependencies]
tracing-subscriber-sqlite = "0.1"
```
```rust
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(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.
```toml
[dependencies]
tracing-subscriber-sqlite = { version = "0.1", features = ["tracing-log"]}
```
```rust
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(())
}
```