LSERSA website booking system
Posted on 09 July, 2023
I posted a couple of months ago about the LSERSA website and a booking system for their weekly training sessions that I was working on.
It's taken a little longer than I'd hoped, but pleased to say that the booking element is now up and running. It's quite a lot more complicated (dare I say sophisticated?) than the similar system that I previously wrote for the Bowles Ski Racing Club ...
Needlessly complicated, or simply sophisticated?
Key features that this new system includes:
- admin review for new accounts, and for racers being added to an account
- admin control over adding training sessions and the number of spaces available
- automated emails for account creation / admin review
- bulk emailing to all accounts
- booking (obviously) and payments (via Stripe)
The whole site uses the Gatsby static site generator, is deployed to Netlify, and uses a PlanetScale database. The usage should be comfortably within the free (or "hobby") plans for both Netlify and PlanetScale, so the system is effectively free to run.
Update, March 2024: PlanetScale have closed their free tier offering; we've now switched the database to Supabase — they still offer a free tier, but more importantly their paid tiers are much more affordable.
If any sports club/society wants a similar system — for a modest setup fee — please get in touch.
