Ergast Developer API

254 Responses to “Feedback”

1. Miguel Bento says:

   4 September 2019 at 14:55

   I think the second update statement was truncated. Here goes both statements again:

   update results
   set (fastestLap,fastestLapTime) = (select lap, time from (select l.lap, l.time, min(l.milliseconds) from laptimes l where l.raceId=results.raceId and l.driverId=results.driverId))
   where raceId in (select raceId from races where year between 1996 and 2003);

   update results
   set rank=(select count(*)+1 from results r where r.raceId = results.raceId and r.fastestLapTime 0 and raceId in (select raceId from races where year between 1996 and 2003);

2. Miguel Bento says:

   4 September 2019 at 14:59

   Harrrg, it’s the ‘less than’ and ‘greater than’ signs!

   Let’s try again the 2 statements:

   update results
   set (fastestLap,fastestLapTime) = (select lap, time from (select l.lap, l.time, min(l.milliseconds) from laptimes l where l.raceId=results.raceId and l.driverId=results.driverId))
   where raceId in (select raceId from races where year between 1996 and 2003);

   update results
   set rank=(select count(*)+1 from results r where r.raceId = results.raceId and r.fastestLapTime < results.fastestLapTime)
   where laps > 0 and raceId in (select raceId from races where year between 1996 and 2003);

3. Admin says:

   9 September 2019 at 22:01

   Hi Miguel,
   Many thanks. I may try this offline initially.
   Chris

4. Daniel Johnson says:

   20 June 2020 at 01:12

   Hi Chris,

   Just wanted to drop you a line to say hi and to let you know I’m working on a React frontend for the API as a portfolio project. I’ll be getting docker going and putting the API on my local, but in case you were wondering about the increased requests that’s me. Feel free to email me with any questions/concerns, thanks!

   Best,
   Dan