Shiksha Postgres Adapter

GovTech Context

Edtech in India has expanded exponentially since the onset of Covid in a fragmented offline universe of public schools. Public schools form the backbone of education in India and as the world came online there have been no trustworthy ways for the public school education system to leverage the power of this edtech growth. Shiksha's mission is to empower the public education systems with edtech products that have delightful and dependable end user experiences, are interoperable with NDEAR building blocks and easy to build on.

Product Explanation

In Shiksha, deployers are able to create adapters which enable the middleware to connect to the deployer's backend. These adapters receive and send back objects confirming to the Shiksha spec. Within the adapter, deployers will map their own data schema to that of Shiksha. This project aims to create a reference adapter which can interact with a Postgres database. This can be given as a reference implementation to deployers who may not have an existing backend.

The project will involve creating a new adapter in Shiksha that uses Postgres as a backend. The schemas in Postgres can mimic the schemas from the Shiksha specification to make the implementation of the adapter simple.

Features to be Implemented

• Create reference DB schema in Postgres for all the Shiksha entities
• • Student
• • Teacher
• • School
• • Attendance
• • Holidays
• • Groups
• • Events
• • Config
• • Notifications
• • Worksheets
• Create a new adapter that uses this Postgres database to the Shiksha APIs

Learning Path

• Shiksha Adapter Design Design Interfaces
• Installing the backend for development
• Reference adapter files Student Attendance Groups

Category	Rating
Difficulty	**
Risk/Exploratory	**
Core Development	**
Skills	NodeJS, Postgres
Mentor	Ashwin
Project size	200 hours