3 ms·
For simple cases, you can get pretty far storing relations 6 times in SQLite, or any old key/value store. (a-b-son, b-a-father, son-a-b, father-b-a, a-son-b, b-
by rjh29 4y ago
For simple cases, you can get pretty far storing relations 6 times in SQLite, or any old key/value store. (a-b-son, b-a-father, son-a-b, father-b-a, a-son-b, b-father-a)
- steve_gh 4y agoThis is interesting - can you expand a little or provide a link. I get a-b links, but where do father and son come in?
- rjh29 4y agoI think I read it in a tech company's blog post, but there are some Wikipedia articles on the subject: https://en.wikipedia.org/wiki/Triplestore https://en.wikipedia.org/wiki/Triplestore https://en.wikipedia.org/wiki/Entity%E2%80%93attribute%E2%80%93value_model https://en.wikipedia.org/wiki/Entity%E2%80%93attribute%E2%80... The father/son is the relation between the two nodes, to support multiple relation types.