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 1.17K+ organic clicks and 9.75K+ search impressions with an average CTR of 12% and average Google search position of 4.9 across a 12-month period.
Search Performance Telemetry (Google Search Console)
* Performance telemetry from Google Search Console over a 12-month period for academic engineering queries, syllabus keywords, and BMSCE CSBS department study material requests.
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.