Comment on Ask HN: Implementing a graph database using Postgres tables for nodes and edges?Comments−russtrotter10yOne technique you might look into is "Materialized Path":* usually one single query to fetch an entire tree or subtree * more work on reconstructing tree from query result * requires prefix pattern matching operator, e.g. "like" from RDBMS−jordanchan10yThanks! That's a useful technique..
Comments
One technique you might look into is "Materialized Path":
* usually one single query to fetch an entire tree or subtree * more work on reconstructing tree from query result * requires prefix pattern matching operator, e.g. "like" from RDBMS
Thanks! That's a useful technique..