TimescaleDB support

[nhedger]

Hi 👋,

I was thinking of creating a new database driver for TimescaleDB, but I stumbled upon your package and thought I could contribute the features to your package instead of reinventing the wheel.

Here are a couple ideas:

• Creating hypertables
• Introduce popular timescale functions

If that is something you'd be down with, please let me know, and if you'd instead not introduce Timescale features in there, no hard feelings, and I'll roll my own!

Cheers

[tpetry]

That would be awesome. I would like to work you on Timescale support!

I did an experiment long ago but ditched it as I believed there was no interest in it. You can start a PR anytime you like and we refine it. Or discuss the API here first.

But I would like to set Timescale 2.13 as minimum version. Some defaults are changed and the create_hypertable function is easier (less options). Starting by supporting an old version is in my opinion not a good option.

My idea would be to support the main features of Timescale:

• creation of hypertables
• adding a reorder policy
• activate/deactivate/change chunk skipping
• activate/deactivate compression
• create continous aggregates

[tpetry]

By using the official Timescale images there would also be more extensions available which would simplify further development in the future. And the GitHub CI test matrix can be extended to run with different PG versions.

This also kind of solves #70. But not exactly. In the future not the official image would be used (as requested) but one which also supports many more extensions to e.g. build support for PostGis etc.

https://github.com/timescale/timescaledb-docker-ha/

[nhedger]

Awesome, I'll circle back in a couple of days!

[tpetry]

This is now supported with release 2.2.0. It was a ton of work integrating it nicely into Laravel migrations.

[nhedger]

Wow, you're a legend. Definitely got sidetracked here, so I really appreciate you doing the work @tpetry !

[binaryfire]

Agreed, this is huge. Thanks @tpetry!