Comments by me@dagsunde.com (Top 1 by date)

That would be nice, if there was a fixed, well known number of Colors (or in my case, DeviceNames)...
But I don't know the number of DeviceNames at any given point, nor do I know their names.

I the last row entered for each deviceName in the database, one row for each existing DeviceName.