Hey everyone,

I’m looking for a system that:

  • I can self host
  • Is slim, because I don’t have beefy hardware (Intel J5040, 32GB RAM, shared by all VMs/containers)
  • can be used to create an inventory of all the tech/hardware that I have in my house (not exclusively IT, I also wasn’t to track things like warranty for my chainsaws and the like)
  • does take at least the device make/model, serial number (for insurance cases) and warranty dates
  • is not some kind of enterprise-how-many-items-of-this-article-do-i-have-in-stock-things, because that seems to be the only thing I seem to be able to find, and they neither match my use case nor do they seem to be lightweight enough.

… and honestly, I don’t even know where to start looking. Do you guys have any recommendations?

Of course, I could just use a spreadsheet, but where’s the fun in that?

EDIT: Thank you all so much for the engaged discussion and all the suggestions, you’re the best!

  • Saltarello@lemmy.worldEnglish
    1·
    12 days ago

    Another shout for Homebox. I used to use a spreadsheet but over time found I simply didn’t maintain it but I’ve found I always maintain Homebox.

    Homebox allows parent/child relationship between items & exports to spreadsheet.

    I dont utilise the QR code facility because my family members would not bother to use QR codes. Instead I’ve numbered all boxes in each location (attic, garage, basement etc), printed contents of each box & put the printout into physical folders left in each location so even the most Luddite in my family can easily locate stuff then, in theory, remember where they took it from & if the stars align & its my luck day, put the item back in the same box that they removed said item from. When that happens I always check my lottery numbers too!

    They can’t filter/search a physical printout but at least they can find stuff (I guess I should simply add a QR code to each printout for a best of both worlds solution).

    Overall I’ve found Homebox a useful, simple & fun tool

    • tankerkiller125@lemmy.worldEnglish
      0·
      12 days ago

      Howdy, the Hay-Kot version of Homebox has been archived and will no longer be getting updates. However, a team has taken over the development (and I’m one of the devs) over at https://homebox.software/ and we’ve already fixed some bugs and made some improvements (including Postgres support), and we’re working on the next big release now.

    • irmadlad@lemmy.worldEnglish
      1·
      10 days ago

      I’ve used Grocy.

      I use Grocy daily almost, but I think that is a bit more than what OP is looking for. I use it for my pantry inventory. I am somewhat of a prepper, tho I don’t prep for EOTW scenarios. Mostly for localized incidents, weather related disasters, imminent social uprisings, etc. I figure, if we start dropping nukes, point me towards the bright light and let it rip. I have no interest in ‘repopulating the earth’.

      I took a hand-scanner, disassembled it, and re-assembled it into a more form fitting box and mounted it conveniently in the pantry. When I bring groceries into the house, I scan them into inventory. When I use an item, I scan it out. I also use the Grocy mobile app. So, at any time I can view my inventory and see that I either have enough of an item, or need to replenish the stock.

  • ᕙ(⇀‸↼‶)ᕗ@lemm.eeEnglish
    0·
    13 days ago

    you want a gui. so cvs is weak. give nocodb a run. can do ANYTHING. cool product overviews, easy to create tables even with attachment like images.

  • Señor Mono@feddit.orgEnglish
    0·
    14 days ago

    This might be an unpopular opinion/solution but even for two small size sister companies we are doing inventory in a version controlled markdown file 🫣

    • jonne@infosec.pubEnglish
      0·
      14 days ago

      Honestly, a spreadsheet would be fine for this? I’m not super familiar with what an inventory management system does tho, so maybe it does things beyond what a spreadsheet can do.

    • DasFaultier@sh.itjust.worksOPEnglish
      0·
      14 days ago

      Not at all, I like .md, and I’m familiar with Git. A spreadsheet is not something that I would throw into Git, but an .md…

      • Señor Mono@feddit.orgEnglish
        0·
        14 days ago

        That is the reason Markdown and Git are used for a lot shenanigans these days. Knowledge bases, awesome-lists, documentations. You name it.

        If you got the right tools (sphinx, typora, mkdocs, …obsidian) you got a powerful toolchain.

  • qaz@lemmy.worldEnglish
    0·
    12 days ago

    I’ve been looking for something like this myself. I’ve tried:

    • NocoDB
    • Baserow
    • Homebox
    • Snipe-IT

    In the end I went with Grist. It may not be specifically designed for it, but it is very flexible.

  • WalnutLum@lemmy.mlEnglish
    0·
    12 days ago

    Libreoffice has a database engine and frontend that’s pretty applicable to Microsoft Access

    • N0x0n@lemmy.mlEnglish
      0·
      14 days ago

      While I do agree on the general sentiment to not overcomplicate things, homebox seems rather easy to use and intuitive.

      Being able to create qr code to put them on boxes and also have them directly accessible through the web interface is neat !

      However, there’s one thing that’s quite cumbersome… There isn’t a one button move everything to a new location. Someone already posted a feature request and got some traction :) so cross fingers this going be implemented in the near futur !!

      • conrad82@lemmy.worldEnglish
        0·
        14 days ago

        Yes, I agree, batch moving stuff is important. I haven’t had that problem yet, so let’s hope they add it before I move or something 😅