Mini-Amazon Marketplace Website
Developed a CRUD-compliant e-commerce application using Python, Flask, and PostgreSQL, simulating complex user-product-order lifecycles, and implementing SQL queries for transactions and inventory tracking.
Media
Design Decisions
This project was one of my first times working on a full-stack application. The idea was to build a marketplace where users could list, buy, and sell items. To this end, we first set about creating a robust, normalized data schema. We created profiles, mapped out accessible routes and configured API endpoints using flask. Then to make sure that things were ready for our final demo, we did continuous testing, debugging, and cleaned up the frontend. On the SQL side of things, we also made sure to implement best practices (including pagination).
Key Learnings & Takeaways
In this project, I learned the fundamentals of full-stack development, and I also learned how to apply the theory that we learned in our Databases class to a real project. It was a very SQL heavy project, and it was a useful exercise to think through what was happening for each query.