pioneer
pioneer wrote
Reply to comment by emma in New official support forums for Postmill + announcement about Postmill's future by emma
Aah thanks, and what's happened with community.postmill.xyz? It's still mentioned on the website.
pioneer wrote
Hmmm where's the community support place now?
pioneer OP wrote (edited )
Reply to comment by emma in Frontpage comments from forums I have not subscribed by pioneer
Just quickly got a look at the code (I'm no PHP dev, but can guess something). Are we talking about
SELECT * FROM comment ORDER BY timestamp;
vs
<subscribed forum ids> = SELECT forum_id FROM forum_subscription WHERE user_id = <current user id>;
<ids of submissions in subscribed forums> = SELECT id FROM submission WHERE forum_id IN (<subscribed forum ids>);
SELECT * FROM comment WHERE submission_id IN (<ids of submissions in subscribed forums>) ORDER BY timestamp;
?
Doesn't look too expensive for me, forgive me if I'm wrong. Though I don't take banned content into account, for example.
pioneer OP wrote
Reply to comment by !deleted8445 in Frontpage comments from forums I have not subscribed by pioneer
Before submitting anything I'd like to understand whether it's intentional by design, or a workaround or something else. Emma has answered above.
pioneer OP wrote
Reply to comment by !deleted8445 in Frontpage comments from forums I have not subscribed by pioneer
On a large site this can quickly become a mess of irrelevant comments.
pioneer wrote
Reply to comment by emma in New official support forums for Postmill + announcement about Postmill's future by emma
That's fine, I'm just asking about the decisions made. So it's now official, a channel in Matrix instead of a forum, ok.