How to use with Timescaledb / manual migrations

Hi! I'd love to be able to use Drizzle with Timescaledb, but I think it's not really possible out-of-the-box?

I think creating a timescaledb table is just a matter of:

  1. creating a normal table
  2. executing a statement like SELECT create_hypertable('my_table', 'timestamp');
is there a way to add a "decoration" on a Drizzle pgTable to tell the migration engine to add such a statement when creating the table?

or should I do a "manual migration" myself? and how?
@Andrii Sherman perhaps you have an idea?
Was this page helpful?