ABRIL — Survey Platform for Social Research (IESA-CSIC)

Antonio Pulido Fernández
Published

0
  • Project creator

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