Work / Case study
Community, Events & E-Commerce Platform
A community platform connecting editorial content, members, live events, performance histories, media and e-commerce.
The business problem
Recurring community activity generated more than pages to publish. Participants, events, performances and media needed to remain connected so that people could explore both current activity and the history behind it.
What was built
A custom web platform brought structured editorial content, member profiles, recurring events, performance records, ticketing, e-commerce and community discussion into one environment.
A digital record of real-world activity
The platform supported a Singapore interest community whose online activity was connected to recurring physical events. Editorial articles and categories provided a publishing layer. Member profiles held achievements and credentials, while event records captured the activity taking place in person.
Performances as structured records
A performance connected a participant, a piece and an event. The platform could associate a video recording with that performance and retrieve the context later. This made it possible to answer questions about participation across events, the pieces performed and accumulated performance time.
Those records also supported aggregate statistics and ranking views. The useful engineering work lay in modelling the relationships once and allowing different views to draw from them.
Media that remained connected
Event photographs could be associated with multiple members. Together with performance recordings, this enabled historical media to appear in the context of a member's activity. A gallery therefore formed part of a longer record of participation.
Publishing, transactions and discussion
The platform combined event publishing and ticket sales with e-commerce, threaded discussion and structured service information. Map-based location discovery provided another way to browse information. These capabilities supported different reasons to return to the same platform, from reading content to attending an event or exploring community history.
Capabilities
- Editorial articles, categories and structured browsing.
- Member profiles with achievements and credentials.
- Event and performance records linked to participants and pieces.
- Video links, event galleries and photographs tagged with members.
- Ticket sales, e-commerce, threaded discussion and location-based discovery.
Outcomes
- Supported recurring live events and online community activity.
- Created structured histories of performances and participation.
- Connected event photographs and recordings to the people and activity they documented.
- Enabled ticketing, commerce and aggregate participation views within the platform.
Engineering considerations
- Model relationships between people, events, performances, pieces and media.
- Retrieve member histories from connected records rather than repeated page text.
- Use recorded participation data for aggregate statistics and ranking views.
Activity records
- Member
- Performance record
- Event
Performance context
- Piece
- Performance record
- Video recording
Photo history
- Event photographs
- Tagged members
- Member history