4 ms·
I just made tags nosql, it's stored as json data in pg with a user set to each tag. I think the relation was that each user could have mutlitple posts that eac
by langsoul-com 4y ago
I just made tags nosql, it's stored as json data in pg with a user set to each tag.
I think the relation was that each user could have mutlitple posts that each contain multiple tags.
Where each tag is global with an user ids stored with the user Id as the key. Or something approximatating that.
Mainly to not need insane queries for many to many relationships. O(1) baby.
- dahdum 4y agoCan you search by tag expressions like “((1|2)&(!3))” with your method? I’m not understanding it completely. I often use json_data but I didn’t consider tagging methods because of the overhead it has.