uts's Introduction

μts

μts is a miniature time-series database suitable for embedded or frontend web applications, weighing in at about 1.5 KB minified and gzipped.

Installation

npm install --save uts

Usage

This is an evolving project. Reading the source and the tests are the best way to see what it can do.

μts is schemaless, data is arranged in points, which contain one more columns, within series. Aggregations can be run which operate on points or columns. Currently supported aggregations are:

db.max(column: string) extracts the maximum value for the column
db.minimum(column: string) extracts the minimum value for the column
db.mean(column: string) calculates the mean for the column
db.top(column: string) returns the most recent value in the column
db.derivative(column: string) calculates the change in a column
db.map(column: string) extracts a list of column values from points in the series
db.map(iterator: (pt: Point) => any) can extract any data you want from points in the series!
db.reduce(iterator: (current: T, pt: Point) => T, initial: T) can reduce a column to a single data point.

import { TSDB } from "uts";

const db = new TSDB();

db.series('bandwidth').query({
  metrics: {
    mean: db.mean('bits'),
  },
  where: {
      time: { is: '>', than: Date.now() - 5 * 60 * 100 }
  },
  group: db.interval(30 * 1000, true),
});

// returns =>

[
  {
    group: { start: 1459513952592, end: 1459513982592 },
    results: {
      mean: 3511
    }
  }
]

Recommend Projects