paulagrata.com Visit the site

05 / Web Apps

Pozy

A home-goods storefront concept inspired by the way real furniture stores curate a room.

  • JavaScript
  • Node.js
  • Express
  • Handlebars
  • MySQL
  • CSS

01 / The idea

Make browsing feel like looking around a room.

Pozy is a responsive home-goods storefront I built as my final project for Software Engineering Web Development final project. Paula + Cozy = Pozy. I wanted it to feel like a shop you could explore, with curated furniture collections and a complete flow from browsing products to reviewing what you added to your cart.

02 / The architecture

Keep the catalog separate from the storefront.

Node.js runs the application, Express handles incoming requests, and Handlebars renders the storefront on the server. MySQL stores the furniture records, including titles, descriptions, prices, and image paths. Express serves the images and stylesheets from the public directory, so the database stores a reference to each image rather than the image file itself.

03 / The challenge

Learn SQL by building a real catalog.

Pozy was my first time using SQL, and the biggest shift was learning to think about a product as a database record instead of a card in HTML. I had to decide which fields belonged in the table, choose data types for values like prices, and write queries that returned the right products for each collection. Seeing those query results turn into product cards made it click for me how the database, server, and template fit together.

04 / The build

Query the catalog and render two collections.

In index.js, I wrote an Express GET / route that uses mysql2 to query the EssentialFurniture and TopPickFurniture tables. I passed both result sets to res.render() so Handlebars could render each collection from database records instead of hard-coded product cards. I defined catalog prices as DECIMAL(10,2) to store them with two decimal places. For the shopping flow, I wrote the logic to add and remove items, calculate cart totals, and display the resulting total in the checkout view.

Pozy About Us