Design notes for summer 2019
Data logistics system enabling real-time genomic epidemiology. Built for the Seattle Flu Study.
Source code
Contributors
Latest commits
- 19 May 2020 - Merge pull request #151 from seattleflu/materialized-view-refresher Materialized view refresher
- 19 May 2020 - refresh-materialized-view: use client side cursor Remove the argument to `db.cursor()` to use a client-side cursor. For some reason, using a server-side cursor suppresses errors.
- 18 May 2020 - Tag schema
- 18 May 2020 - Add command `refresh-materialized-view` This command uses the custom function `refresh_materialized_view` to refresh specified materialized views so that any user that's granted the "materialized-view-refresher" role can use this command without being the view owner.
- 18 May 2020 - Add materialized-view-refresher role Regular users cannot refresh materialized views because only the view owner has permission to refresh them. Create a function that runs in the security context of its owner so that other users can refresh the view. Grant execute on function to "materialized-view-refresher" so that all users with that role can refresh materializeed views.
Pages
- / dev / doc / design-2019-summer / 01-overview
- / dev / doc / design-2019-summer / 02-organisms
- / dev / doc / design-2019-summer / 03-places
- / dev / doc / design-2019-summer / 04-fhir
- / dev / doc / design-2019-summer / 05-rdml
- / dev / doc / design-2019-summer / 06-redcap
- / dev / doc / design-2019-summer / 07-genomics
- / dev / doc / design-2019-summer / 08a-vaccination
- / dev / doc / design-2019-summer / 08b-race-ethnicity
- / dev / doc / design-2019-summer / 08c-symptoms
- / dev / doc / design-2019-summer / 09-modularization
- / dev / doc / design-2019-summer / 10-infrastructure
- / DEVELOPMENT
- /