EctoTimescaledb

Extend Ecto.Query to write TimescaleDB's SQL as builtin

Documentation

Installation

The package can be installed by adding ecto_timescaledb to your list of dependencies in mix.exs:

def deps do
  [
    {:ecto_timescaledb, "~> 0.6.0"}
  ]
end

Quick start

import Ecto.Query
import Ecto.Query.Timescaledb

from(s in Stat,
  select: [time_bucket("7 days", time, bucket), sum(s.avg)],
  group_by: fragment("bucket"),
  order_by: [desc: fragment("bucket")]
)