These notes serve as my “digital garden”, so extending the metaphor I tend to benefit from healthy “topsoil”; whichever notes are at the top of my lists will receive more attention.
I’ve used the topic reminder feature in Discourse to auto-bump older topics on a schedule. That works fine. However, I’m changing the focus of this site from being a primary space for me to be an informative resource for the public. Auto-bumping adds noise to a public interface, so a new approach is called for.
Outline of new approach:
Data explorer query for one or more lists of oldest content (topics which have not had any actions or replies)
Automation to run query and post results to a topic
A topic to receive the query results and auto-deletes replies
SELECT
'[' || t.title || '](https://notes.maiki.interi.org/t/' || t.id || ')' AS topic_link,
t.updated_at
FROM
topics t
JOIN
categories c ON t.category_id = c.id
WHERE
t.visible = TRUE
AND t.archetype != 'private_message'
AND t.deleted_at IS NULL
AND c.read_restricted = FALSE
ORDER BY
t.updated_at ASC
LIMIT 10
That grabs the oldest topics that public visitors may see, which is important since it is posted publicly.
Using the script for “Schedule a post with Data Explorer results” I’m able to publish the links I query for:
