Ideas of queries we'll need (non-exhaustive):
- Want to retrieve a list of resources (with all their corresponding information) related to gender
- Want to retrieve a list of resources relevant (directly or indirectly) to age, ethnicity and gender only
The above examples are a little specific, but hopefully give a good general idea. Please add your thoughts (especially of more generic queries) to this issue and/or a document on here or hackmd :)
Considerations:
Do we want to have our results as an object (JSON)?
How do we display all the tags of a resource?
How do we avoid duplicating the resource's appearance in our response, if it relates to several of our demographic tags, for example?
See the "junction table approach" for example queries http://blog.bguiz.com/2017/postgres-many2many-sql-non-relational/
Ideas of queries we'll need (non-exhaustive):
The above examples are a little specific, but hopefully give a good general idea. Please add your thoughts (especially of more generic queries) to this issue and/or a document on here or hackmd :)
Considerations:
Do we want to have our results as an object (JSON)?
How do we display all the tags of a resource?
How do we avoid duplicating the resource's appearance in our response, if it relates to several of our demographic tags, for example?
See the "junction table approach" for example queries http://blog.bguiz.com/2017/postgres-many2many-sql-non-relational/