2026 · Backend, security, deployment
School Council Elections
A Flask and SQLite voting system for Saini International School, with ID and date-of-birth authentication, rate limiting and a password protected admin dashboard.
- Flask
- SQLite
- Rate limiting
- Python

A closer look
School Council Elections
Commits in the last year
58
Language bytes
- HTML82k
- Python82k
- CSS24k
- JavaScript4k
- Shell1k
- Procfile0k
The problem
Student council elections were running on paper ballots and goodwill. Counting took an evening, the results could not be checked afterwards, and nobody could say who had voted.
What I built
- 01
Voters authenticate against a JSON roll of student IDs, dates of birth and houses, so a ballot cannot be cast on a guess.
- 02
Flask-Limiter rate limits submissions per voter, which is what stops one person from filling the box.
- 03
Votes, candidates and posts live in SQLite, including the live election state, so a restart mid-poll does not lose the count.
- 04
A separate admin console handles candidate linkage and result reporting behind its own password.
- 05
Setup is a single script that installs the requirements and starts the server, and the server runs on PythonAnywhere.
What it changed
One shared source of truth for who voted and for what.
A count that survives a server restart and can be audited afterwards.
Built on faculty request and used for the actual school election.