# SQLite

## Content
# SQLite Driver

The SQLite driver stores metrics in a local SQLite database using JSON1.

## Setup

```elixir
{:ok, conn} = Exqlite.Sqlite3.open("trifle_stats.sqlite")

# Create tables
Trifle.Stats.Driver.Sqlite.setup!(conn)

# Build driver
driver = Trifle.Stats.Driver.Sqlite.new(conn)
```

## Options

- `table_name` (default: "trifle_stats")
- `ping_table_name` (default: "trifle_stats_ping")
- `joined_identifier` (`:full`, `:partial`, or `nil`)
- `system_tracking` (default: true)

## Example usage

```elixir
config = Trifle.Stats.Configuration.configure(driver)
Trifle.Stats.track("event::logs", DateTime.utc_now(), %{count: 1}, config)
```