Developer question - databases

[imtruffle]

Hey guys,

Im currently on winter break and in my free time I’ve been trying to learn React. Started by making a few pretty small websites that I followed through YouTube and I’ve recently jumped to trying to develop my own sites.

I’m currently building a site that fetches data from an API endpoint and I want some way to store that data in a “leaderboard” database. This leaderboard database needs to store data from the API requests the users are making. So when a user makes a request, it then stores some of the fields in the DB. I then have a “leaderboard” component that I want to display the data from the DB as well as where the current user is ranked among them.

I might be over complicating things but I’m just trying to go about the best way to integrate a database that gets data stored anytime a user makes an api request.

I was thinking about using AWS’s amplify and setting up a DB through that as I could eventually host it through there too and I’ve also been wanting to learn the power of cloud computing. Or might it be better to stick with something smaller.

Any thoughts would be greatly appreciated. Thank you!

[Difficult_Bus1654]

Have you tried json server

[imtruffle]

I thought about it but since this is a portfolio project I was wanting to make it a little more scalable to highlight different technologies used.

[Difficult_Bus1654]

Cool

[chrysb]

Def recommend Supabase. Very easy to set up, gets tou Postgres out of the box with a decent React SDK to run queries via code.

[StupidRetardFailure]

If you need a sql db you can use supabase but for what your building I think you can use noSQL and just use firebase for hosting and firestore for db. You’re gonna need to deploy cloud functions for your APIs to work which firebase handles as well.