promscale icon indicating copy to clipboard operation
promscale copied to clipboard

Document how the Promscale SQL data are stored in the PostgreSQL database

Open mjf opened this issue 4 years ago • 2 comments

It would be very handy to provide us with some good visual representation of how exactly the SQL data are stored in the PostgreSQL database (also clarifying relations between them) so that writting complex SQL queries become less painful and more obvious. Thank you.

mjf avatar Apr 12 '21 08:04 mjf

Thank you for the feedback. I agree, a visual representation is something that is helpful to understand the promscale SQL arch better and will be useful in writing queries.

cc @cevian

harkishen avatar Apr 12 '21 08:04 harkishen

@mjf We have recently added documentation on SQL schema for metrics. Below are the docs pages created for same:

  1. https://github.com/timescale/promscale/blob/master/docs/sql_schema.md#data-model-schema
  2. https://github.com/timescale/promscale/blob/master/docs/data-model.md

Would appreciate your feedback on docs. Also, if the docs offer the information that the issue expects, feel free to close the issue. :)

VineethReddy02 avatar Aug 17 '22 06:08 VineethReddy02