Discourse Data Explorer

插件
, ,
281

Yeah I couldn’t remember if this was still just a trust level 3 thing or not. Good call on the ask.discourse.com site.

As a reference example I threw write a discourse data explorer query which returns a list of all users who said the word “software” into the text input bar of ask.discourse.com and got the following query back:

SELECT 
    p.user_id, 
    u.username,
    COUNT(p.id) AS post_count
FROM 
    posts p
JOIN 
    users u ON u.id = p.user_id
WHERE 
    p.raw ILIKE '%software%'
GROUP BY 
    p.user_id, u.username
ORDER BY 
    post_count DESC;

Pretty reasonable. I can also vouch for it doing significantly more complex queries than this

2 个赞