
💡 Project Overview
This project was commissioned by the Jeollanam-do Office of Education, aimed at creating an integrated platform for conducting and managing democracy-related surveys across schools.
The platform was developed and operated using Django as the backend framework.
Service Link: http://jndedu-school-democracy.kr/ (Hosting terminated)
🌟 Key Features
👩🏫 Users (Students, Parents, Faculty)
- Participate in customized surveys according to user type (student, parent, or faculty)
- Access announcements and download attachments from the resources section
- View educational resources related to school democracy
🧑💻 Administrators (School / Regional Office / Main Office)
- Role-based admin accounts with tiered access (school, regional office, headquarters)
- Create and manage announcements or resources with file uploads
- Real-time statistics by school, region, and education level
- Visualize and export statistics by question or category
⚙️ Tech Stack
- Language: Python 3.11.9
- Framework: Django
- Database: MySQL
- Server: Ubuntu + Nginx
- Deployment: Gunicorn, crontab (automatic reboot scheduling)
🧠 Key Learnings
- High-Traffic Management: Gained hands-on experience handling sudden traffic spikes in a live environment by optimizing Nginx and Gunicorn configurations.
- Database Optimization: Solved Django ORM N+1 query problems using
select_relatedandprefetch_related, and minimized DB load for complex queries withannotateandaggregate. - Server Operations: Learned to maintain stable Ubuntu-based servers using scheduled crontab tasks for automatic reboots and monitoring.