PappapaOriginal post
Web Developer
I have a solar monitor device that emits 10 parameters per minute, in Json format. What is the right way to store the data in DB:
- shall all minute entry be a separate document,
- or to keep all data from one device in one document,
- or to have multiple time-limited (daily, monthly) documents for one device?
- shall have separate collection for each device?
What is a reasonable number of collections and documents to deal with?
Summary
The user wants to know the best way to store sensor data in a database. They have a solar monitor device that emits 10 parameters per minute in JSON format. They are asking whether each minute's data should be a separate document or if all data from one device should be in one document. They also want to know if they should have time-limited documents or separate collections for each device. They are also seeking guidance on the reasonable number of collections and documents to handle.