The goal was to create an engaging and functional website for pet adoption that allows users to view, add, update, and delete pet listings effectively using a clean and friendly interface.
The data model was crafted to capture essential and unique attributes of pets, such as name, image URL, description, and adoption status, using Sequelize within a MySQL database framework. Routes were meticulously planned to facilitate efficient CRUD operations.
Implemented an MVC design pattern with Sequelize to interact with the MySQL database, ensuring robust data handling and service layer abstraction. Express routes were set up to handle requests, and Handlebars templates were used to render views dynamically based on the database content.
Setting up Sequelize for optimal performance and integrating it with Express posed initial challenges, especially in managing asynchronous CRUD operations and ensuring data consistency across views.
Successfully streamlined the Sequelize integration by correctly configuring model associations and utilizing middleware for error handling and session management, significantly improving the application's reliability and user experience.
The final product is a functional pet adoption website simplifying pet management and adoption. It features a user-friendly interface, easy navigation, and immediate updates reflecting the real-time status of the pets in the shelter.