aboutsummaryrefslogtreecommitdiffstats
path: root/postgres (unfollow)
Commit message (Collapse)AuthorLines
2022-01-10Add netcup logo to sponsor block on homeapgeGravatar Chris Lovering-0/+3
2022-01-05Shift footer images slightly to be better in lineGravatar Chris Lovering-1/+2
2022-01-05Use an svg for django footer logoGravatar Chris Lovering-2/+2
2022-01-05Add netcup logo to page footerGravatar Chris Lovering-1/+9
2021-12-31Fix faulty regex filters in migration 59Gravatar Boris Muratov-29/+29
Migration 59 populated the filters table with regex filters, some of which were faulty because the `\b` character wasn't escaped. This is fixed in this PR by making all patterns raw strings.
2021-12-16Always include metricity message blocksGravatar Chris Lovering-25/+2
Thanks to a recent database maintenance (https://pythondiscord.freshstatus.io/incident/139811) querying out metricity message data is far cheaper. So there is no longer a reason to only fetch blocks if the member has a low message count.
2021-12-14Query message count directly from messagesGravatar Chris Lovering-3/+5
This was changed due to performance reasons, but after some tweaking in the database, such as increasing work memory and adding an index, this query runs much faster now. To test this, I want to revert this change, so that we can stop the materialised view from refreshing, to see if the act of refreshing is what's causing this query to seem faster when runing against the database.
2021-12-13Bump drf up to 3.12.0Gravatar Chris Lovering-82/+119
This is to add support for Django 3.1's database-agnositic JSONField.