Set up sqlite database - Githubissues

lee-vivian / api-football

(UI rewrite in progress) A simple web app that consumes the api-football API to display data on standings and upcoming matches for specified soccer leagues

MIT License

0 stars 0 forks source link

Set up sqlite database #2

Open lee-vivian opened 4 months ago

lee-vivian commented 4 months ago

Set up a sqlite database with the following tables:

[ ] user (id, first name, last name, username)
[ ] fixtures (year, league, homeTeam, awayTeam, match time, location, result)
[ ] standings (year, league, rank, team, MP, W, L, D, GD)

lee-vivian commented 1 month ago

Also want to store daily pull of data from api-football server to minimize number of requests sent (daily limit on free tier)