Skip to content
All work

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.

A closer look

School Council Elections

A real election system, run for real students

Repository

school_votingMAIN

pushed 13 May 2026

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

  1. 01

    Voters authenticate against a JSON roll of student IDs, dates of birth and houses, so a ballot cannot be cast on a guess.

  2. 02

    Flask-Limiter rate limits submissions per voter, which is what stops one person from filling the box.

  3. 03

    Votes, candidates and posts live in SQLite, including the live election state, so a restart mid-poll does not lose the count.

  4. 04

    A separate admin console handles candidate linkage and result reporting behind its own password.

  5. 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.