chore: migrate from MongoDB to Supabase/PostrgresSQL

[machuwey]

Explanation

Right now we use MongoDB to store offchain data, which isn´t an optional solution for the kind of product we are building, as we are handling finantial data a relational type database is more suitable.

Proposed solution

Use PostreSQL with a provider like Supabase which offers a nice freetier through a ORM like Prisma.

// TODO: explain futher

[aybanda]

Hey @machuwey , I see what you mean about the database situation! Moving from MongoDB to PostgreSQL makes a lot of sense, especially since project is dealing with financial data. PostgreSQL will give better data integrity and security.
Using a provider like Supabase is a great idea too! They offer a nice free tier as you mentioned, which can help project save costs while you get everything set up. Plus, integrating with an ORM like Prisma allows to interact with the database using a more intuitive API. It’ll help manage available data models and migrations without getting bogged down in raw SQL.

I’d be happy to take on this issue.

[Michaelkingsdev]

To migrate from MongoDB to Supabase/PostgreSQL, I will analyze the current MongoDB schema and design a relational database schema tailored for PostgreSQL, ensuring it aligns with financial data requirements. Using Supabase for hosting and Prisma as the ORM, I’ll implement the schema, migrate the existing data with necessary transformations, and refactor the application to utilize PostgreSQL. Thorough testing will ensure data accuracy, query performance, and application stability. This approach will enhance data integrity, scalability, and align with the product's long-term goals.

@machuwey , I will be glad if this issue is assigned to me. I am Fullstack developer. My ETA is 48hrs. Thanks

[Nityam573]

To migrate from MongoDB to Supabase/PostgreSQL, I will analyze the current MongoDB schema and design a relational database schema tailored for PostgreSQL, ensuring it aligns with financial data requirements.
@machuwey please assign this task to me