search

me-box / zestdb

ZestDB
MIT License
18 stars 3 forks source link

Query language #23

Open jptmoore opened 6 years ago

jptmoore commented 6 years ago

The current API is path based and only operates on a single stream of time series data. This API does not scale well or support joining together and carrying out operations on data from multiple time series streams. I useful addition would be a simple query language to give this type of flexibility.

jptmoore commented 6 years ago

Before attempting this I will extend the path API to handle multiple id's.

e.g. /ts/<id1, id2>/length

which would provide the length of the combined time series id1 and and id2

jptmoore commented 6 years ago

A first go at what some queries might look like that could map to tokens for verification:

post 42.0 to "sensor1" where "serial" is "A001" on host "foo"

get max from "sensor1","sensor2" where "serial" contains "A00" since "1h" on host "foo"

observe from "sensor1" where "serial" contains "A00" with last 100 on host "foo" for "60s"

delete from "sensor1","sensor2" from "1h" to "now" on host "foo"

Toshbrown commented 6 years ago

@jptmoore might be worth moving this to the databox repo, not everyone follows this one.

I have many questions, lets discuss it on the next call.