search

Academic-Panic / academic-panic-application

0 stars 1 forks source link

Design draft of database structure #7

Closed elwais closed 1 day ago

elwais commented 1 week ago

Courses, classes, and users have self-evident structures due to their fields-based construction. However, tracking "friends" per user is not as clear - since storing a list of friends per user violates first normal form.

Additionally, scalability of the application must be considered to avoid unexpected outages in case any of the technologies used in the stack crash unexpectedly.

After this research is conducted, documented, and reported to the team members, this issue will be closed.

elwais commented 1 day ago

I wound up searching for web applications on GitHub that implement some sort of similar social media functionality, and found mania, which implemented followers and following as an array of a Follow model. For now, we'll use this form of modeling, and can change out and optimize later if necessary.