FixAlert, Maintenance Platform
A computerized maintenance-management platform with asynchronous reporting, QR-based workflows, and Stripe billing.
Challenge
FixAlert needed its reporting and maintenance-tracking workflows rebuilt: database queries were slowing under load, PDF report generation and payments ran synchronously, and the analytics views needed more advanced filtering than the UI supported.
Solution
We eliminated N+1 queries and reworked database access patterns to keep the API responsive under heavy load. We moved bulk PDF generation, QR code workflows, and Stripe payments to asynchronous Celery pipelines. On the frontend, we revamped the UI, rebuilt the reporting metric views with React Query, and added nested filtering across analytics, property management, and role-based views.
Results
The API stayed responsive under load with the N+1 fixes in place, and reporting, PDF generation, and payments now run as background jobs instead of blocking the request cycle.