YachtShop Admin Panel

Description

YachtShop Admin Panel –– a minimalist SPA for internal use by the YachtShop administration. Provides flexible functionality for analyzing the store's turnover

Technologies

Front-end stack

       

Back-end stack

     

DevOps stack

   

About the work done

General

• Implemented interconnected order and product tables with configurable pagination, sorting of all columns, column display settings and summaries for key columns
• Supports 6 types of filters, including a complex time slice filter, which involves non-trivial work with dates
• All table functionality is also implemented on the server side, which provides great application performance
• An order page and links from tables to products and categories of the YachtShop are also implemented

Back-end

• Designed a multilayer architecture with routing, controllers and application services on the Express framework
• Wrote complex SQL queries in native MS SQL query language
• Applied best practices like code reuse, isolation and parallelization of asynchronous operations
• Covered all scenarios with 34 isolated integration tests

Front-end

• Designed a minimalist frontend using a minimum of libraries on a performant Vite + Preact stack
• Implemented 6 custom hooks, including useFetch with generic type, loading and error states
• Implemented a tables using the TanStack Table v8 library