Over the past couple of years, I have acquired many different electronic parts. Today, I decided to build a primitive inventory tracking system. With the system, I can allocate parts to certain projects, and track what parts I need to buy. I also added in search functionality, which enables me to look for certain parts, like diodes or transistors, return the quantity remaining and the location of the bin.
So if I search diode, I get the following results:
And if I search for an NPN transistor, I get the following results:
I still have to enter a ton of data to make this system useful for my personal lab, but for right now it is a pretty good proof of concept.