search

Betarena / scores

We are building the first open-source live results and statistics platform with community involvement features for data insertion. The project includes a blockchain component that will allow participants to receive rewards based on their participation and also to stake the future Token of the platform.
GNU General Public License v3.0
18 stars 6 forks source link

New DB on a new Coud Server for volume information #90

Closed jonsnowpt closed 1 year ago

jonsnowpt commented 2 years ago

Since we are getting historic information about all football fixtures we need to have a dedicated database to store this information to avoid cluttering the main DBs.

Steps:

1. Get all fixtures information available from all available dates, this will be the first push for historic purposes.

Get information from the provider endpoint:

https://soccer.sportmonks.com/api/v2.0/fixtures/between/:STARTDATE/:ENDATE?include=localTeam,visitorTeam,substitutions,goals,cards,other events,corners,lineup,bench,sidelined,comments,tvstations,highlights,round,stage,referee,venue,localCoach,visitorCoach,group,trends,firstAssistant,secondAssistant,fourthOfficial,stats,shootout,league,stats,probability,valuebet,news

For the first push use January 2005 to the current date.

Populate the Hasura DB.

fixtures

Columns:

id data

Update frequency:

First data collection only one push

2. Update fixtures endpoint.

Get information from the provider endpoint:

https://soccer.sportmonks.com/api/v2.0/fixtures/updates?include=localTeam,visitorTeam,substitutions,goals,cards,other events,corners,lineup,bench,sidelined,comments,tvstations,highlights,round,stage,referee,venue,localCoach,visitorCoach,group,trends,firstAssistant,secondAssistant,fourthOfficial,stats,shootout,league,stats,probability,valuebet,news

This endpoing will update the information present in the fixtures hasura endpoint.

Update frequency:

Update every 90 minutes.

jonsnowpt commented 1 year ago

We have followed a different approach.