Hi,
Should I use multiple databases or a single database with tags? Let me explain... The use is monitoring environmental data for various buildings where the building owner is responsible to determine what they wish to archive. There are multiple building owners or "groups". Each group will never share data. Queries will only retrieve data associated with a given group at a time. Multiple inserts will happen for a given group at once, but will not happen for multiple groups at once. Timestamps will not be common for multiple groups unless by chance. There is currently only one group, but I hope that there will be 100+ groups. Laymen will be responsible for choosing the measurements such as "Room 27 Temperature", "Room 101 Humidity", "Gymnasium Gas", " Gymnasium Electricity", etc. Each group will have between 50 and 500 things they are interested in, and things may be added (or removed) in the future. Field names for a given group will always be unique, yet may not be unique across all groups (unless a surrogate name is used). A typical query is selecting the average gym gas, gym electricity, kitchen gas, and kitchen electricity for group "Oakland School District" over 3 years. Should I have one database per group, and a field name for each thing to monitor? Should the location (i.e. Room 27) or the measurement (i.e. temperature) be tags, or should the field specify both? Or should I use a single database? If so, how might that look? Thank you -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/7e97bb79-fb97-4e40-90f0-854330eb6a08%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
