moneyapp-api
MoneyApp API is a versatile data analytics backend designed for personal finance management applications. Built with TypeScript on the NestJS framework, it exposes a flexible GraphQL interface using Apollo Server, enabling efficient data interaction for front-end visualizations. The system utilizes Prisma ORM to manage data modeling and connects to a PostgreSQL database hosted on Supabase, migrating from an initial Notion API integration to overcome rate limits and ensure data consistency. Security is robust, employing Auth0 for identity management with a custom authentication guard that enforces role-based access control (RBAC) via JWT tokens. The API supports comprehensive financial queries, including filtering income and expenses by various fields, applying date-range filters, calculating totals and average daily metrics, and grouping data with zero-value date padding for accurate chart rendering. Infrastructure includes Heroku for API hosting and CircleCI for continuous integration and deployment. While c