phiresky
the PersonView::admins query currently does a seq scan on all persons because admin is not indexed. Also, the CommunityView::is_mod_or_admin function does a seq scan on all persons because it uses...
### Requirements - [X] Is this a bug report? For questions or discussions use https://lemmy.ml/c/lemmy_support - [X] Did you check to see if this issue already exists? - [X] Is...
Right now, all API responses (esp. create comment, like, etc) wait for send_activity to complete before returning to the caller. The API response though is already known before this, so...
This should fix https://github.com/LemmyNet/lemmy/issues/3335 as well as a "No community found in cc" error that sometimes shows up. The error is caused by a race condition of the inserts into...
This fixes #3494 by making hot_rank() return 0 if published is in the future
The whole code base uses naive date time and TIMESTAMP WITHOUT TIME ZONE. Now there's conversion issues appearing in federation where timezones are not handled correctly. Using NaiveDateTime is ......
### Requirements - [X] Is this a bug report? For questions or discussions use https://lemmy.ml/c/lemmy_support - [X] Did you check to see if this issue already exists? - [X] Is...
This PR implements a new outgoing federation queue. The end goal is to create a queue that can scale to reddit scale (that is 100-1000 activities per second, sent to...
If e.g. zstd_enable_transparent is called within a transaction, it will fail because zstd_enable_transparent internally starts a transaction. Replacing that with savepoints should fix this. Implementing this would fix https://github.com/sqlitebrowser/sqlitebrowser/issues/3244 PRs...
Instead of running the instances update only every 24h, this runs it every 10 minutes - but it only runs it for instances that have not been updated in >...