Database views

Jump to bottom

Pau Pérez Fabregat edited this page Jul 23, 2020 · 2 revisions

In https://github.com/coopdevs/sharetribe/pull/62 we introduced a database view as a simple mechanism to hide data from Metabase, the business intelligence software we use from a separate server. Then, https://github.com/coopdevs/donalo/blob/772bb660f8bb5b99bf062bde495d308353d7578c/roles/database/tasks/main.yml#L14-L20 grants its DB user access to this view.

Database views are implemented within the app using https://github.com/scenic-views/scenic. Check out its README to find out how to add or modify them.

⚠️ warning as stated in https://github.com/coopdevs/sharetribe/pull/76, the DEFINER statement doesn't work in production as the user doesn't match the one in development.