A full-stack web application built with Flask and SQLite, featuring a secure Admin Portal for data management and a real-time User Portal for data visualization.
- Live Website: https://kaemonng.pythonanywhere.com
- GitHub Repository: https://github.com/Kaemon/alphv-tech-assessment
I have pre-configured an Admin account on the live demo for your convenience. Please use these credentials to access Add/Edit/Delete features immediately:
- Email:
admin@alphv.com - Password:
123456
Note: You can also register a new account, but it will be assigned standard User privileges (View Only).
-
Admin Portal (Secure):
- Authentication system with password hashing.
- First user (
ID=1) is automatically granted Super Admin privileges. - Full CRUD functionality (Create, Read, Update, Delete) for data entries.
-
User Portal (Real-time):
- Public dashboard displaying Timestamp, Name, Shape, and Color.
- Real-time Updates: The grid updates automatically every 3 seconds without refreshing the page (implemented via JavaScript polling).
-
REST API:
- Dedicated endpoint
/api/dataserving JSON data to support the frontend grid.
- Dedicated endpoint
- Backend: Python 3.10, Flask, SQLAlchemy, Flask-Login
- Frontend: HTML5, Bootstrap 5, JavaScript (Fetch API)
- Database: SQLite
- Deployment: PythonAnywhere
If you prefer to examine the code locally:
- Clone the repository
git clone [https://github.com/Kaemon/alphv-tech-assessment.git](https://github.com/Kaemon/alphv-tech-assessment.git) cd alphv-tech-assessment - Install Dependencies
pip install -r requirements.txt
- Run the Application
python app.py
- Access the App Open browser at: http://127.0.0.1:5000