Development of a Web Application with CRUD Operations Using Python, Flask, MySQL, and Docker: A Practical Approach for Order Management Systems

This paper presents the development of a complete web application for managing customers and orders, implemented with create, read, update, and delete (CRUD) operations using the Flask framework in Python, a relational MySQL database, and containerization with Docker. The adopted architecture combines a Python backend with HTML templates rendered through the Jinja2 engine and styling using the Bootstrap 5 framework. The application manages two main entities, Customer and Order, which are related through a foreign key, and exposes HTTP routes for all operations on these entities. The database environment is provisioned via Docker Compose, ensuring portability and reproducibility of the development environment. The results demonstrate that the combination of these technologies enables the construction of functional, well-organized, and easily deployable systems with low operational cost. The solution proved to be suitable for academic scenarios and rapid prototyping, highlighting the advantages of containerization and web microframeworks in building data-driven applications.