Implement Data Indexing & Search (Elasticsearch, Redis Cache)

[carlos-israelj]

Description

No search functionality. Users cannot search invoices by client name, amount, or date range. No caching layer, causing repeated DB queries.

Current State

Basic PostgreSQL queries only.

Problems

• No invoice search
• No caching (repeated DB queries)
• Slow queries at scale
• Poor UX for finding invoices

Proposed Solution

Elasticsearch for search, Redis for caching frequently accessed data.

Acceptance Criteria

• Elasticsearch indexes invoices
• Search by: client name, amount range, date range, status
• Redis caches hot invoice data (TTL: 5 min)
• Cache invalidation on updates
• Search API endpoint
• Frontend search UI
• <100ms search response time

ETA

3-4 weeks