Video Sharing Web Application
YouTube inspired web application built on the LAMP stack.
The application allows users to upload, view, and share videos. Users can create accounts, upload videos, like and comment on videos, and subscribe to other users. The application also includes a search feature that allows users to search for videos by title, description, or tags.
The LAMP stack was used to build the application. The front-end was built using HTML, CSS, and JavaScript. The back-end was built using PHP and MySQL. The application was hosted on a Linux web server hosted on Google Cloud. NetBeans IDE was used for development, connected to the server via SFTP. MySQL Workbench was used to manage the database.
The first step was to design the database schema. The tables were normalized to reduce redundancy and improve data integrity. One important aspect of the database design was to ensure that the relationships between the tables were properly defined and enforced using foreign key constraints. We decided to store thumbnails as BLOBs on the database, while video files were uploaded to the server's file system and store the file path in the database.
Next the backend API was implemented using PHP. The API was designed to be RESTful and followed best practices for API design. As we were implementing the frontend, the web application was ensured to be responsive on mobile as well.