I recently built a wine cellar in my home. The cellar holds ~700 bottles total with 500 bottles in the lower cabinets and 200 bottles in the racks. The lower cabinet have ~250 four inch tubes that are 21 inches long. The tubes are big enough to be double deep and hold pretty much any 750ml bottle that I own.
I’ve also installed about 550 adressable LED lights in the cabinets that surround each of the tubes. I’ve written an app that is deployed on top of my inventory system such that whenever I browse to an individual wine page it will light up the tubes where those wines are located.
I also posted a video of the app here:
It’s been a fun project. A few loose ends to tie up but it seems to be working well. My next enhancement will be to identify all the tubes that have empty spaces so I can fill them back up.