Back to Projects

Academia Falúa

Falúa is a mobile-first platform for managing student enrollments, class schedules, attendance tracking, payments, and invoicing. It automates key administrative tasks like monthly invoice generation and push notifications.

Project Showcase

Visual overview of the platform interfaces

Project Overview

Project Description

Falúa is a comprehensive class management system for an educational academy, built as a full-stack application with a serverless backend. A mobile-first platform for managing student enrollments, class schedules, attendance tracking, payments, and invoicing. The system automates key administrative tasks like monthly invoice generation, attendance-based class deductions, and multi-device push notifications.

Database Architecture

  • 13+ core tables with foreign key relationships
  • Database triggers for business logic automation
  • Timestamp-based migration system
  • Comprehensive audit logging (cron_executions, notifications_log)

DevOps & Best Practices

  • CI/CD Pipeline: Automated Testing with local Supabase instance validates all migrations.
  • Schema Validation: Verifies database structure integrity.
  • Auto-deployment: Successful tests trigger production deployment.
  • Scheduled Jobs: GitHub Actions cron for recurring tasks.

GitHub Workflow

  • Semantic commit messages (feat:, fix:, refactor:)
  • Migration-based database versioning
  • Local development environment with Supabase CLI
  • Edge Function documentation with Mermaid diagrams

Key Features

Automated Workflows

Monthly invoice generation via Cron jobs and smart attendance deduction system.

Multi-device Notifications

Real-time push notifications sent to all user devices via OneSignal integration.

Database Architecture

13+ core tables with complex foreign key relationships and automated triggers.

CI/CD Pipeline

Automated testing with local Supabase instances and schema validation.