3 commits

Author	SHA1	Message	Date
Dessalines	be1389420b	Adding SQL format checking via pg_format / pgFormatter (#3740) ... * SQL format checking, 1. * SQL format checking, 2. * SQL format checking, 3. * SQL format checking, 4. * SQL format checking, 5. * Running pg_format * Getting rid of comment. * Upping pg_format version. * Using git ls-files for sql format check. * Fixing sql lints. * Addressing PR comments.	2023-08-02 12:44:51 -04:00
Dessalines	8cb5939f50	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	2023-06-08 16:15:15 -04:00
Nutomic	1c9f0c2bed	Add db index for post.url column (#2929) ... * Add db index for post.url column As mentioned in https://github.com/LemmyNet/lemmy/issues/2877#issuecomment-1576439829 Not sure if its preferable to do this, or make a combined index which includes post.nsfw, post.removed, post.deleted * remove unique	2023-06-07 11:31:24 -04:00