GDSC Unified App V2

Don't work on the main database sheet.

• Ensure to make GDSC account the owner for all assets, documents, designs, etc. Use your personal accounts for accessing
• Feel free to create a copy of everything to your personal account for your future reference
• Don’t use any LLMs¹ for anything!
• This is a self-learning exercise.
  • Don't ask Anurag or Thahir for how to do things. Feel free to ask others. If Thahir finds out Anurag was asked for help, he will be very disappointed.
  • You may ask Anurag or Thahir sparingly, only for doubts regarding the instructions in this document.
  • Remember, how you implement is your freedom. Thahir has only specified the requirements and has given proposed tools.

Documentation

Everything must be documented as simple and precise as possible, in their own files (already created). Write everything in your own words. Do not use LLMs¹ for this.

Text must be in markdown format; Diagrams must be in svg format

• ER Diagram of database
• Notes for technologies used as mentioned
  • Simplified explanation for each library. Its use-cases, advantages, disadvantages.
  • Why tool used
  • Why tool not used. Feel free to document other tools if you come across something better/worse
• Explanation of features
• Reason for method of implementations
• References used
  • Use Reference Manager
  • Use Footnotes like how used here for LLMs¹

Requirements

Database Features

• 3NF Normalization
• Minimal Tables
• High Performance

App Features

• User Authentication
• User Privilege
• GSheets Connectivity
• Appropriate Caching
• Optimized dataframe operations
• Interactive Graphs
• High Performance
• ML Not for now, since not enough data.
• Hosted online, preferably on streamlit share.

Proposed Tools

Ensure to stick to only open-source tools (GSheets is the only exception).

Purpose	Tool to Use	Tool to Not Use
Database	GSheets	SQL
App	Streamsync	Streamlit Dash
Dataframe	Polars	Pandas DuckDB SQLite Modin Koalas Dask Ray
Data Visualization	Plotly	Matplotlib Seaborn Altair Plotnine HVPlot Bokeh
Diagramming	Draw.io	Canva
Reference Manager	Zotero	Mendeley

Reference App

App V1 by Ahmed Thahir

Footnotes

1. Large Language Models ↩ ↩² ↩³