search

johnHackworth / goblin

GNU Affero General Public License v3.0
46 stars 4 forks source link

Tag following #36

Closed sirilyan closed 5 months ago

sirilyan commented 6 months ago

Ability to follow a hashtag in the same way you follow an account. Both Tumblr and Mastodon support this (the Tumblr UX is cleaner, to be honest).

Implementing this also means we need the ability to view and edit your list of followed tags.

Mastodon API docs: https://docs.joinmastodon.org/methods/followed_tags/ Missing implementation: https://github.com/johnHackworth/goblin/blob/5448aa7ff02de387ac2470725223f8fc578daeb4/packages/megalodon/src/misskey.ts#L1321

sirilyan commented 5 months ago

Note to self:

-- get notes that contain any of the tags user is following
select "n"."id","n"."tags" from "note" n
   where "n"."tags" && (
select array(select "h"."name" from "hashtag" h
   right join "following_hashtag" f on "h"."id" = "f"."hashtagId"
   where
        "f"."followerId" = '9qd5ge8yp11cn7pm')
     )