• 88°
The Madison Record

Pranav Somu develops database software for Foster Closet

MADISON – Pranav Somu, a junior at James Clemens High School, has developed software to help match resources with needs at North Alabama Foster Closet.

James Clemens teacher Emily Harris volunteers with Foster Closet and knew her students’ talents and interest in creating solutions for real-world problems.

The Foster Closet is a community-based, volunteer-run non-profit resource for foster, adoptive and kinship families across North Alabama. The organization meets tangible needs with new or gently used clothing, shoes, coats, furniture, gear and supplies.

In summer 2020, Foster Closet contacted James Clemens, searching to build an online database application. The proposition interested Pranav, who had completed programming courses and competitions and had growing passion in computer science.

“I knew a bit about foster care, but, honestly, I didn’t have much of an idea about why foster care is important or how it works,” Pranav said. After some reading, Pranav soon realized “how crucial foster care is to provide a safe and stable environment for kids who cannot stay with their parents for some unfortunate reason.”

“More than 400,000 children are in foster care nationwide – highlighting the importance of keeping the foster care system healthy,” Pranav said. “Less than three percent of foster children earn a college degree. Around 20 percent eventually become homeless.”

Fifty percent of new foster parents quit within one year because of adequate supplies.

Pranav logged 300-plus hours, developing thousands of lines of code for the project. “Creating this application was a brilliant opportunity to work on a real-world problem and give back to the community, all while gaining many, many new skills and practical experience,” Pranav said.

Foster Closet was using a massive Google form with thousands of disorganized entries. This process became outdated with increased clients and extremely slow computer response.

Building his application was the best way to help virtually during quarantine. Pranav’s goal was more streamlined communication to/from families, tracking requests and easier data collection/manipulation for grants — with little-to-no cost to Foster Closet.

Pranav’s software can help in expanding outreach, launching large-scale projects and increasing impact in foster community.

While developing this application, Pranav learned many new programming skills. He implemented the web framework, Django, for resources and connections for all required components. He built the front end (which people use to interact with the application) with Javascript, CSS, HTML and Django Template Language.

Pranav said the back end has two main parts:

* Data storing and management. — Using PostgreSQL database, Pranav learned SQL for setup and general management.

* General background processing and logic – Using Python software.

“For testing and evaluation, I’m hosting the application on Ubuntu virtual machine provided by DigitalOcean. Gunicorn, Nginx and other helper software to run and secure the app,” Pranav.


Triana, Madison libraries offer Makerspace for hi-tech crafts and more


Art Tour of Homes expands into Madison with Estes and Overcash houses

Bob Jones High School

Neha, Puja Chopade’s research with Harvard mentors published in journal


Wroblewski in 15-mile swimming challenge for Wounded Warriors


Huntsville Ballet Company announces new season

Digital Version

Check out the August 2022 issue of Madison Living


Madison teen charged with murder after allegedly shooting brother

Bob Jones High School

Madison Area Lions’ donations help school nurses


Trash Pandas hang on, beat Lookouts 3-2 in finale


NewsNation network lauds Rodney Smith’s free lawn care


UPDATE: Madison man accused of killing former girlfriend


RD3 Legacy 3-On-3 Basketball Tournament Set For August 13


Trash Pandas bounce back against Lookouts with 5-2 victory

Bob Jones High School

Beautification board issues awards for well-kept sites


Auburn alum Sonny DiChiara joins Trash Pandas


MPD: Family dispute leads to shooting in Madison


Former Huntsville business executive charged with wire fraud


Man charged with ex-girlfriend’s murder in Madison area


HPD makes drug bust in traffic stop


City of Huntsville mourns loss of Huntsville Fire & Rescue cadet


Weather ends Trash Pandas’ comeback bid in 4-3 loss

Bob Jones High School

PTA advises starting now for Reflections entries


Point Mallard water park to reduce hours because of ‘staffing challenges’

James Clemens High School

James Clemens JETSpress earns accolades at All American Film Festival