Details
Name:
AgileStock Web
Programming Language:
Python
Secondary Language(s): SQL
Framework: Flask
Has Database: True
Cloud Hosted: True
This project was for computer science major capstone course. We, a team of 5, developed a desktop-and-web accessible software solution for book inventory management. Our application met the following requirements set:
- Must be able to scan a book's barcode for ISBN lookup
- Must search for universal available data about using the scanned ISBN
- Must store the book data for inventory management
- Must allow inventory access by web browser
Throughout the project (a three month timeline), we used Jira's software to develop in agile scrum methodology. I was the scrum master. I assigned our team members' workload each week. In weekly sprints, we accomplished varying tasks, from creating components, developing functionality, administering the production server to refining functions. The end result was successful requirements met; we developed a full-data-flow inventory management system that started with barcode scanning (hardware using a raspberry pi) to searching the barcode using an online data library to storing the books data in a cloud database to viewing the data in a website. Each team member was core to a flow operation in the development. AgileStock: The scanner system/desktop application was Noah's responsibility, as he focused on the hardware, driver development. AgileStockWeb: I took on the data movements and web display as I focused more on the web side.
- Agile development via Jira + kanban + sprint teams
- Application-layer software-first database programming
- Azure App Services
- Azure Database for MySQL
- JSON structure data flow
- Object oriented programming (OOP)
- Python SDK connector
- REST API -->Developers, see /api/inventoryitem GET
- Security tested
Links:
AgileStock (private repository) - Docs