Optimize PostgreSQL queries for gig filtering

[meshackyaro]

Description

This issue aims to address the implementation of Optimize PostgreSQL queries for gig filtering.

The core objective is to: Add composite indexes on the category and status columns.

By completing this feature, we will ensure that the TrustFlow protocol maintains its high standards for security, usability, and decentralized logic. This issue requires careful attention to the Backend architecture and adherence to the existing project conventions.

When picking up this issue, please ensure you document any new dependencies or architectural decisions made during development.

Component

Backend

Difficulty

🟡 Medium

Tasks

• Review Node.js API architecture in backend/
• Implement logic for: Optimize PostgreSQL queries for gig filtering
• Write unit tests for the new endpoints using Supertest
• Update Swagger terminology / OpenAPI specs
• Verify PostgreSQL queries are optimized
• Run npm run lint

Acceptance Criteria

• Feature accurately implements the objective: Add composite indexes on the category and status columns.
• Any PR that introduces TypeScript/Rust errors is automatically blocked
• CI pipeline runs in under 3 minutes per PR
• Code is properly reviewed and approved by codeowners

Estimated Time

4-8 hours