• Project Name: QMarkets Home Assignment

• Version: 1.0

• Author: Viniak Dev Gupta

• Date: 29-October-2025

• Status: Complete

• Reviewed By: Viniak Dev Gupta

1. Overview

The Idea Voting & Ranking System is a full-stack micro-services solution enabling users to upvote ideas (e.g. feature suggestions or product improvements). The system ranks ideas in real time by vote count and is designed to scale efficiently for up to 1M votes per month.

Key goals:

• Real-time idea ranking updates.
• Scalable and modular service design.
• Duplicate vote prevention and high-performance caching.

2. Functional Requirements

The system is divided into multiple functional modules, each responsible for specific operations within the voting and ranking flow.

2.1 Idea Management Module

• Display all ideas with title, description, and vote count.
• Retrieve single idea details based on id.
• Maintain metadata such as author, creation date, and description.
• Each idea maintains a voteCount, synced with Redis for ranking purposes.
• Seed initial ideas (20) during setup.

2.2 Voting Module

• Allow users to cast one upvote per idea.
• Prevent duplicate votes using a (userId, ideaId) constraint.
• Each valid vote triggers two key actions:
  • Vote is recorded in PostgreSQL.
  • Redis ZSET is updated via ZINCRBY to reflect new scores.