CET Stats!

Credits

Developers

Tech Stack

Backend:

Primary Language: Python
DataBase used: MySQL (main backend storage) & SQLite (for demo frontend website)
Libraries Used (other than the standard libraries):
- dotenv: For storing environment variables
- beatuifulsoup4: For scraping the college information such as address from the official website
- pyMySQL: For MySQL database connection in Python
- openpyxl: For opening Excel files in Python
- xlsxwriter: For creating and writing Excel files in Python
- PyMuPDF: For opening and parsing the cutoff PDFs
- pdfplumber: For opening and parsing the 'All India Seats' cutoff PDFs
- thefuzz: For fuzzy string matching in Python

Frontend:

Web Framework: Python(Flask) + HTML, CSS, JavaScript
Templating Engine: Jinja2
Libraries Used (other than the standard libraries):
- dotenv: For storing environment variables
- pyMySQL: For MySQL database connection in Python
- html-sanitizer: For cleaning up the user inputs received in the forms for more security
Art, Images and other JS libraries:
- Flaticon uicons: For cool icons, used throughout the website
- Google Fonts: For the 'Poppins' and 'Comfortaa' fonts used by the website
- Choices.js: For the functional multi-select dropdowns
- jsPDF + jsPDF-AutoTable: For converting HTML tables to PDFs

Frontend Hosted On: Vercel