Rasanya Institute Web Portal
Innovative zero-cost database architecture serving a large student base.
Client
Rasanya Institute Kalutara
Focus Area
Official Educational Web Portal
Links
Services
Engineering & Architecture
The Challenge
A prominent education institute in Kalutara wanted to digitize timetables, course details, and announcements for daily student traffic, but required a solution that avoided recurring cloud database hosting fees and was simple enough for non-technical office staff to maintain.
The Solution
We engineered an innovative headless CMS architecture utilizing Google Sheets as a database, connected to a high-performance Next.js interface via Google Apps Script and Google Sheets API. Announcements made on Google Sheets update the website instantly.
Key Features
- Headless CMS flow connecting spreadsheet schedules to live schedules
- Ultra-fast page response times due to static site generation with ISR
- Responsive timetables built for easy mobile view by students
- Dynamic banners for active enrollment and exam announcement cards
The Stack
Frontend
Next.js, Tailwind CSS, Radix UI
Backend & Server
Google Apps Script, Vercel Serverless
Database
Google Sheets API (Headless CMS)
Measurable Impact
- Innovative 'Google Sheets as Backend' architecture using Google Apps Script
- Zero-cost database solution optimized for easy content management
- High-performance frontend built with Next.js for instant page loads
- Active production environment serving daily student traffic and timetables
Have a similar system architecture challenge?
Let's discuss how HelaCode can design, build, and deploy a custom solution tailored for your team's workflow.