* Sort by post id in post view

* Remove tie_breaker

---------

Co-authored-by: Dessalines <dessalines@users.noreply.github.com>
Co-authored-by: Nutomic <me@nutomic.com>

* Create comment in transaction. Fixes #3741

* Removing if let on comment create.

* Making login case-insensitive. Fixes #4272

* Removing redundant lowercase.

This reverts commit af4d008c.

* Optimizing sql format check.

* Fixing format testing.

* Fixing format testing 2.

* Speed up SQL formatting in CI with parallel processing

* mess up formatting

* check permissions

* make repo world writable

* need git

* use debian image

* apt update

* perl image for faster install

* fix format

* run restore cache in parallel to format

* add drone-cache exit code

* revert sql format changes

* Quick fix for Peertube federation (fixes #4261)

* prettier

* apub assets should be included in slow check paths

* Update post_view.rs

* Update post_view.rs

* Update Cargo.toml

* Update post_view.rs

* fix

* Update post_view.rs

---------

Co-authored-by: SleeplessOne1917 <abias1122@gmail.com>
Co-authored-by: Dessalines <dessalines@users.noreply.github.com>

* Reenable API tests that were accidentally skipped

* log get comment parent id failure

Co-authored-by: Dessalines <dessalines@users.noreply.github.com>

* Add test for fixed deleted post filter

* fmt

* Fmt

* Update post_view.rs

Co-authored-by: Dessalines <dessalines@users.noreply.github.com>

* See if different SQL query fixes performance regression

* Fix formatting

* Hopefully fix failing federation test

* Hopefully solve federation test problem

* Use already-existing coalesce function

* Update person_view.rs

---------

Co-authored-by: SleeplessOne1917 <insomnia-void@protonmail.com>
Co-authored-by: Dessalines <dessalines@users.noreply.github.com>
Co-authored-by: Nutomic <me@nutomic.com>
Co-authored-by: Dessalines <tyhou13@gmx.com>

* Make db queries for GET /api/v3/site in parallel (ref #4244)

* Cache site response

* machete

* Use try_join_with_pool macro

* machete

* taplo

* ttl 1s

* Upgrade dependencies

* clippy

* Set explicit limit for getPosts/getComments in tests

* pretier

* Add CI check for ignored files

* remove ignored files

* Show federated posts on user profile. Fixes #4228

* Make sure posts are hidden if no listing_type is given.

* Dont allow blocking local instance (fixes #4241)

* use localuserview

* Add voters to active users

* Edit formatting

* Edit formatting

* Edit formatting in down.sql

* Fix person table inner joins

* Remove post read from calculations

* Extend sitemap span

* Keep cargo_fmt happy

* Add FETCH_LIMIT_SITEMAP

* Use FETCH_LIMIT_SITEMAP

* Keep cargo_fmt happy

* Update utils.rs

* Use SITEMAP_DAYS

* Keep cargo_fmt happy

* Sitemap

* Keep cargo_fmt happy

* Sitemap

* Sitemap

* Increase to 31 days

* Print version to log

* Keep cargofmt happy

* Keep cargo_fmt happy

* Keep Clippy happy

* Revert "Some changes to help debug auth problems on lemmy.ml (#4220)"

This reverts commit 16ac893e.

* Rename auth cookie back to jwt

* Enable missing code for prometheus actix-web stats

* enable middleware conditionally