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

device in devices]) Any thoughts or suggestions? On Wednesday, July 30, 2014 2:11:49 PM UTC-5, Joshua Lyon wrote: > > 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.

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