Re: Get latest timestamp+value from each group

Or if you have a "latest" boolean, that would also work. -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to th

Re: Get latest timestamp+value from each group

Thanks for the feedback. I'm not sure I would want to change the Device object directly, but I might consider a separate Snapshot object which keeps record of the latest Log object per Device. If I go down that route, I think I'll have to analyze a bit more between a One-to-One relationship

Re: Get latest timestamp+value from each group

I'm not an ORM/SQL pro myself, so if I were doing this, I would just cache/denoralize the last value onto the device whenever there's a new log. -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving e

Re: Get latest timestamp+value from each group

I would also add that using the Max ID as the annotation field for the device (group) is what I am using in the interim, but it only works since currently my log IDs are automatically generated and each newly entered timestamp is younger than the previous. My concern is that I would like to ext

Get latest timestamp+value from each group

I have a basic Django application which uses sqlite as a backend on low-end hardware (eg. Raspberry Pi). I have the RPi collecting sensor data and logging it. I am trying to get the last process value, timestamp, and associated sensor name in an efficient way, but can't seem to figure it out wi