extensions-website/requirements_dev.txt
Oleg Komarov 13ac2436ad ApprovalQueue: use a materialized table (#240)
see #238

This change improves the listing performance: old code had to process all
ApprovalActivity to compute an extension's moderation status and position in
the queue.

Now we maintain a sortkey, a reference to the latest "meaningful" activity
object, and a total comment count. These fields are updated in a post_save
signal.

"Meaningful" activity means moderation status changes:
approved, awaiting changes, awaiting review.

"Non-meaningful" activity shouldn't affect queue position anymore and
extensions without "meaningful" activity should not appear in the queue, but
their respective detail pages should still be reachable via a direct link.
This UX may still need improvement, and #210 may be relevant here.

Reviewed-on: #240
Reviewed-by: Anna Sirota <annasirota@noreply.localhost>
2024-08-23 15:11:45 +02:00

21 lines
341 B
Plaintext

-r requirements.txt
cfgv==3.3.1
coverage==6.4.4
distlib==0.3.5
django-debug-toolbar==4.2.0
factory-boy==3.2.1
Faker==13.15.1
filelock==3.7.1
freezegun==1.5.1
identify==2.5.2
mdgen==0.1.10
nodeenv==1.7.0
platformdirs==2.5.2
pre-commit==2.20.0
python-dateutil==2.8.2
PyYAML==6.0
responses==0.21.0
tblib==3.0.0
toml==0.10.2
virtualenv==20.16.2