Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Give access to off-query db from metrics.openfoodfacts.org #410

Open
4nt0ineB opened this issue Jul 9, 2024 · 3 comments
Open

Give access to off-query db from metrics.openfoodfacts.org #410

4nt0ineB opened this issue Jul 9, 2024 · 3 comments
Assignees
Labels
⭐ top issue Top issue.

Comments

@4nt0ineB
Copy link
Member

4nt0ineB commented Jul 9, 2024

We should give access to off-query database from metrics.openfoodfacts.org to be able to create graphs of product and user events.

@alexgarel
Copy link
Member

@4nt0ineB we will need to :

  1. be sure to expose the database locally
  2. add a stunnel server / client entry.

@john-gom
Copy link

Hi @4nt0ineB . We now have some historic data in staging. The off-query database is exposed on port 5512 on the staging docker host (10.1.0.200).

The PostgreSQL connection details are as follows:
Database: query
Schema: views
User: viewer
Password: off

There is a view called "product_updates_by_owner" which will summarise the updates for each day by owner_tag and update_type

@alexgarel alexgarel self-assigned this Sep 24, 2024
@alexgarel alexgarel transferred this issue from openfoodfacts/openfoodfacts-monitoring Sep 24, 2024
@github-actions github-actions bot added the ⭐ top issue Top issue. label Sep 24, 2024
@alexgarel
Copy link
Member

FTR off-queries is currently moved to moji server.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
⭐ top issue Top issue.
Projects
Status: No status
Status: In Progress
Status: Todo
Development

No branches or pull requests

3 participants