Electronics Inventory — Parts, Stock & Projects
A private parts database that started in Notion and grew into a proper workshop tool across desktop, web and phone.
The system manages a working electronics inventory of more than 600 components. Each part can carry a manufacturer number, package, type, description, photograph, datasheet and supplier link, alongside current and minimum stock. Physical locations follow the real workshop hierarchy—location, box and compartment—so a search result leads to an actual component rather than another spreadsheet row.
Two interfaces share the same data. A PHP and MySQL web application provides direct browser access, while the Flutter application keeps a complete local Drift database on macOS, iOS and Linux. It remains useful offline, then pushes local changes and pulls the server delta. Stock movements travel as additions and removals rather than absolute totals, preventing two devices from silently overwriting each other.
The inventory also connects parts to build projects. Each project carries a status, description, dated logbook and attached documents. Optional Claude features can identify components from a photograph, extract markings and resistor bands, prepare a new record or complete missing fields—without replacing existing data. Project chat can search the local inventory read-only and only receives document contents when they are explicitly attached.
Security and ownership remain deliberately practical: password plus TOTP authentication, per-device API tokens, CSRF protection, strict session cookies, CSV export and full ZIP backups. Model access uses the owner’s own API key stored in the system keychain, and every core inventory function continues to work without it.
