Task 2

Normal Mode

AlphaQ wants to shift operations to the new headquarters. But manually shifting operations is a very difficult task. Your manager Sakthi wants you to automate this shifting process with Docker.

• You need to dockerise the server setup done in task 1.
• Using an appropriate base image (eg. Ubuntu), copy all the scripts to the appropriate locations and run them accordingly.

Superuser Mode

• Create a database to store MoMs instead of files in the users' directory. Use only MySQL or PostgreSQL. SQLite is not allowed.
• You may use any programming language to do the above. Use raw SQL queries to do this, do not use ORMs (eg. SQLAlchemy).
• Dockerise the database along with the normal mode. Use docker-compose.
• Make sure restarting the docker container does not destroy the data.
• Add PHPMyAdmin service for viewing the database.
• Create an account with read-only permissions to read the MOMs present in the DB.

Deadline

26th June 2021 | 11.59 pm

NOTE: Normal mode is necessary to complete the task. Superuser mode is highly encouraged

Resources

1. Docker Docs
2. Docker Compose Docs
3. Docker Compose Docs - TutorialsPoint
4. YouTube Tutorial for Docker
5. YouTube Tutorial for Docker Compose
6. SQL Tutorial by W3Schools
7. MySQL Docs
8. PostgreSQL Docs
9. PostgreSQL online resources