ВКИ НГУ (PWA)
Schedule and Student Hub for VKI NSU College
О проекте и концепция
VKI NSU PWA is a high-speed mobile web application and Telegram Mini App built for students and faculty at VKI NSU. It resolves legacy schedule accessibility issues, operates fully offline via Service Workers, and adapts seamlessly across native devices.
Ключевые возможности
- Frontend built with React 19, Vite 6, SCSS, PWA (vite-plugin-pwa), and Lottie animations
- High-performance async Python & FastAPI backend with Tortoise ORM and PostgreSQL
- Offline-first schedule access via Service Workers and Cache Storage
- Native VAPID Web Push notifications and automatic schedule parser for groups and faculty
Инженерные вызовы и решения
Parsing Unstable Timetable File Structures
Source university schedule files feature broken grid structures, merged rows, and inconsistent teacher formatting.
Developed a robust Python parser utilizing pandas, openpyxl, and pymupdf to sanitize strings via regular expressions.
Zero-Connectivity Operation in Basement Classrooms
Students frequently inspect schedules inside basement classrooms where cellular connection is fully unavailable.
Integrated Service Workers running a Stale-While-Revalidate caching strategy to persist API responses locally.
Real-time Schedule Update Dissemination
Students miss last-minute room changes and cancellations due to the manual overhead of checking the college site.
Built a background subscription microservice delivering instant Web Push alerts (VAPID) on parsed modifications.
Выводы и вынесенный опыт
- PWAs are exceptionally well-suited for high-frequency utility apps.
- An offline-first mindset dramatically boosts user satisfaction in mobile web apps.