search

cube-js / cube

📊 Cube — Universal semantic layer platform for AI, BI, spreadsheets, and embedded analytics
https://cube.dev
Other
17.97k stars 1.78k forks source link

Timeseries databases support #58

Open throrin19 opened 5 years ago

throrin19 commented 5 years ago

It would be cool if this project could add support for timeseries databases like graphite or influxDB

keydunov commented 5 years ago

I'm afraid Cube.js could not work with NoSQL databases by design. But I think support for a time series SQL database, like TimescaleDB would fantastic.

paveltiunov commented 5 years ago

@keydunov Actually InfluxDB has limited SQL support. @throrin19 Hey Benjamin! We don't have Influx in our roadmap right now but we would love to support you in implementation of InfluxDB driver and dialect. If you're familiar with InfluxDB in general I think it shouldn't take more than couple of days. Please let us know if you have some spare time for it.

paveltiunov commented 5 years ago

@throrin19 Hey Benjamin! Here's contribution guide on how to implement driver: https://github.com/statsbotco/cube.js/blob/master/CONTRIBUTING.md#implementing-driver

throrin19 commented 5 years ago

Hi, Thanks for the resources. For now I don't have time to do that but, if I find some spare time, I will try to make this

langhuihui commented 5 years ago

InfluxDB and Cube.js together can be a greate solution for developing monitor system.

chicco785 commented 4 years ago

hey, has anyone tested it with Timescale? if think it should work out of the box

aaronovz1 commented 2 years ago

Can anyone confirm this works with TimescaleDB? I'm guessing certain things like time_bucket syntax wouldn't work out of the box

wolvever commented 11 months ago

Hope to have InfluxDB and TimescaleDB supported as well.

leonard-henriquez commented 11 months ago

So does cube work with TimescaleDB ?

joshhubers commented 11 months ago

We use CubeJS in our production environment with a TimescaleDB, it works great, but doesn't leverage any special TimescaleDB functions, we have the connection set up as a postgres connection.