Untitled Git - lemmy.git/commit

]> Untitled Git - lemmy.git/commit

author	Dessalines <dessalines@users.noreply.github.com>
	Thu, 8 Jun 2023 20:15:15 +0000 (16:15 -0400)
committer	GitHub <noreply@github.com>
	Thu, 8 Jun 2023 20:15:15 +0000 (16:15 -0400)
commit	8cb5939f5048c3eab293884923d4c3d5fcc08e2f
tree	2e6c8eb6b34e46dc176c1c6cfc71649c6ea674ba	tree \| snapshot
parent	4e5798852f583a68d123a9c49ae0ef59ec9ffc76	commit \| diff

Adding hot_rank columns in place of function sorting. (#2952)

* Adding hot_rank columns in place of function sorting.

- Creates hot_rank columns for post, comment, and community.
- Fixes #2932

* Updating all hot ranks on startup.

* Fixing post.url migration.

* Removing update_instance_software from startup.

* Adding post_rank query

15 files changed:

crates/db_schema/src/aggregates/structs.rs		diff \| blob \| history
crates/db_schema/src/schema.rs		diff \| blob \| history
crates/db_views/src/comment_report_view.rs		diff \| blob \| history
crates/db_views/src/comment_view.rs		diff \| blob \| history
crates/db_views/src/post_report_view.rs		diff \| blob \| history
crates/db_views/src/post_view.rs		diff \| blob \| history
crates/db_views_actor/src/comment_reply_view.rs		diff \| blob \| history
crates/db_views_actor/src/community_view.rs		diff \| blob \| history
crates/db_views_actor/src/person_mention_view.rs		diff \| blob \| history
migrations/2023-06-06-104440_index_post_url/down.sql		diff \| blob \| history
migrations/2023-06-06-104440_index_post_url/up.sql		diff \| blob \| history
migrations/2023-06-07-105918_add_hot_rank_columns/down.sql	[new file with mode: 0644]	blob
migrations/2023-06-07-105918_add_hot_rank_columns/up.sql	[new file with mode: 0644]	blob
scripts/query_testing/post_query_hot_rank.sh	[new file with mode: 0755]	blob
src/scheduled_tasks.rs		diff \| blob \| history

Unnamed repository; edit this file 'description' to name the repository.

RSS Atom