NotesCSBS
A full-stack academic document distribution platform built with Supabase PostgreSQL and Google Drive APIs, optimized for high caching and search engine indexing (SEO).
How I got this idea
My personal frustration with wasting time searching for notes across messy WhatsApp groups and broken Google Drive links right before exams.
Problem
- Lecture notes, previous year question papers, and syllabus resources for the BMSCE CSBS department were scattered across ephemeral groups and expired links.
- Students wasted valuable time trying to locate materials right before exams without a structured database.
Solution
- Engineering Approach: Built a centralized relational document distribution hub with secure role-based administrative access and file synchronization.
- Architecture: Implemented a Next.js/React frontend connected to a Supabase PostgreSQL database, linking document metadata to Google Drive cloud storage buckets.
- What I Personally Built: Configured the PostgreSQL schema, created Supabase Row Level Security (RLS) policies for user authentication, integrated the Google Drive API for download routing, and optimized search console SEO.
- Current Status & Result: Active academic portal that achieved 500+ organic clicks and 3K+ search impressions with an average Google search position of 4.7.
Google Search Console Metrics (SEO Traction)
* Note: The platform attracts BMSCE CSBS department users organically through on-page SEO targeting VTU, CIE, and SEE resource requests without active ad spend.
Hardest Technical Challenge
Managing high-stress concurrent file download requests during examination periods without encountering Google Drive API rate limiting. Solved by implementing an API caching layer on the server side and structuring metadata lookups in a PostgreSQL database to bypass direct Drive directory searches.
Project Demo / Interface
What I learned
- Relational database schema modeling and role-based Row Level Security (RLS).
- Third-party API integration and document routing pipelines.
- On-page SEO optimization targeting educational query structures.