The mysql data is not tested with the application on the internal server, and hence, we need to launch the MySQL and test the integrations required

Also, the current strapi structure in the faculty content type Scopus link has an issue with the URL length. The URL is bigger than the strapi's short text field size, so we will need to use the long text field.

This thing should be updated in the CMS repository.

The current procedure known is:

• export the .env file in the created project that contains the API keys
• use strapi import in the existing project and use strapi export in the new project

These steps will help in deploying the strapi in the college servers.

To Explore

• explore MySQL and PostgreSQL integrations with strapi
• explore how to export existing sqlite data and import it in MySQL database with strapi

Deliverables

• small report on MySQL and PostgreSQL usage with strapi
• how to guide about the import and export between sqlite and MySQL or PostgreSQL

Strapi provides a media library with features like thumbnailing images and storing files as objects.

But without any provider, the files are stored in the code at public/uploads. But this is not desirable as the code size will keep increasing, and the files are directly stored in a file system.

Strapi has good integration with cloud providers like AWS, Azure, and Google Firebase, but this may not be desirable as we want the content to be on-premises.

An alternative is for us to host the object storage by ourselves. One such provider is MinIO.
But there are no plugins/providers available in the marketplace for usage.

Here is a blog about how we can configure it: https://krisadas.medium.com/use-minio-object-storage-in-strapi-dfe37b54e42e

The task is to check whether it will work according to this blog.

In future, we can create our provider in strapi, which will be a separate project.

• The student information needs to be updated with the latest students in the school.
• The research papers professors publish should be linked to the category.
• The Faculty information should be updated with all the faculty information