Online Retail Store
A full retail storefront on Flask and MySQL handling complex SQL operations and concurrent multi-user login.
.png)
A fully working online retail store built on Flask, MySQL, and plain HTML and CSS — deliberately without an ORM, so the SQL stayed visible.
The point of the project was the database layer rather than the storefront: modeling a real catalog, orders, and users, then writing the queries that hold it together under concurrent access.
-
Complex SQL operations
Handled non-trivial relational operations directly against MySQL, using the robustness of the database rather than pushing logic into the application layer.
-
Session and user state
Maintained user state throughout the shopping flow and supported multi-user login, so several sessions could operate against the store at once without stepping on each other.