abishevs/techcache

Inventory Management Program for Small Warehouses such as Makerspaces/Workshops

TechCache - An Inventory Management Program for Small Warehouses such as Makerspaces/Workshops

MOTO

With TechCache, track each bolt and nut. So you can build and tweak, and never go nuts!

Why?

When working with electronics, one knows how many small parts are needed to be kept nearby. These are often purchased in bulk because you never know when a specific part or component will be needed again. But over a longer period, you may forget what was purchased and how much is left P.S. It's a bit harder for screws, nuts, and bolts, but one usually knows how much has been used and how much was bought.

Description

This program is intended to make it easier to keep track of all the components in your workshop, for example, in 3D printing projects, robotics, or similar activities.

In this program, you can save and keep track of how much you have of each item, have descriptions/manuals, links to purchase sites, etc.

• Catppuccin Mocha themed :)

Functionality

Created with Pyqt6

• Item information in a table view
• Edit/update item information by doubleclicking, to open an dialog box
• Add item, by clickin on a "+" button in bottom right corner
• RegEx searching. All columns included
• Column sorting by clicking on the header
• Export/import database in csv format

Installation on Unix

Q: How to install on windows?. A: windows? what's that?

git clone https://github.com/Abishevs/TechCache.git 
cd TechCache
py -m venv venv
source venv/bin/activate
pip install -r requirements.txt

Usage

cd src
py -m tech_cache.main

And then you can load in mock_data.csv, which is located in root directory. To test how it looks

TODO

• Add item delete functionality
• Add bulk select
• Create an pyinstaller

techcache's Issues

Item delete functionality missing

Implement item deleting in UI. I can think of two effective methods:

1. Either checkboxes in tableview and from within main view you can check in and delete item or items
2. Within edit dialog box as an simple button

Docs page not working, GH actions failing

Github pages is up and running but it shows the README.md and not docs.
Automated workflow is failing, thus not pushing current sphinx docs to gh-pages branch.

Diffrent Databases, besides sqlite.

It would be better to use an network DB so that inventory could be accessed from within different devices.
This way an better backup system could be used etc.

Maybe even an cloud based DB and not selfhosted.
DB suggestions:

1. PostgreSql
2. MySql