Job Title:
Aeruqi.app
– Offline Educational App for Paragliding/Paramotor Exam Preparation (Flutter/React Native, Google Sheets Sync)
Job Description:
I'm looking for a senior mobile developer with proven experience to build Aeruqi.app
– a training platform for the official theoretical pilot exam for paragliding and paramotor in Uruguay.
The app must be robust, intuitive, and deliver a smooth user experience, with a strong emphasis on 100% offline functionality (pilots often study in remote areas without internet, like mountains or flight fields).
Key Mandatory Requirements:
1. 100% Offline Functionality The app must function completely offline. All questions, answers, and user statistics stored locally (SQLite or Hive). This is the #1 priority.
2. Existing Database I have a Google Sheet with 450 multiple-choice questions, organized in these categories:
- Aerodynamics
- Meteorology
- Flight Technique
- Paramotor
- Equipment
- Safety
- Medicine
- Legislation
Each question includes:
Number,
Category,
Question Text,
Options A/B/C/D,
Correct Answer(s)
– some with multiple correct answers (e.g., “A,B,D”).
3. Automatic Synchronization When internet is detected, auto-sync with the Google Sheet to update questions without erasing user progress. Sync must be secure, efficient, and delta-based (not full download every time).
4. Validation Logic Proper handling of single- and multi-correct answers. Immediate feedback: green for correct, red for incorrect.
Mandatory Study Modes:
1. Random Mode: User chooses number of questions (random selection, optional category filter).
2. Quick Test: 10 random questions across all categories.
3. Exam Simulation: 30 random questions mimicking the official exam (with timer).
Additional Mandatory Features:
- Per-category progress statistics (success %, questions answered, weak areas highlighted).
- Immediate visual feedback (green/red + optional explanation).
- Clean, simple, mobile-optimized UI (large buttons, easy navigation).
Future Scalability (very important):
Database must support adding other courses later (e.g., PPL – Private Pilot, UL – Ultralight) without core code changes.
Include a “course_id” or “license_type” field for filtering.
Preferred Technical Stack:
- Cross-platform: Flutter (preferred) or React Native.
- Android priority; iOS optional (budget permitting).
- Local DB: SQLite or Hive.
- Google Sheets API for sync.
- Clean, documented, scalable code.
- Strong error handling (no crashes on invalid Sheet format).
Contract Conditions:
- Fixed Price: USD 2,000 – 2,500 (negotiable based on experience, portfolio with published apps, offline-first projects).
- Timeline: 2 months from start.
- Daily progress updates + Git repo access.
- Payments: Milestones via Guru SafePay.
- 2 months free bug fixes post-delivery.
Deliverables:
- Full documented source code (Git repo).
- Short manual/video for updating Google Sheet link.
- Help publishing to Google Play (and App Store if iOS).
- APK (Android) + iOS build.
Proposal Requirements
Must Include:
- Links to published mobile apps (Google Play / App Store preferred).
- Proposed tech (Flutter or React Native) + brief justification.
- Detailed timeline with milestones/dates.
Brief answers to these 5 technical questions:
1. How to detect Google Sheet changes without full download every time?
2. Which local DB (SQLite or Hive) and why?
3. How to validate multi-correct answers?
4. How to prevent crashes on Sheet format errors?
5. How to design DB for future courses without core changes?
App Language Requirement:
The app must be fully in Spanish: all UI, question texts, options, explanations, and feedback in Spanish (target: Spanish-speaking pilots, later in English).
Future English version possible but not required initially.
Preference:
Developers from Latin America with excellent Spanish communication and GMT-3 (Uruguay) availability.
Looking forward to your detailed proposal!
... Show more