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