This tool mainly focus on streamline inventory and tracking of parts, materials, price, and selling price. The main feature of this is its web-based functionality that can be access easily. Which has additional feature of backing up the specific data when deleted.
- ⭐ Easy to access
- ⭐ Web-based feature (great for simultaneuous usage)
- ⭐ Minimal design with no additional bloated features
- ⭐ Use SQLite as its database with easiness to modify
- ⭐ Backup the deleted data with another database
graph TD
A[Start Streamlit App] --> B{User Action}
%% Add Item Logic
B -->|Add Item| C[Input Item Details]
C --> D[Insert into Main SQL DB]
D --> E[Display Success Message]
%% Search Logic
B -->|Search| F[Enter Search Query]
F --> G[Query Main SQL DB]
G --> H[Display Results in UI]
%% Delete Logic
B -->|Delete| I[Select Item to Remove]
I --> J[Fetch Item Data from Main DB]
J --> K[Insert Item into Backup DB]
K --> L[Delete Item from Main DB]
L --> M[Display Deletion Confirmed]
E --> B
H --> B
M --> B
- Enable environment
py -m venv .venv.venv\Scripts\activate- Requirements installation
pip install -r requirements.txt- Run the program using streamlit
streamlit run app.py- Check this out
https://sql-inventory-system.streamlit.app/