TimescaleDB Data Model

367 views Asked by At

I'm new to TimescaleDB and I have a question about how to model my data with it and hypertables. Just to give you a little bit of context, in the project I'm developing, I have time series data coming from a PLC with several sensors and, besides that, I have to store user information (email, password, etc.).

I discover TimescaleDB and I thought it would fit my necessities because it allows me to store the user data and the time series data in the same database.

However, what I don't understand is this: Should the user data be model as normal PostgreSQL tables and use hypertables only for time-series data? or Should both of them be inside a hypertable?

Do you think using TimescaleDB in this case is a good approach?

Thanks for reading my question!

0

There are 0 answers