Sayur Lokal - REST API for E-commerce
Developed the backend REST API for a local vegetable e-commerce platform. This project involved engineering the backend infrastructure which comprised 85% of the application's logic, including a complex multi-role authentication system, a scalable relational database design, and role-based access control to secure endpoints.
April 2025 - May 2025
Duration: 2 months
Client: RevoU Final Project
PythonFlaskSQLAlchemySupabasePostgreSQL
1 / 4
Fit
Background
This was the final capstone project for the RevoU Full-Stack Software Engineer program. The goal was to engineer the complete backend infrastructure for a functional e-commerce application, focusing on security, scalability, and core business logic that accounted for 85% of the application's functionality.
Strategy & Solution
- Utilize Supabase Auth for a secure and complete user authentication and access control system.
- Design a scalable relational database schema using SQLAlchemy ORM to manage users, products, orders, and transactions.
- Develop a custom Role-Based Access Control (RBAC) system with Flask decorators to secure API endpoints.
Responsibilities & Scope
- Implemented Supabase Auth for user authentication and access control.
- Designed a relational database schema for users, products, orders, and transactions.
- Developed core backend features including user registration, login, and a product listing API.
- Engineered a role-based access control (RBAC) system to restrict functionalities to authorized user roles.
Results & Impact
- Achieved a 100% login success rate for all user roles during testing.
- The database schema successfully supported 80% of core application features with only minor changes.
- Reached 90% backend-frontend integration success during demonstrations.