search

telefonicaid / fiware-cygnus

A connector in charge of persisting context data sources into other third-party databases and storage systems, creating a historical view of the context
https://fiware-cygnus.rtfd.io/
GNU Affero General Public License v3.0
64 stars 104 forks source link

Sink for TimescaleDB #1878

Open ilveroluca opened 4 years ago

ilveroluca commented 4 years ago

Hi,

it would be great to have a Cygnus sink for TimescaleDB (https://docs.timescale.com/latest/introduction). TimescaleDB is an extension for PostgreSQL that brings advantages to the handling of time series data.

At first glance, it looks support for TimescaleDB could be implemented as a simple variation to the PostgreSQL sink. The basic behaviour is identical: only the table creation statement needs to be modified.

Cheers.

fgalan commented 4 years ago

Thanks for the feedback! I think it could be a good addition to the sinks ecosystem in Cygnus. We would be more than happy to review any pull request contributing with this new sink.

Maybe you can carry out that contribution, please? I guess that if you have proposed this issue you have a clear idea in mind on how to implement it and test it, so you are probably the best candidate to do it ;)

ilveroluca commented 4 years ago

:-D I have no direct experience with Cygnus development and I have never even built it from source, so I was hoping to find an eager adopter of the idea. I'll have a look at your development docs...