Nostr Web Client

Thanks. Data is denormalized already so no joins. That is not enough. Yes, I'm happy to ask the relay to bear the weight for me.

franzap 1y ago

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

Reply to this note

Please Login to reply.

Discussion

brugeman 1y ago

Maybe each app can link to it's latest release?

franzap 1y ago

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 1y ago

So you load apps and then latest releases by id?

franzap 1y ago

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 1y ago

Is com1 linking to latest release?

franzap 1y ago

Assume that appid is in a tag in the release itself.

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

Thank you! 🫂