search

OpenTreeOfLife / otindex

opentree index using postgres and pyramid
BSD 2-Clause "Simplified" License
0 stars 0 forks source link

add jsonb field to trees table #17

Closed kcranston closed 8 years ago

kcranston commented 8 years ago

The jsonb queries in postgres do not allow for the type of nested queries that we need in order to provide search across tree properties. I think we can better support tree property queries by storing the json blob for each tree in a jsonb column for the tree table. This does raise the question about whether it is worth stripping the tree information out of the json blob in the study table.

kcranston commented 8 years ago

Done. Did remove the tree dict from the nexson before loading into data field of study table.