Skills Involved
The design and implementation of this program required:
- Developed a Pokemon card collection app enabling users to efficiently track and store detailed data.
- Designed and implemented a relational database schema from an ER diagram, leveraging MySQL to manage and optimize data storage, ensuring efficient retrieval and manipulation of Pokemon card information.
- Created multiple indices within the relational database, optimizing query performance and ensuring swift access to frequently queried data, enhancing the overall user experience.
- Formulated complex SQL queries for data manipulation and retrieval, integrating them into a web-based interface using Flask to deliver a seamless and responsive user experience.
Description
- Category: Card Collecting
- Language: Python
- Course: N/A, personal
- Project Code: Download Here
About The Program
I was inspired to create this program by my little brother, who is an avid vintage card collector. However, finding specific cards at a specific price proved challenging. This application also scrapes Ebay for data via Selenium, and ultimately optimizes the card collecting process.