How difficult can be creating an hypertable in TimescaleDB?

It seems that pretty much of a fucking lot.

#PostgreSQL #TimescaleDB #Hypertable #Hypertables #SQL #RDBMS #RelationalDatabase #Database #Databases #Programming #SoftwareDevelopment #DatabaseDevelopment

Today a slightly different "best practices" blog post, about the idea of using separate "metadata" tables to store information about time-series in your (not only) #TimeScaleDB #Hypertable(s), like valid range, device assigment, whatever. 🤯🥳

Also great for deduplicating additional data per row and externalize them 🙂🤟

https://tsdb.co/metadT

Best Practices for (Time-)Series Metadata Tables

Now that you know how to design your Timescale hypertable, learn more about making your data available fast with separate tables for metadata information and series lookups.

Timescale Blog