hi,
I'm sure that many people have done this... but I'll just write it downI'm only into pedal building, but recently I realized that what I have (of components) is a lot...
so I've built a database... "mysql" -- that is mariadb...
using a linux server... but it can be done on someone's PC too..
it is just a new project, at a very rudimentary level...
but already works great...
.... details, if someone's interested.... ↓
my greatest invention so far is to have different "tables" for different types of parts... resistors, caps, ICs, transistors, pots, jacks...
otherwise the one table would be far to "complex"...
so right now, when I suddenly decide to build something (simple things, like a Tube Screamer), I'll just go at it...
and when I don't find a cap or resistor of a certain value..
I'll search...
but no longer in my boxes but in the database
scenario #2:when I decide to build something... and I'm about to place an order to a local store anyhow,
I'll check the pots, for example... in the database...
and check relatively rare values of anything making sure I'll have them at hand...
I'll also check resistors (which I used to always buy, regardless of anything)...
just a few searches, and...
I won't buy everything... and 3x of everything... all the time...
nor will I assume that I already have what I need...
THE RESULT of this can largely differ from person to person...
my hope is that my stash won't grow anymore...
but I'll have what I need when I have that idea to build that (simple) thing..
for professionals, using a database could result in
making precise orders all the time...
that is, limiting the redundance -- like "oh, let me make it 20 or 200, sure what's sure"...
both your orders and your boxes will be streamlined...
and everything under control...
a database and the "user interface" -- a web page in a browser window --- doesn't have to be super fancy...
and if you manage to keep complexity down...
you'll love it...
+1:
another good invention of mine
is to indicate the "stash number", which can refer to a box or a room, whatever..
and this will release you from under the requirement to have everything at one place strictly...
you just place a number in the "stash" field, other than 1, and you'll know where to look
you'll know that when you don't find it, it's not missing, it's just in another box / room / heap...