Bunk Beds Futons and More

Bunk Beds Futons and More is an eCommerce website designed to sell furniture products for homes and shared spaces.The site focuses on practicality, product clarity, and ease of purchase.

• Managing large product listings
• Ensuring clarity around sizing and delivery
• Optimizing performance with rich images

• E-commerce Platform Selection: Selected standard catalog data structures over custom database schemas to leverage proven order and shopping cart state designs. The trade-off was managing catalog data synchronization complexities, which was preferred over building custom transaction logic.
• Database Catalog Indexing: Used relational database-level indexing for simple catalog lookups. Accepted the trade-off of higher memory usage on database nodes to avoid the operational complexity of integrating an external search engine.

• Furniture product catalog
• Detailed dimensions and specifications
• Secure checkout process
• Category-based browsing

• Deadlock Mitigation: Discovered that database queries during concurrent updates must execute in sequential order using transaction blocks to prevent locking issues.
• Schema Drift Control: Established strict migrations scripts checks to verify database schema consistency across staging and production environments.