@[email protected] was in the matrix chat the other day talking about the changes. I think rimu already upstreamed most of them into the project (codeberg). It primarily consisted of creating indices to speed up queries and to do COUNT queries in a better way (codeberg).

DB optimization remains an ever-ongoing thing, and sometimes things like the ORM used (sqlalchemy) kind of gets in the way of crafting efficient queries. So, as more and more people are making piefed accounts, and as talented sysadmins like on piefed.world are running instances, we are learning where things can get better.

Yeah, the activity numbers can be pretty wrong. There is an older issue about this on codeberg: https://codeberg.org/rimu/pyfedi/issues/424

I haven't really dug into this issue yet, so I am not sure if the issue is that certain activities aren't marking users as active recently or that the db queries are somehow not counting users correctly. I suspect it is the former, that certain user actions (eg vote, comment, etc.) aren't then also marking that user as having been recently active.

So, I reached out to some of the app developers on matrix to see if there was interest in adding an endpoint for this to the PieFed API, but it turns out that we already have a way to fetch upvoted posts/comments in the API. So, it is a thing that can be fetched by apps (or if you feel comfortable making api requests and parsing the json it returns). Interstellar is one of the apps that makes use of it, so you could check that one out.

There are a couple reasons why the downvote button isn't visible and I can see why it isn't for you. You can see the python code here if you want to view it yourself.

• The instance admin has disabled downvotes. -> This one does not apply for piefed.world.
• The community that the post is in does not allow you to downvote. -> This one does not apply in most cases.
• Your "reputation" (total upvotes received - total downvotes received) is less than -10. -> This one does not apply in your case since you don't have the red triangles next to your username. Only an admin can actually view your reputation score, so I don't know what it is in your case.
• Your "attitude" is < 0. -> This is what is happening in your case. Basically the attitude is a measure of how much you upvote vs. downvote. The attitude is calculated as (total upvotes given - total downvotes given) / (total votes given) (source). I haven't ever seen a negative attitude user in the wild before, so you must be downvoting a lot more than a typical user.

You could also try mbin. The devs over there have been pleasant to work with. Overall, from interacting with rimu, the philosophy generally is that PieFed tries to give you many more filters and blocks at your disposal so that you just aren't exposed to the kinds of toxic users/communities/posts that you would need to downvote so much. It is a different philosophy, but it is opinionated and it isn't going to be for everybody. This is a strength of the fediverse that there are other options for you to explore.

There are NSFW communities on piefed.world. One example would be ![email protected]. So, it is likely a setting.

If you go to your settings and then the Blocks & Filters page, make sure that you have it set so that you can see NSFW posts. If you have it set to hide NSFW content, then communities marked as NSFW are also hidden as part of that.

Try logging out and then logging back in again and making sure the Low Bandwidth Mode is unchecked. If you accidentally enabled this, then no images will load in the feed.

A comprehensive list of your upvoted posts doesn't exist in the web UI. If you go to your profile page, there is a box in the sidebar that lists your 10 most recently upvoted posts.

This is actually a functionality that some clients offer (Boost has it as well iirc), but it is not part of the PieFed API at all (not sure it is for lemmy either, but I haven't looked). So, the list of items that you have voted on is being recorded and kept track of by the app itself.

It must be I guess. I know that NSFW stuff is hidden by default for visitors that aren't logged in. I also know that you can set a flag that lets PieFed know that you are hosting sensitive content and it changes some of the default NSFW behavior (for example, this is what fedinsfw.app does).