Graph interface for Discourse

[DavidGNavas (David García-Navas)]

Something similar to this?

Network chart of your forum - data visualization

Thanks to the Data Explorer Plugin and the query that @riking created, we have a great visualization of the interaction in our instance. [image] You can also play with it. It’s easy to do it: 1 - Install Data Explorer plugin 2 - Run the riking query or an modified version of it.

We use a version that only extracts from a specific group

WITH pairs AS ( SELECT p.user_id liked, pa.user_id liker FROM post_actions pa LEFT JOIN posts p ON p.id = pa.post_id WHERE post_act…