Time series database for interval and metering data

Unlike most time series databases, TSGrid understands discrete and interval data along with timezones. This makes TSGrid the perfect solution for high value metering and billing data

An open source time series database

TSGrid was developed for real world client projects
Simple API
TSGrid uses a simple REST API for DDL and DML style operations
Lightening Fast
Data is pre aggregated to different resolutions during ingestion
Configurable
Each database can be optimised for size and performance
Fully Documented
We don't claim we're perfect, but we know the value of good docs

How Does It Work

You're only a few simple steps away
1Download

Checkout the source and build a binary or docker image yourself; or download a prebuilt binary or image

2Deploy

TSGrid is a JVM application and has been successfully tested on Mac OSX, Linux, Docker and Kubernetes

3Launch

Once deployed your're ready to ready to create your first database. You're only a REST call away

POST /db HTTP/1.1
Host: localhost:8080
Content-Type: application/json

{
    "name": "page-clicks",
    "readingType": "Instant",
    "dataType": "Int",
    "resolutions": {
        "Raw": { "ttl": -1 },
        "Hourly": { "ttl": -1 },
        "Daily": { "ttl": -1 }
    },
    "aggregationType": "Sum",
    "aggregationTimezone": "UTC"
}
POST /db/test/data HTTP/1.1
Host: localhost:8080
Content-Type: application/json

[
  {
    "sensorId": 1,
    "time": "2020-01-01T00:00:00+00:00",
    "value": 10
  },
  {
    "sensorId": 2,
    "time": "2020-01-01T00:00:00+00:00",
    "value": 10
  }
]
GET /db/test/query HTTP/1.1
Host: localhost:8080
Content-Type: application/json

{
  "sensorIds": [1,2,3],
  "from": "2020-01-01T00:00:00Z",
  "until": "2020-01-03T00:00:00Z",
  "resolution": "Raw",
  "sensorAggregation": "None"
}
DELETE /db/test HTTP/1.1
Host: localhost:8080

Seamless Integrations

It's just REST, you can call TSGrid from anywhere

Get started today

Read our quickstart guide now!