Upgrade of the IOBEYA administration portal

Challenges :

• Adapting to an iObeya server that does not support Docker, requiring creative solutions for integration.
• Deep understanding of iObeya's database architecture and necessary permissions.
• Modifying existing queries without altering code logic to ensure stability.
• Identifying areas for improvement without disrupting the overall system architecture.

Solutions :

• Deploying containerized solutions to work around initial server limitations.
• Conducting detailed analysis and documentation of the database architecture for precise modifications.
• Reviewing and optimizing SQL queries to enhance performance.
• Implementing clear and straightforward conditions in user sorting for better management.

Results :

• An iObeya portal compliant with client specifications and security constraints.
• Significant optimization of SQL queries, improving portal efficiency and speed.
• Docker images ready for deployment, facilitating management and maintenance.

Client Benefits :

• Enhanced data privacy for users and administrators involved.
• Ease of deployment and portal sharing through containerization and GitLab usage.
• Improved user experience due to optimized performance and simplified management.

Innovative Aspects :

• Altering SQL queries without affecting code logic, ensuring maximum integrity.
• Utilizing clear conditions in user sorting to enhance efficiency and data management.

Tasks :

• Provisioning a VM for portal hosting.
• Retrieving code from GitLab and setting up a development environment.
• Launching the iObeya portal Docker image for testing and modifications.
• Deep understanding of existing code and SQL query modification for optimization.
• Pushing modifications to GitLab repository for version control.
• Creating the final Docker build and image for production deployment.