Web system for warehouse management and analytics on Python & Flask
Project essence:
Developed a lightweight and fault-tolerant Fullstack inventory management system (SKU) for small businesses. The application automates inventory tracking, records sales in real-time, and generates operational analytics. The project is built on an MVC architecture.
Technical stack: Python 3, Flask, SQLite3, HTML5, Tailwind CSS, Git.
Key features:
1. Reliable DB architecture: 3 related tables, data integrity protected through FOREIGN KEYS and CHECK constraints.
2. Transactional security (ACID): Write-offs and logging are wrapped in SQL transactions with commit and rollback mechanisms to protect against failures.
3. Advanced SQL analytics: Optimized queries with LEFT JOIN, SUM, and GROUP BY to display TOP sales and low stock alerts.
4. Automatic deployment: DB is created automatically on the first launch.
#python #flask #sqlite #sql #backend #fullstack #web-development #inventory
Developed a lightweight and fault-tolerant Fullstack inventory management system (SKU) for small businesses. The application automates inventory tracking, records sales in real-time, and generates operational analytics. The project is built on an MVC architecture.
Technical stack: Python 3, Flask, SQLite3, HTML5, Tailwind CSS, Git.
Key features:
1. Reliable DB architecture: 3 related tables, data integrity protected through FOREIGN KEYS and CHECK constraints.
2. Transactional security (ACID): Write-offs and logging are wrapped in SQL transactions with commit and rollback mechanisms to protect against failures.
3. Advanced SQL analytics: Optimized queries with LEFT JOIN, SUM, and GROUP BY to display TOP sales and low stock alerts.
4. Automatic deployment: DB is created automatically on the first launch.
#python #flask #sqlite #sql #backend #fullstack #web-development #inventory
Sumy 
Available for hire
Offer work