Project Overview
Aircub is an enterprise administration panel and client REST API designed for managing distributed hardware status monitoring, operational tracking, and customer engagement metrics. The goal was to build a secure, performant administration API supporting diverse hardware status streams.
Technical Accomplishments
1. Robust REST API Framework
- Architected all backend controllers, routing rules, and response wrappers using Laravel to maintain API format consistency.
- Designed access management layers, utilizing role-based access control (RBAC) to control admin endpoint permissions.
- Integrated query parameter filters to support flexible search, sorting, and cursor-based pagination.
2. Status Data Aggregations
- Optimized MySQL search execution times on device monitoring records by creating appropriate indexing schemes.
- Structured summary reports using SQL aggregations that generate operational stats over days, weeks, and months.
- Reduced server CPU stress during report generation by implementing a temporary cache lookup structure.