Fullstack Personal Finance App|Oauth|Next14|Fastapi|ORM+RAW SQL

What are you most proud of, and what would you do differently next time?

I picked up a lot of techniques building this app. I was using react context until a fellow dev opened my mind to many techniques for state management without need for overhead costly tools. I also enhanced my sql skills and techniques.

What challenges did you encounter, and how did you overcome them?

I built two backends for this app. One with node/express(Js) and the other with Fastapi(Python). I used raw sql for all the database queries in the fastapi version with psycopg2 then used prisma's queryRaw method for some endpoints in the node version.

The challenge is deciding which orm to use which made me realize that orms are mental drains since they all individually have very distinct syntaxes so I picked Prisma for making database migration and introspecting as easy as

prisma db push for migration

and

prisma db pull for introspecting

No more worries about ORMs when I'm confident with writing raw queries that are SQL injection proof. Plus raw sqls are more performant and can achieve a lot in one query than orms can. Picked up 4 different ORMs and decided never again lol...

What specific areas of your project would you like help with?

***Update. I used docker, ecr and lambda and got the fastapi version of my backend working awesome! check it out on my github ifaronti/finance-backend-fastapi. There's link to the interactive swagger UI docs so you can signup, then use the details to checkout the protected routes.