SieR-Te School Information System

Developed the backend architecture for a school information system from scratch, providing secure REST APIs to support student management, attendance, scheduling, academic journals, and classroom administration.

Schools require centralized digital systems to manage academic activities efficiently while supporting multiple user roles such as administrators, teachers, students, and parents.

Designed the relational database schema and implemented a modular backend using Go Fiber, GORM, and PostgreSQL with JWT authentication and role-based access control.

• Designed the relational database schema before API implementation to maintain data consistency.
• Implemented JWT authentication and Role-Based Access Control (RBAC) to support multiple user roles securely.
• Applied pagination and modular API design to improve maintainability and scalability.
• Structured the project following clean REST API principles for easier frontend integration.

• Designing a relational database with multiple interconnected academic entities.
• Managing authorization rules across different user roles.
• Maintaining API consistency while multiple modules were developed simultaneously.

• Database design has a significant impact on long-term backend maintainability.
• Well-designed API contracts simplify frontend collaboration.
• Planning system architecture early reduces technical debt during implementation.

• API versioning.
• Redis caching.
• Notification service.
• Microservice migration.
• Comprehensive automated testing.