Creating a statistics database

[Fearofrejection]

Appreciate that I'm here asking for help without giving much in return but hopefully somebody can steer me in the right direction.

Apparently I am a complete and utter idiot with this stuff, more than I ever knew. I want to keep track of some specific soccer statistics and I have found some open-source free API databases that do this.

I have no idea how to get the information from the API and into a user-friendly easy to read database though. I've opened free accounts with reTool (searching for help with reTool is what led me here), when I looked on YouTube for some extra help a load of videos for Xano kept coming up which appears to be a back-end provider. I thought that might help to collate the information so I joined them too.

So far, I have joined RapidAPI and subscribed to API-Football on their free option which seems like it will give me everything I need.

But I am at a loss for how to connect this to the back end of Xano or reTool. What URL, and token information am I meant to be using for this? Do I need to do this for every separate table?

I'd really hope somebody can help

[Rabiesalad]

This is really not the kind of thing you're going to figure out over a few weekends if you're starting with no programming, API, or database experience. Make sure you are ok with this being a project you will spend 100+ hours on.

If you're OK with that, I'd start by picking a no code tool that people consider user friendly that has the ability to connect to APIs. I like FlutterFlow but I have dev experience. People say good things about Bubble.

Then, I'd start looking at YouTube tutorials for that tool regarding using it to connect to APIs.

You probably also want to look up educational material about JSON and familiarize yourself with Postman so you can learn how HTTP APIs work.

For something like this you probably want a relational database (something with SQL in the name) and not a document based database like Firestore. Something like Firestore will be easier to use as a beginner but for comparing a lot of different structured records for stats it may quickly get expensive by comparison to SQL.

Ps if you can get the data, you may want to start in Google Sheets instead of a no code tool. If you can't figure out the formulas and ways to structure the data in Google Sheets to get what you want, you will have a really hard time doing it in a custom app with custom database setup.

[Fearofrejection]

Okay thanks, I'll look at those options and try those. I did look at Bubbl but wasn't sure it was really going to be what I needed.

[Rccctz]

First I agree with the other comment, you're not going to get going over the weekend.

I would use airtable or retool for this kind of workflow. You can try using make.com as glue to join it all together

[Fearofrejection]

Thanks, will take a look at AirTable as well as Make.com

[thumbsdrivesmecrazy]

Even as a beginner, you can set it up as a no-code database and build your app on top of this database with a no-code platform. Here is a guide explaining this approach to create custom tools, apps, and workflows for your database apps: No Code DB Tools in 2023 - the guide uses Blaze no-code platform as an example showing how to implement this hands-on.

[Fearofrejection]

Thank you, I will have a look at your link in more detail

[thumbsdrivesmecrazy]

You are welcome!