{"push_id":1143777936,"size":4,"distinct_size":4,"ref":"refs/heads/master","head":"90f08cf63fd52a09a215906050e8b5a8f3cf7cde","before":"65bb228df2451d04c8d0c4d97776684516c95fdb","commits":[{"sha":"2346a31fa0d0d0823aeac37792b68a05d54df006","author":{"name":"Joachim Breitner","email":"3b8e10480754ba93523db5dc4626a5f001e54bb7@joachim-breitner.de"},"message":"s.numberOfContributors() is too expensive\n\nUse .annotate to query that within the main SQL query, instead of many\nqueries.","distinct":true,"url":"https://api.github.com/repos/mohrm/umklapp_site/commits/2346a31fa0d0d0823aeac37792b68a05d54df006"},{"sha":"2e487212ecb04566ba91fd867822736e664eb815","author":{"name":"Joachim Breitner","email":"3b8e10480754ba93523db5dc4626a5f001e54bb7@joachim-breitner.de"},"message":"Add a test case that fixes the number of SQL queries for the overview","distinct":true,"url":"https://api.github.com/repos/mohrm/umklapp_site/commits/2e487212ecb04566ba91fd867822736e664eb815"},{"sha":"4e48e4c6b8cc127bf14cfcb18f97a9d241a97beb","author":{"name":"Joachim Breitner","email":"3b8e10480754ba93523db5dc4626a5f001e54bb7@joachim-breitner.de"},"message":"Aggregate for upvotes too\n\ncuts down SQL requests for the oveview to 9.","distinct":true,"url":"https://api.github.com/repos/mohrm/umklapp_site/commits/4e48e4c6b8cc127bf14cfcb18f97a9d241a97beb"},{"sha":"90f08cf63fd52a09a215906050e8b5a8f3cf7cde","author":{"name":"Joachim Breitner","email":"3b8e10480754ba93523db5dc4626a5f001e54bb7@joachim-breitner.de"},"message":"Use distinct=True with .annotate\n\nUnfortunately, the semantics of .annotate are not very reliable:\n\n> Combining multiple aggregations with annotate() will [yield the\n> wrong](https://code.djangoproject.com/ticket/10060)\n> results because joins are used instead of subqueries\n>\n> If in doubt, inspect the SQL query!\n>\n> In order to understand what happens in your query, consider inspecting\n> the query property of your QuerySet.\n\nVery unfortunate. What good is an ORM mapper if you cannot rely on it?\nAnyways, since we only do Count aggregation, adding distinct=True is\nsupposed to help.","distinct":true,"url":"https://api.github.com/repos/mohrm/umklapp_site/commits/90f08cf63fd52a09a215906050e8b5a8f3cf7cde"}]}
{"actor":{"display_login":"nomeata"}}