How I Made My First Open-Source Contribution in 3 Hours at Build2Learn Chennai

Description and use

In 3 hours I built a review schema for the Noolagam digital library using TypeScript, Drizzle ORM, and SQLite, and integrated it into the project repository.

Problem

Suresh’s Noolagam digital library needed a Book Review System but lacked a backend schema for reviews.

Outcome

Successfully added a fully functional review schema in 3 hours, enabling frontend integration and future review features.

Workflow

• Met Suresh and identified review feature need
• Decided to use guest-user system due to incomplete login
• Designed review table schema in TypeScript with Drizzle ORM
• Used Gemini to understand foreign key cascade behavior
• Added username, reviewText, rating, isHidden, createdAt fields
• Created feature branch feature/book-reviews
• Wrote and tested schema code
• Pushed changes to repository

Evidence

I created a new feature branch (feature/book-reviews) in Suresh's project repository, wrote and tested the code, finalized the schema, and successfully pushed it to the repo

Source

A senior developer (Gokul anna) taught me how to use Claude AI as a pairing partner

Source