ABRIL — Survey Platform for Social Research (IESA-CSIC)
Antonio Pulido Fernández
Published
0
Built from scratch in pure PHP (no framework) and MySQL for IESA-CSIC (Spanish National Research Council), ABRIL is a complete survey lifecycle platform: design, participant management, staggered distribution, response collection, data cross-referencing and dataset export for social research.
Architecture:
- Custom Front Controller pattern, PDO, OOP
- 9 question types with conditional-jump logic
- Hybrid JSON + MySQL storage, with independent databases per survey
- Full mailing module with scheduled reminders and automatic open/close by date
Access & administration:
- Multi-level permission system (view/edit/owner per survey)
- OAuth access for participants, dual session management
- Admin panel for multi-survey management, results visualization and dataset export for research use
Infrastructure:
- CI/CD via GitHub Actions with deployment webhook
- Two production servers (CSIC internal infrastructure + Hostalia)
- Load testing with k6
Scale: 17,000+ users in production. Active contract — one of my main ongoing projects.
Stack: PHP (vanilla) · MySQL · GitHub Actions · k6