Multisite Media Database Development

Job ID: 38938088

Budget: $750 – $1,500 USD

Project Overview
We are seeking a freelancer to develop a multisite database system that will allow various websites (domains) to share media files (images, videos, documents, etc.) efficiently. The goal is to have a centralized database where media files are uploaded once but can be accessed and utilized by multiple websites. Each domain should be able to retrieve and display the media files relevant to its content while maintaining separate access control and user interfaces. If a custom post is deleted, it deletes the custom post and attached media from ALL sites.

Key Requirements

Multisite Database Structure:

*Create a centralized database that can support multiple domains/websites.
*Media files uploaded by any user or admin should be accessible to multiple domains, but each domain will only see files associated with its own content.
*The system must handle large media files efficiently and support scalable storage solutions.

Media File Management:

*Ability to upload, categorize, tag, and organize media files (images, videos, audio files, documents, etc.).
*Support for metadata (e.g., file name, type, size, and custom tags) associated with each file.
*Implement a file versioning system to track changes to files.

Access Control & Permissions:

*Each domain should have access to a specific set of files based on pre-defined rules (e.g., shared files, user-specific files, domain-specific files).
*Different access levels (admin, user, guest) with the ability to control file uploads, deletions, and downloads.
*Permissions should be customizable for each domain, user, or group.

Cross-Domain Integration:

*Media files should be accessed by different websites (domains) via secure API calls or direct file referencing.
*A consistent way to reference and serve media files from a single point (URL, API, or file server).
*Ensure file referencing is secure and doesn’t expose sensitive data or allow unauthorized access.

User Interface & API:

*Develop an easy-to-use admin interface for managing media files, users, and permissions.
*Data should be served with an API to integrate with the media database.
*Ensure the API allows for file uploading, searching, and retrieving media files securely.

Performance & Scalability:

***Current site to replicate database - arrestlistings.com
***Custom post that will be the same in data. - arrestlistings.com/mugshots/
*The system should be able to handle a growing amount of media and traffic from multiple domains without significant performance loss.
*Each domain will have a single page that has a different design.
*Optimize the database and file storage solutions to handle large amounts of media data efficiently.
*Backend - Laravel or NodeJS
Frontend - ReactJS

Security:

*Implement proper encryption for sensitive media and data.
*Ensure secure API calls and file transfer protocols (e.g., HTTPS, OAuth, etc.).
*Provide logging and monitoring tools to track file uploads, accesses, and deletions.

Hosting & Deployment:

*Recommend hosting solutions for the database and media storage - Hostinger VPS Server.
*Deploy the database and ensure it is optimized for production environments.
*Provide documentation for deployment and maintenance.

Deliverables

*A centralized, multisite database that supports media file sharing across various domains.
*User-friendly admin panel for managing files and permissions.
*Secure API for media file access and management.
*Clear documentation for system setup, usage, and maintenance.
*A report detailing performance considerations and scalability strategies.

Timeline (estimates)
Initial Planning and Design: 1 day
Database and Backend Development: 1 weeks
Frontend/Admin Panel and API: 1 weeks
Testing & Debugging: 2 days
Final Deployment: 2 days
Estimated Total Duration: 3 weeks

Skills Required
Database Design and Management (SQL, NoSQL, etc)
API Development (RESTful APIs)
Backend Development (NodeJS)
Frontend Development (ReactJS)
Cloud Services (Hostinger VPS)
Media File Handling and Storage Solutions (e.g., S3, CDN integration)
Security Best Practices for Web Applications

Budget
Please provide an estimated cost for the entire project based on your experience and expertise.

Application Instructions
Share your portfolio or examples of previous similar projects.
Include your approach to handling multisite environments and media file management.
Provide a rough timeline and breakdown of milestones.