Non-profit completed

Somerville Museum

A web application for the Somerville Museum to catalog, search, and manage their collection of historical clothing items with advanced filtering and display capabilities. Created on a team of 10 developers.

Timeline

September 2, 2024 — May 15, 2025

Links

Technologies

React Next.js Node.js PostgreSQL Neon Clerk

🏆 Achievements

  • Digital preservation of historical artifacts
  • Advanced search & filtering system
  • User-friendly museum staff interface
  • Scalable inventory management

Project Overview

The Somerville Museum is a local cultural institution dedicated to educating and preserving the historical, artistic, and musical significance of Somerville, Massachusetts. As part of JumboCode’s 2024-2025 cohort, I’m currently working on a development team to create a comprehensive web application for managing their historical clothing inventory.

The Challenge

The Somerville Museum houses an extensive collection of historical clothing and textiles that represent decades of local history. However, they lacked a modern digital system to:

  • Catalog and organize their historical clothing collection
  • Enable staff to quickly search and locate specific items
  • Display items in an accessible, organized manner
  • Filter and sort items by various criteria (era, type, condition, etc.)
  • Preserve detailed information about each historical piece

Our Solution

We’re developing a full-stack web application that provides the museum with a powerful inventory management system specifically designed for historical clothing collections.

Core Features

  • Digital Catalog: Comprehensive database of historical clothing items with detailed metadata
  • Advanced Search: Multi-criteria search functionality by item type, era, material, condition, and more
  • Smart Filtering: Dynamic filters to quickly narrow down collections
  • Visual Display: Image galleries and detailed views for each clothing item
  • Item Management: Add, edit, and organize inventory items with rich data fields
  • Historical Context: Fields for provenance, historical significance, and cultural context

Technical Architecture

  • Frontend: Next.js with React for server-side rendering and optimal performance
  • Backend: Node.js API with RESTful endpoints
  • Database: PostgreSQL hosted on Neon for reliable, scalable data storage
  • Styling: Tailwind CSS for responsive, museum-appropriate design
  • Type Safety: TypeScript throughout for maintainable, error-free code

Team Collaboration

This project is being developed through JumboCode’s collaborative model:

  • Leadership: Holden Kittelberger (Project Manager), Zachary White (Tech Lead), Hannah Jiang (Designer)
  • Development Team: 8 student developers including myself
  • Client Partnership: Direct collaboration with Somerville Museum staff
  • Methodology: Agile development with bi-weekly client meetings and iterative feedback

Current Progress

As an ongoing project, we’ve achieved several key milestones:

  • Completed database schema design for historical clothing metadata
  • Implemented core CRUD operations for inventory management
  • Built responsive user interface with museum-friendly design
  • Developed advanced search and filtering capabilities
  • Created item detail views with image support
  • Established data validation and error handling systems

Personal Contributions

My contributions to this project include:

  • Database Design: Collaborating on PostgreSQL schema optimization for clothing metadata
  • Frontend Development: Building React components for search, filtering, and item display
  • API Integration: Connecting frontend components to backend services
  • User Experience: Implementing intuitive navigation and search interfaces
  • Data Management: Creating forms and workflows for item entry and editing
  • Testing: Writing unit tests and conducting user acceptance testing

Technical Challenges

Historical Data Complexity

Managing diverse metadata for historical clothing items requires flexible data models that can accommodate varying levels of information completeness and different categorization systems.

Search Performance

Implementing fast, relevant search across multiple text fields and metadata categories while maintaining database performance with growing inventory sizes.

User Interface Design

Creating an interface that serves both museum professionals and potential public-facing displays, balancing functionality with accessibility.

Cultural Impact

This project directly supports the Somerville Museum’s mission of historical preservation and community education. By digitizing their clothing collection, we’re:

  • Preserving historical artifacts for future generations
  • Making collections more accessible to researchers and the public
  • Enabling better curation and exhibition planning
  • Supporting the museum’s educational programs

Future Development

Planned enhancements for the system include:

  • Public-facing catalog for community access
  • Integration with existing museum management systems
  • Mobile-responsive design optimization
  • Advanced reporting and analytics features
  • Digital exhibition planning tools

Learning Outcomes

Working on this project has provided valuable experience in:

  • Museum Technology: Understanding the unique needs of cultural institutions
  • Historical Data Management: Working with complex, varied historical records
  • Stakeholder Collaboration: Direct client interaction and requirement gathering
  • Full-Stack Development: End-to-end application development with modern tools
  • Team Leadership: Contributing to technical decisions and mentoring newer developers

The Somerville Museum project represents the intersection of technology and cultural preservation, allowing me to contribute meaningful software solutions that support historical education and community engagement in Somerville.

Related Projects

Non-profit

Theatre@FIRST

Worked on a team of developers to create an inventory management system for Theatre@FIRST--a community theatre in Somerville, MA--to track costumes, props, and furniture with photo uploads, location tracking, and condition monitoring.

September 2, 2023 — May 15, 2024
-1