Skip to content

trifle-io/trifle_stats

Repository files navigation

Trifle.Stats

Hex Version Elixir CI

Time-series metrics for Elixir. Track anything (signups, revenue, job durations) using the database you already have. No InfluxDB. No TimescaleDB. Just one call and your existing PostgreSQL, MongoDB, Redis, MySQL, or SQLite.

Part of the Trifle ecosystem. Also available in Ruby and Go.

Why Trifle.Stats?

  • No new infrastructure. Uses your existing database. No dedicated time-series DB to deploy, maintain, or pay for.
  • One call, many dimensions. Track nested breakdowns (revenue by country by channel) in a single track call. Automatic rollup across dynamic time granularities (1m, 6h, 1d, etc.).
  • Library-first. Start with the package. Add Trifle App dashboards, Trifle CLI terminal access, or AI agent integration via MCP when you need them.

Quick Start

1. Install

def deps do
  [
    {:trifle_stats, "~> 1.0"}
  ]
end

2. Configure

# config/config.exs
config :trifle_stats,
  driver: Trifle.Stats.Driver.Postgres,
  granularities: [:hour, :day, :week, :month]

3. Track

Trifle.Stats.track("orders", DateTime.utc_now(), %{
  count: 1,
  revenue: 4990,
  revenue_by_country: %{us: 4990},
  revenue_by_channel: %{organic: 4990}
})

4. Query

Trifle.Stats.values("orders", ~U[2026-02-10 00:00:00Z], DateTime.utc_now(), :day)
#=> %{
#     at: [~U[2026-02-10 00:00:00Z], ~U[2026-02-11 00:00:00Z], ...],
#     values: [%{"count" => 12, "revenue" => 59880, ...}, ...]
#   }

5. Process with Series

Trifle.Stats.values("orders", from, to, :day)
|> Trifle.Stats.series()
|> Trifle.Stats.Series.transform_average("revenue", "count", "avg_order")
|> Trifle.Stats.Series.aggregate_sum("count")

Drivers

Driver Backend Best for
Postgres JSONB upsert Most production apps
MongoDB Document upsert Document-oriented stacks
Redis Hash increment High-throughput counters
MySQL JSON column MySQL shops
SQLite JSON1 extension Single-node apps, dev/test
Process In-memory (ETS) Testing

Features

  • Dynamic time granularities. Use any interval like 1m, 10m, 1h, 6h, 1d, 1w, 1mo, 1q, 1y.
  • Nested value hierarchies. Track dimensional breakdowns in a single call.
  • Pipe-friendly Series API. Chain aggregators, transponders, and formatters.
  • Precision mode. Decimal-based arithmetic for financial data.
  • Data compatible. Same storage format as the Ruby and Go implementations.

Documentation

Full guides, API reference, and examples at docs.trifle.io/trifle-stats-ex

Trifle Ecosystem

Trifle.Stats is the tracking layer. The ecosystem grows with you:

Component What it does
Trifle App Dashboards, alerts, scheduled reports, AI-powered chat. Cloud or self-hosted.
Trifle CLI Query and push metrics from the terminal. MCP server mode for AI agents.
Trifle::Stats (Ruby) Ruby implementation with the same API and storage format.
Trifle Stats (Go) Go implementation with the same API and storage format.

Contributing

Bug reports and pull requests are welcome on GitHub at https://github.com/trifle-io/trifle_stats.

License

The package is available as open source under the terms of the MIT License.

About

Time-series metrics for Elixir. Track counters and nested breakdowns in Postgres, MongoDB, Redis, MySQL, or SQLite.

Topics

Resources

License

Stars

Watchers

Forks

Contributors

Languages