kitsune/docker
Ryan Johnson 28238acfbd
flip the switch to postgres (#5609)
* switch database to postgres

* modify kitsune/dashboards/readouts.py to work with postgres

* modify dashboards/models.py to work with postgres

* modify cache_most_unhelpful_kb_articles.py to work with postgres

* modify wiki/views.py to work with postgres

* modify kpi/api.py to work with postgres

* modify auto_archive_old_questions.py to work with postgres

* ignore email when falsy in FXAAuthBackend.update_user

* fix NotificationsTests.test_solution_notification

* account for postgres ordering of num_visits

* fix question num_votes_past_week when no votes

* fix order_by within the fix_current_revisions command

* improve performance of usernames API

* ensure null values are ordered as expected (1464)

* ensure postgres uses index for helpful votes query (1485)

* ensure announcement query uses timestamp indexes (1492)

* ensure HelpfulVote.created queries use DB index (1492)

* ensure forums.Post.created queries use DB index (1492)

* ensure Question.created queries use DB index (1492)

* ensure QuestionVote.created queries use DB index (1492)

* ensure Question.updated queries use DB index (1492)

* ensure Answer.created/Revision.created queries use DB index (1492)

* limit expensive KPI queries to the last 365 days
2023-11-09 13:33:32 -08:00
..
bin Fix file permissions. 2022-03-14 12:01:20 +02:00
docker-compose.ci.yml flip the switch to postgres (#5609) 2023-11-09 13:33:32 -08:00