Sanitized case study
Personal Finance Application
Ongoing
Overview
A personal finance application for accounts, categories, transactions, and dashboard reporting.
The problem
Financial records needed a consistent relational structure and authenticated interface for day-to-day tracking.
My role
Full-Stack Developer
Responsibilities
- Built authentication, accounts, categories, transactions, API routes, and dashboard reporting.
- Designed the relational data structure for financial records.
Architecture or technical approach
- Next.js and TypeScript for the interface and API routes.
- Prisma with PostgreSQL for relational data access.
- Supabase for authentication and platform services.
Authentication and authorization
- Authentication protects each user's finance workspace.
- Application routes operate on authenticated financial data.
Data model or workflow
Set up accounts and categories, record transactions, then review dashboard reporting.
Key technical decisions
- Kept accounts, categories, and transactions as related domain records.
- Left React Native integration as a possible future phase, not a delivered feature.
Challenges
Keeping transaction data structured for useful reporting while the product remains in development.
Current status
Ongoing
Screenshots or diagrams
Additional screenshots and data diagrams will be added after the ongoing product reaches a review-ready state.
Technologies used
- Next.js
- TypeScript
- Prisma
- Supabase
- PostgreSQL