User Tools

No More Spreadsheets! Building PyLadiesCon Infrastructure with Python and Django

  • Speaker: Mariatta Wijaya
  • Room: CC 235
  • Time: Sun 3:00 pm – 3:30 pm
  • Format: Lecture (30 Min + Q&A)
  • Difficulty: Introductory
  • Track: Development & Dev Tools
  • Additional Tags: DevOps, Sustainability & Funding, Self-Hosting
  • Presenter Location: In-person
  • Experience: umpteenth time speaking
  • At: anywhere

Description:

PyLadiesCon is a global, 24‑hour online conference run entirely by volunteers — and for years, nearly every part of it was managed through spreadsheets. Volunteer sign‑ups, scheduling, sponsorships, logistics… if you needed information, there was a spreadsheet for it. While spreadsheets are great for capturing data, they quickly became a source of confusion, version drift, and collaboration headaches across a distributed volunteer team.

In 2025, the PyLadiesCon organizers decided it was time for a change. This talk shares how the team began building an open‑source conference infrastructure using Python and Django, replacing a maze of spreadsheets with a unified, maintainable web application.

Mariatta will discuss:

  • The unique challenges of running a multilingual, 24‑hour global conference
  • Why spreadsheets became a bottleneck for collaboration
  • How the team designed and built a Django‑based system to manage volunteers, scheduling, sponsorships, and more
  • Lessons learned from building infrastructure as a volunteer‑run open‑source project
  • How you can contribute and support the PyLadies community

Attendees will gain insight into the realities of running a global online conference and how open‑source tools can transform volunteer workflows.

Target Audience:

  • Community organizers
  • Python and Django developers
  • Open‑source contributors
  • Anyone interested in building infrastructure for large volunteer‑run events