A “few” search improvements that would bump this from ‘marginally useful’ to ‘very useful’ for me:
Have a way to search for bulbs that are able to put out some value in a provided range of color temperatures. (E.g. searching for 1900-2700K would give you a bulb that produced 1950K, a bulb that produced 2600-3500K, etc.)
Have a way to select what color temperature the other data is based off of (in particular, CRI can vary widely depending on selected color temperature).
Have a column for Melanopic/Photopic ratio (and maybe a second for the driver peak frequency. GaN tends to be around 460nm-ish but it varies somewhat, and other LED techs do exist). Be aware that there are multiple definitions of this (linear scalings of each other). I’d just pick one and stick with it.
Have a column for if the bulb is rated for enclosed fixtures / humid environments / installation upside-down / etc.
Have a column for weight. This is a half-decent proxy for how decent the bulb heatsinking is, at least until bulb makers start Goodharting it.
Have a column for max observed bulb temperature. This is a half-decent proxy for bulb longevity.
Have a way to hide / show columns.
Add color coding to e.g. lumens too. Colors are far more easily glance-able than text.
It’s getting more difficult all the time to find ‘decent’ LED bulbs. By which I mean the niche I’m looking for is getting rapidly legislated out of existence. I’m starting to shift towards LED strips as a result, but standalone LED bulbs are still useful in many situations…
Probably a dumb question but I’ll ask anyway, of the different criteria you measured, which column should the average user organize by, to find the “best” bulb?
One question that seems to pop up a lot in regards to smart bulbs is how low they can be dimmed.
People need to find those that can be used in a night light setting.
Hard to say… right now it’s more of a DB for comparing lights apples to apples. So if you want to see which of two lights has better RGB gamut, you can do that, for example.
Or which ones have better white tolerance (aka black body deviation)
I haven’t developed a metric to give each light an overall score yet.
Personally I gave up on Lfix because it so difficult to read the code on the bulbs, even with glasses. I have 8 Kasa bulbs that work fine with no flickering.
So, it all depends on one’s experience.
wish I could remember my old HA login…