Support for TimescaleDB

[theelderbeever]

It would be really cool to see support for some the Postgres wrappers out there. One such example is TimescaleDB which adds columnar storage to Postgres. Right now piccolo pretty much works out of the box for generating the basic table structure and then the extras like hyptertables can be done via .raw migrations.

That said if it ever feels doable it would be really cool to support some of their extra functions and utilities in python to heavily support python data applications.

Async python, async ORM, plus analytics engine with columnar storage would be the bees knees!

[dantownsend]

@theelderbeever I agree. I used Timescale in work for a while, and it seems to be getting more and more traction.

Even if there was some kind of extension for creating Hypertables.

I think that's why Postgres is so interesting at the moment, with all of the cool extensions.

[dantownsend]

Just getting some thoughts down for future reference.

The API could look something like:

# piccolo/extensions/timescaledb.py

class Hypertable(Table):
    def create_table(cls):
        # overrides create table, so it also creates a hypertable
        ...

And then

class MyTimeseriesTable(Hypertable):
    ...