[Tutor] Create a database from api requests

[Joao Carlos Silva de Oliveira Matos]

Thanks a lot. Your answers were much more enlightening than I expected. I
have already written everything down and will start my studies in SQLite
right away.

Em dom., 16 de mai. de 2021 às 17:06, Dennis Lee Bieber <
wlfraed at ix.netcom.com> escreveu:

> On Sun, 16 May 2021 13:12:53 -0400, Dennis Lee Bieber
> <wlfraed at ix.netcom.com> declaimed the following:
>
> >On Sat, 15 May 2021 14:58:04 -0300, Joao Carlos Silva de Oliveira Matos
> via
> >Tutor <tutor at python.org> declaimed the following:
> >
> >>My friends and I play tournaments every week and we decided to create a
> >>league with the sum of points from each weekly tournament. The results
> can
> >>be accessed via API Rest. The API response is a nested JSON file.
> >>I started to run the code on the first of May, using a filter to only get
> >>results from that day on. But I am realizing that the code is taking more
> >>and more time to load since the amount of data only increases.
> >
> >       You are going to have that problem with any form you change to --
> even
> >a server-side database is going to return lots of data as the database
> >grows in size.
> >
>
>         Or did you mean to imply that you are just accessing someone else's
> web-application (your initial paragraph doesn't give any information about
> how these "tournaments" are tracked and updated).
>
>         In that case, yes... a LOCAL SQLite3 database with an update pass
> fetching only data since the last run would be feasible instead of fetching
> everything from the start of the history...
>
>
> --
>         Wulfraed                 Dennis Lee Bieber         AF6VN
>         wlfraed at ix.netcom.com
> http://wlfraed.microdiversity.freeddns.org/
>
> _______________________________________________
> Tutor maillist  -  Tutor at python.org
> To unsubscribe or change subscription options:
> https://mail.python.org/mailman/listinfo/tutor
>


-- 

João Carlos Silva de Oliveira Matos
Bolsista de Inovação e Tecnologia
PROFNIT - Centro das Humanidades - UFOB
Mat. 2020100150