
SQLift
A full-stack workout tracker built around a relational database. You plan workouts, log live sessions set by set, track body measurements and progress over time, and compete on global and friends-only leaderboards.
Description
SQLift is a full-stack workout tracker we built for CS-5200 Database Management. You plan workouts from a library of 1000+ exercises, log each set's weight and reps during a live session, and look back at your progress through graphs and personal records. You can also add friends, compete on global and friends-only leaderboards ranked by total workout volume, and earn achievements for hitting fitness milestones.
Media
The landing page.
Features
Live Session Tracking
During a workout you log each set as you go, with the weight, reps, RPE, rest time and set type (warm-up, working or drop). Each new set auto-fills from the one before it to save typing.
Exercise Library
The library has 1000+ exercises pulled from the Wger API, each tagged with the muscle groups it works and the equipment it needs, and you can filter and browse it by category.
Progress Analytics
The stats page charts your progress on each exercise over a time range you choose, tracks body measurements, breaks down volume by muscle group, and shows headline numbers like total volume, heaviest set and session streaks.
Social & Leaderboards
You can send and manage friend requests, choose how much your friends can see, and compete on a global or friends-only leaderboard ranked by total workout volume.
Achievements & Goals
Achievements award badges for fitness milestones, and goals let you set a personal target with a completion date and track it over time.
Key Responsibilities
- Designed the relational database schema, including the multi-level hierarchy from sessions down to individual set records, the friendship graph, and the achievements and goals tables.
- Built and maintained the Flask API modules for workout CRUD, live session tracking, analytics, leaderboard calculations and achievements.
- Wrote the Python web scraper that filled the exercise library with 1000+ entries, muscle group mappings and equipment data from the Wger API.
- Implemented session-based authentication with bcrypt password hashing and worked on the profile and friend management endpoints.
- Worked on the React front end, including the live session page, stats visualizations and leaderboard views.
- Set up the GitHub Actions CI/CD pipeline that deploys to Vercel and runs smoke tests against the live backend.
Additional Information
- This was our final project for CS-5200 Database Management Systems at Northeastern University, so most of the effort went into relational database design and complex SQL queries.
- The schema has 15+ tables covering users, workouts, sessions, set logs, exercises, muscle groups, equipment, measurements, friendships, goals and achievements.
- The backend connects through Supabase's transaction pooler on port 6543, which lets the stateless Vercel serverless functions talk to PostgreSQL without running out of connections.
- My scraper filled the exercise library by paging through the open-source Wger fitness API and normalizing what came back.
- We also planned separate user roles for trainers, more achievements and profile picture uploads, but ran out of time.
- I built it with Ben O'Neil and Sudaiv Shetty, and we worked on feature branches in Git.
