* Adding End software patents badge.

Context: https://github.com/LemmyNet/joinlemmy-site/issues/283

* Smaller badge.

* Smaller badge 2.

* Smaller badge 3.

* Add missing test cleanup

* cleanup

* 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