cube icon indicating copy to clipboard operation
cube copied to clipboard

Timeseries databases support

Open throrin19 opened this issue 5 years ago • 10 comments

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

throrin19 avatar Mar 29 '19 08:03 throrin19

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.

keydunov avatar Mar 29 '19 09:03 keydunov

@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 avatar Mar 29 '19 09:03 paveltiunov

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

paveltiunov avatar Apr 03 '19 14:04 paveltiunov

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

throrin19 avatar Apr 04 '19 06:04 throrin19

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

langhuihui avatar Jul 25 '19 07:07 langhuihui

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

chicco785 avatar Nov 19 '20 05:11 chicco785

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

aaronovz1 avatar Aug 04 '22 18:08 aaronovz1

Hope to have InfluxDB and TimescaleDB supported as well.

wolvever avatar Dec 11 '23 02:12 wolvever

So does cube work with TimescaleDB ?

leonard-henriquez avatar Dec 19 '23 23:12 leonard-henriquez

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.

joshhubers avatar Dec 21 '23 16:12 joshhubers