Is the "Recent Changes" page a good use case for openfoodfacts-query ?

[teolemon]

What

• Is the "Recent Changes" page a good use case for openfoodfacts-query ?
• https://world.openfoodfacts.org/cgi/recent_changes.pl?&page=1&page_size=250

[john-gom]

Maybe, although at the moment the data will be delayed by at least a day. If / when we implement an event stream then the data will be more up to date.

[alexgarel]

see also #33

[john-gom]

Currently the Redis change events we use to store events in off-query does not include the IP address of the sender, so we would need to add this in to the events generated by Product Opener.

We also store the countries_tags of the product but I assume this is just for filtering so we could use the current countries_tags for the product rather than needing to know what the countries_tags were at the time of the change.

There are a number of processes which generate changes but don't update the recent_changes_collection, such as update_all_products. However, off-query will not log second or subsequent events for the same product revision in the product history, so this is probably OK.

[john-gom]

Product Opener PR to include IP in Redis events: openfoodfacts/openfoodfacts-server#12253