Oddbean new post about | logout
▲ ▼
franzap | 1 months ago (raw) | root | parent | reply | flag +1 
 I need the latest of each. Limit obviously does not help as it applies to the whole result set. Not using any sort of limit is unviable as I would get too many events
▲ ▼
brugeman | 1 months ago (raw) | root | parent | reply | flag 
 Maybe each app can link to it's latest release?
▲ ▼
franzap | 1 months ago (raw) | root | parent | reply | flag 
 Yes they are linked already.

My request is: Give me the latest release for each one of these app ids. In SQL that can be done with a self-join I think
▲ ▼
brugeman | 1 months ago (raw) | root | parent | reply | flag 
 So you load apps and then latest releases by id?
▲ ▼
franzap | 1 months ago (raw) | root | parent | reply | flag 
 I need to check for updates: for (com.app1, com.app2, com.app3) give me the latest 1063 events for each.

I could use one query for each, but since a user might be checking for 50-100 apps I don't want to do that.
▲ ▼
brugeman | 1 months ago (raw) | root | parent | reply | flag 
 Is com1 linking to latest release?
▲ ▼
franzap | 1 months ago (raw) | root | parent | reply | flag +1 
 Assume that appid is in a tag in the release itself.

But don't worry, I'll figure it out

Thank you! 🫂