A user has requested tag cloud page for their organization. Some things to consider is how expensive it is to generate it. If it's expensive we need to think about caching it or requiring that the end user be logged into an account to see it.
Toying around with queries this one seems to be fairly efficient:
SELECT t.name, COUNT(*) AS tag_count FROM tags t JOIN tag_links tl ON t.id = tl.tag_id JOIN org_links ol ON tl.org_link_id = ol.id WHERE ol.user_id = $1 GROUP BY t.name ORDER BY tag_count DESC;
A tag cloud would be so great! It’s just the easiest way for my students to see all the available topics, click on one and then see all the links assiciated with that said topic.
Thank you Gebhard. How would you envision the tag cloud to work? On the bookmark listing page for quicker filtering? A specific tag cloud page where all the tags are links to the corresponding bookmarks? Both maybe?
I know on Pinboard it's hosted on the bookmark listing page on the right column. I suppose we can do similar but just curious what you think is the best experience.
Thanks Peter! I really like pinboards approach with the tag cloud next to the link listing page, on the right side. But with linktacos existing layout, maybe above the first link? or to the left below or in the menu? At least for me, a seperate tag cloud page would not be so useful.