Inventory Management System

its a electronics parts inventory that tracks how many of each part you own, how many are in projects, and how many you can actually use for a new project.

try it: https://web-production-d6073.up.railway.app
demo login: demo / stardancedemo

what it is

almost all of the other inventory tool assumes that once a part is used, it never comes back, which work for warehouses, not smaller projects
start a project, it holds parts. tear it down, say what happened to each one: returned, soldered in, or broken
only soldered and broken actually leave your inventory
shopping list builds itself out of what your live builds asked for and couldn’t get
every quantity change is logged with the balance it produced and the project that caused it
10k and 10KΩ are one resistor to me and two rows to a database. it catches those and merges them

what was hard

picking what to store. i store owned only, and compute held and available, so they can’t drift apart
allocation used to refuse you if you were short. that meant a project could never be short, which meant the shopping list had nothing to build from. had to let it take what exists and record the rest
making teardown undoable needed a whole extra field, because returned parts come from two different places and mixing them makes it unreversible
fuzzy matching without being too fuzzy. 4.7k and 47k are different resistors so you can’t just strip punctuation
tests found 4 bugs i thought were fine. 2 of them were failing silently

what im proud of

the ledger. every number on the site has a receipt, and there’s a command that recounts and tells you if it’s lying
teardown being reversible. it was a one way door and that was scary to use

how to test it

log in as demo, go to bench
open weather station, hit tear down, mark a few soldered and a few broken, submit
watch owned drop, then hit reopen and watch it all come back
bench again for the shopping list. 12 parts short across live builds
click any part for its history table. every row says what changed and what it left behind
parts > duplicates. 10k/10KΩ and 470uF/470 µF are sitting there as separate rows. merge one and watch the quantities add up
or add a part called 10K ohm yourself and watch it get caught immediately

2 devlogs
7h

Try project → See source code →

Open comments for this post

@Vedant_Daga on Inventory Management System · 3 days ago

4h 28m 50s logged

ANYONE REVIEWING OR RATING, THE RAILWAY URL IS CLOSED AND I SWITCHED TO VERCEL. GO TO THE GITHUB OR THE PROJECT DETAILS

Devlog 2 - Inventory Management System

what changed

the app tracks WHY a number moved now, not just what it is
add stock, recount, teardown loss: all logged with a running balance
a part’s page reads like a bank statement
teardown can be undone (it was permanent before, on a 2 click button)
shopping list that isnt tied to a project, for “im running low on 10ks”
duplicate detection + merge. 10k, 10 K and 10kΩ are one resistor to a
human and 3 rows to a database
tags actually do smth now: click to filter, autocomplete, rename everywhere
sortable columns, bench dashboard, paste-a-list import, rate limiting, backups

bugs (the fun part save meeeeeeeee 🙏 )

making a part skipped the ledger completely. worked fine cuz the views
covered it, which is how that survives until someone adds a 5th path
deliveries read a stale number and left parts on the shopping list AFTER
they arrived. silent, no error, nothing
a literal backspace char got into a regex from shell escaping so it could
never match. found it cuz 10kohms refused to fold into 10k
named a flag --stdout and django remapped its own stdout kwarg onto it.
backups looked fine and wrote to nowhere

Open comments for this post

@Vedant_Daga on Inventory Management System · 18 days ago

2h 9m 8s logged

Devlog 1 - Inventory Management System

basically all of the sensors i own (A LOTTTTT) all live in one giant bin
(ill send a pic of it in the next devlog trust). so recently, my dad fried me
because i bought the same temperature sensor i bought like 3 weeks ago or smth (DHT22 for anyone intrested).

basically what im building is a web app that acts like a inventory system for all my sensors. the thing that makes this diff from a spreadsheet or google docs is that this is SUPPOSED to be able to track ur parts are in use, soldered, broken, or available (not even close to there yet)

the main reason i chose that type of system is because when i tried using a spreadsheet (ik, 1900s) it worked until i made more than 2 projects. with one project it works perfectly, but i have multiple projects at a time, each either
on a perfboard or soldered down. and then some of them smoke, burn out, or even are faulty.

the main thing about this app is that its going to be able to store what parts were used in ur project, and when u say u disassembled it, it will automatically move those parts back based on what you said — soldered, broken, reuseable.

the empty app

right now the app is literally empty. its just the Django admin page. i just spent some time getting everything linked like a new repo, railway app, postgres database, etc. i wanted to deploy everything rn rather than later cuz i dont want it to be a pain once i get to shipping this.

it took like 2ish hours in total so not that bad, and basically none of it was
using Django other than the admin page. the main problem i faced was
ModuleNotFoundError: No module named '________' (shh i left it blank). i
saved a new start command and a predeploy command so it works better.