Car Expense Calculator
Full-Stack Vehicle Expense Tracker & Fleet Analytics
Full-stack vehicle expense tracking and calculation platform built as the Technion full-stack course final project, featuring Next.js 13, Express, Sequelize, MSSQL, and CapRover.
TECHNOLOGY STACK & ARCHITECTURAL RUNTIME
Architectural Dossier
Car Expense Calculator (GitHub Repository) is a full-stack vehicle-expense tracking and calculation web application built as the capstone project for Dmitry’s 300-hour Full-Stack Development certification at the Technion – Israel Institute of Technology (External Studies).
The Engineering Challenge
Vehicle ownership and fleet management involve disparate expense streams: fuel logs, scheduled maintenance, insurance premiums, road tolls, and unforeseen repairs. The project required creating an end-to-end, multi-user system capable of tracking, categorizing, and analyzing historical vehicle expenditures with strict data integrity, secure authentication, and responsive data tables.
System Architecture & Technical Stack
-
Frontend Application:
- Engineered with Next.js 13 and React 18 using TypeScript for end-to-end type safety.
- Styled with Mantine UI components, providing a clean, accessible design system.
- Data table visualization powered by TanStack Table, enabling client-side sorting, pagination, and multi-field filtering over complex expense ledgers.
- Integrated Framer Motion for smooth interface transitions and Progressive Web App (PWA) capabilities for mobile home-screen installation.
-
Backend API & Data Persistence:
- Standalone Express.js REST API structured in TypeScript.
- Persistence handled through Microsoft SQL Server (MSSQL) via Sequelize ORM, modeling relational schemas for users, vehicles, service categories, and transaction logs.
- Security architecture implemented with stateless JWT (JSON Web Tokens) and bcrypt salted password hashing.
-
Containerization & Deployment:
- Fully containerized via Docker with multi-stage builds.
- Deployed to a self-hosted cloud instance orchestrated through CapRover PaaS, incorporating automated build triggers, reverse proxy SSL termination, and environment variable management.
The repository stands as an archived milestone demonstrating rigorous full-stack development, database schema modeling, and production cloud containerization.