This is a code review challenge designed to evaluate your understanding of complex distributed systems, database internals, and system design. The project represents a simplified e-commerce system with multiple services handling orders, payments, and analytics.
The system is designed to work with both MySQL and PostgreSQL databases, which introduces interesting challenges due to their different behaviors and characteristics.
Your task is to review this codebase and identify potential issues, problems, and areas for improvement. The codebase intentionally contains various issues that a senior engineer might encounter in real-world distributed systems.
Strong candidates will:
- Identify significant architectural and design issues
- Understand database internals and their implications
- Recognize distributed systems challenges
- Propose practical, well-reasoned solutions
- Consider trade-offs in their recommendations
- Propose systematic approaches to preventing similar issues