search

oss-aspen / 8Knot

Dash app in development to serve open source community visualizations using GitHub data from Augur. Hosted app: https://eightknot.osci.io
MIT License
47 stars 59 forks source link

update queries with sql in materialized view #418

Closed cdolfi closed 1 year ago

cdolfi commented 1 year ago

This adds the sql query for materialized view in comments

cdolfi commented 1 year ago

@JamesKunstle Im not too familiar with how materialized views work on if there is a way to "read" a materialized view. Ill noodle on where we can put the current sql write out and talk to sean about the possibility of "reading" the materialized view once we get past this current set of augur fixes

cdolfi commented 1 year ago

@JamesKunstle Maybe we can add a materialized view section on the read me? Im struggling to find a good place for this but def think its important bc if anyone is hosting their own instance they will need that info

cdolfi commented 1 year ago

@sgoggins just to confirm, materialized views are unique to a single db?

JamesKunstle commented 1 year ago

@cdolfi I'd write the query as a .sql document in the 8Knot/docs folder and put a reference to that file in the company and contributors function docstrings.

cdolfi commented 1 year ago

@JamesKunstle great ideas, implemented it. This is ready for review again