Open Food Facts Query

The Open Food Facts Query project compute aggreations requests that are visible on the website as the user use the option "Explore products by". It avoid using MongoDB for such tasks, giving faster results.

The repository is at : https://github.com/openfoodfacts/openfoodfacts-query/

Production deployment

It is deployed on the docker-prod-2 vm (vm 200) on moji server (aka osm45), using docker-compose.

It relies on the stunnel to join other services.

Staging deployment

It is deployed on the staging dockers VM as a docker-compose project. And available at https://query.openfoodfacts.net/

The /var/lib/docker/volumes is mounted on a specific ZFS dataset to host it on the NVME pool.

Testing

The app is a replacement to mongodb aggregations queries, so it accepts such aggregations.

You can test it's working using:

curl -d '[{"$match": {"countries_tags": "en:france"}},{"$group":{"_id":"$brands_tags"}}]' -H "Content-Type: application/json" https://query.openfoodfacts.org/aggregate