Creating Network Graphs

data & reporting
2

If I were going to do this I would

  1. Pull down a backup of the site and load it into a PostgreSQL database; PostgreSQL is the database backing Discourse. (ref)

  2. Create a NoSQL database, specifically Neo4j, from the PostgreSQL data. (ref)

  3. Use the Neo4j query language Cypher to find the realtionships.

Neo4j has a sandbox, you might find the Panama Papers example of interest.

EDIT

Once the Neo4j database is up an working to keep the Neo4j database in sync with the Discourse PostgreSQL database I would use either

a. PostgreSQL triggers
b. Discourse webhooks

6 Likes