StudentSpace

In this project, a social media application was developed specifically for high school students to help increase interactions between them. We focused on building a strong database that supports all the simple requirements that a basic social platform needs. In the end, we deployed the database to the cloud, so students could access the application everywhere with the most updated information.

Demo

Admin's pages

Screen.Recording.2023-05-01.at.17.32.27.AM.mp4

New user registration and login

Screen.Recording.2023-05-12.at.1.09.08.AM.mov

Add, edit, and delete posts

Screen.Recording.2023-05-12.at.1.09.08.AM.mov

Like and comment on posts

Screen.Recording.2023-05-12.at.1.11.07.AM.mov

Search for user's posts

Screen.Recording.2023-05-12.at.1.15.24.AM.mov

Run Database in Cloud

Create a synced PostgreSQL database on AWS Relational Database Service (RDS)

Dockerize PostgreSQL database and host on DigitalOcean

Screen.Recording.2023-05-12.at.1.38.21.AM.mov

Connect the application on IntelliJ IDE to the hosted cloud database

Screen.Recording.2023-05-12.at.1.40.37.AM.mov

Features

• Registration and login.
• Create posts online.
• Like and comment on posts.
• Search for user's posts.
• Follow other users (students).
• Admin has control over deleting inappropriate posts or users.

Framework and Technologies

• Spring Boot
• Java, HTML5, CSS3
• PostgreSQL
• AWS Relational Database Service
• DigitalOcean Cloud
• Docker

Entities/Tables in database

• USERS
• FOLLOWERS
• POSTS
• POST_LIKES
• POST_COMMENTS

Entity Relationship Diagram (ERD)

For more information, please take a look at the report uploaded on Google Drive with the link embedded in the About section of this GitHub page.