Flutter Quiz App with Telegram-PGSQL Integration
Budget: ₹12,500 – ₹37,500 INR
Quiz App with Telegram Bot Integration & PostgreSQL Backend
Project Title
Quiz App with Telegram Bot Integration & PostgreSQL Backend
Project Overview
I want to build a mobile Quiz App using Flutter that offers subject-wise and chapter-wise quizzes to students. The app will include a login/signup system, subscription payment flow, and be connected to a PostgreSQL database hosted on Hostinger.
A unique aspect is the payment verification system via a Telegram bot — users upload a screenshot of their payment, and it gets forwarded to a Telegram group for admin approval.
Note: I have already built the Telegram bot. The developer just needs to integrate it with the app/system so that uploaded payment screenshots are automatically sent to my Telegram group.
Platform
• Flutter (iOS & Android)
• PostgreSQL (Hostinger)
• Telegram Bot Integration (Bot is already built)
Features Required
1. Home Page
- App name/logo
- Course details section
- Testimonials
- Login / Signup buttons
2. User Authentication
- Email & password login/signup
- Store password as hashed value
- Basic session management
3. Subscription Plans
- Display 2 plans: Yearly and Lifetime
- Show UPI QR code for payment
- After payment, user uploads screenshot
- Screenshot is forwarded to my Telegram group
- Admin manually approves and marks user as verified
4. Course Access (After Approval)
- Subject → Chapter → Quiz selection flow
5. Quiz System
- Load questions from PostgreSQL
- Display 1 question at a time
- Show 4 options
- On selection:
• Show correct answer
• Show explanation (if available)
- "Next" button to navigate
- End of quiz: show score and "Go Back" to chapter list
6. Admin Verification Flow
- Payment screenshot uploaded by user
- Automatically forwarded to Telegram group via bot
- Admin manually verifies the user (mark in database)
- After approval, user gains access
PostgreSQL Schema Requirements
• users: id, name, email, password_hash, subscription_type, is_verified, created_at, expires_at
• subjects: id, name
• chapters: id, subject_id, name
• quizzes: id, chapter_id, title, created_at
• questions: id, quiz_id, question_text, option_a, option_b, option_c, option_d, correct_option, explanation
• quiz_attempts: id, user_id, quiz_id, score, total, attempted_at
Deliverables
- Complete Flutter app with all features above
- PostgreSQL integration (hosted on my Hostinger database)
- Connection of app with Telegram bot (bot is ready)
- Clean and maintainable code
- Any basic instructions for deployment
Developer Is NOT Responsible For
- Creating the Telegram bot (already done)
- Hosting setup or domain purchases
Timeline & Budget
Please mention your timeline and quote while applying.
Project Title
Quiz App with Telegram Bot Integration & PostgreSQL Backend
Project Overview
I want to build a mobile Quiz App using Flutter that offers subject-wise and chapter-wise quizzes to students. The app will include a login/signup system, subscription payment flow, and be connected to a PostgreSQL database hosted on Hostinger.
A unique aspect is the payment verification system via a Telegram bot — users upload a screenshot of their payment, and it gets forwarded to a Telegram group for admin approval.
Note: I have already built the Telegram bot. The developer just needs to integrate it with the app/system so that uploaded payment screenshots are automatically sent to my Telegram group.
Platform
• Flutter (iOS & Android)
• PostgreSQL (Hostinger)
• Telegram Bot Integration (Bot is already built)
Features Required
1. Home Page
- App name/logo
- Course details section
- Testimonials
- Login / Signup buttons
2. User Authentication
- Email & password login/signup
- Store password as hashed value
- Basic session management
3. Subscription Plans
- Display 2 plans: Yearly and Lifetime
- Show UPI QR code for payment
- After payment, user uploads screenshot
- Screenshot is forwarded to my Telegram group
- Admin manually approves and marks user as verified
4. Course Access (After Approval)
- Subject → Chapter → Quiz selection flow
5. Quiz System
- Load questions from PostgreSQL
- Display 1 question at a time
- Show 4 options
- On selection:
• Show correct answer
• Show explanation (if available)
- "Next" button to navigate
- End of quiz: show score and "Go Back" to chapter list
6. Admin Verification Flow
- Payment screenshot uploaded by user
- Automatically forwarded to Telegram group via bot
- Admin manually verifies the user (mark in database)
- After approval, user gains access
PostgreSQL Schema Requirements
• users: id, name, email, password_hash, subscription_type, is_verified, created_at, expires_at
• subjects: id, name
• chapters: id, subject_id, name
• quizzes: id, chapter_id, title, created_at
• questions: id, quiz_id, question_text, option_a, option_b, option_c, option_d, correct_option, explanation
• quiz_attempts: id, user_id, quiz_id, score, total, attempted_at
Deliverables
- Complete Flutter app with all features above
- PostgreSQL integration (hosted on my Hostinger database)
- Connection of app with Telegram bot (bot is ready)
- Clean and maintainable code
- Any basic instructions for deployment
Developer Is NOT Responsible For
- Creating the Telegram bot (already done)
- Hosting setup or domain purchases
Timeline & Budget
Please mention your timeline and quote while applying.