I build simple and dynamic database-driven web sites using Oracle Application Express (Apex).
Here are a few of them:
2015: Volunteer Australia!
A site that allows volunteers to register for events. Used by the City of South Perth to take registrations for the Australia Day Celebration Zone in January 2015.
“The online registration system worked very well – no major issues – and the data that I needed was perfect!” – Latesha Houston, City of South Perth
GamesFest is a unique registration and management system for multi-sport events. Many applications in one, built originally for State Youth Games, it successfully accepted registrations from over 930 players for SYG 2013, and a copy of the application for Masters Games later that year was also successful.
It includes the following features:
- Allows players to register themselves for a team and get their sport allocations
- Integrates with payment gateways to allow players to pay their fees online
- Allows team coordinators to register their team, set their fees and options, and manage their players
- Allows team coordinators to manage their team, assigning players to their preferred sports
- Allows volunteers to sign up and select their preferred events and jobs
- Allows central scorers to enter and publish the event scores and leaderboards
- Provides the event director and coordinators with detailed real-time reporting
- Automatically presents a “Mobile” style interface for mobile devices
- Detailed financial position for team coordinators and event director
- Custom info pages for each competition
- Bulk messaging – send quick alerts by email and/or SMS to all members of a team or the whole competition
In 2014 the site was further improved and expanded for use by multiple separate but concurrent clients – serving State Youth Games, Masters Games, GI Games, Goldfields Youth Games, and SportsFest (Note: links may not always be available depending on client requirements). The site is now capable of catering to any number of different organisations and competitions and may be used by similar multi-sport event organisers throughout Australia.
“Thanks for all you do. It’s having a huge impact on our churches through these sports events we run.” – Cam Barnes, State Youth Games WA
2012: My Home Contents
My Home Contents (AU) was launched in early 2012 (in a blaze of very little publicity) to help people keep track of their special home contents and their book, CD, and DVD libraries. It allows them to enter the ISBN of a book, which in many cases will automatically load the details of the book and a cover image. It is useful for keeping track of the warranty details for significant purchases.
The site runs 24×7 on Amazon’s Elastic Compute Cloud (EC2) with user-uploaded content stored on Amazon’s Simple Storage Service (S3).
This web site was designed for Foothills Church of Christ primarily as a source of information for visitors to the church; and secondarily as a launching point for members to access a number of other tools and resources. The front page features all the information needed for a visitor who just wants to know “when” and “where”.
The site runs 24×7 on Amazon’s Elastic Compute Cloud (EC2) with images and mp3 resources served from Amazon’s Simple Storage Service (S3).
2010-2012: Hills Team
The Hills Team needed a simple site to take team member registrations for the annual State Youth Games (SYG). This site, updated in 2011 and 2012 (superseded by the new State Youth Games site in 2013), allowed young people to easily sign up using an email address or mobile phone number, pick their preferred events, and are kept up-to-date about their assigned events and teams.
Behind the site is a comprehensive team management system, including a preference management tool that allows the team organizers to find an optimal assignment of participants to their preferred sports, with the (often competing) goals of minimizing disappointment, adhering to the SYG rules and guidelines, and responding quickly to late additions, cancellations and event changes. While the site doesn’t help the team win the event, it certainly takes a lot of pain out of coordinating the team.
The site used a custom authentication scheme which allowed players to sign up without having to log in straight away. About half of the team registrations in any year are from new players who are unfamiliar with the system, so as much of the friction in getting through the registration steps was removed. For example, login details (so the player can get back into the system later on, while protecting their privacy) are created automatically and sent to the player by email or SMS. The initial registration only asked for the bare minimum of details that are required; further details is gathered later. Also, some players are more concerned about playing sport than sitting down at a computer to sign up, so they’ll ask their partners or siblings to sign up for them; so the site was designed to cater for people signing up multiple players.
If you need a custom database-driven web site, and think Apex may be suitable as a platform, feel free to contact Jeff on firstname.lastname@example.org to discuss your requirements.