{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":827590,"defaultBranch":"master","name":"beets","ownerLogin":"beetbox","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2010-08-09T23:17:20.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/15920313?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1718830759.0","currentOid":""},"activityList":{"items":[{"before":null,"after":"2c4b42d16733f8c2e79c6c114230e878ebf97bb8","ref":"refs/heads/only-fast-filtering","pushedAt":"2024-06-19T20:59:19.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"snejus","name":"Šarūnas Nejus","path":"/snejus","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16212750?s=80&v=4"},"commit":{"message":"Keep the same FieldQuery.field interface as before","shortMessageHtmlLink":"Keep the same FieldQuery.field interface as before"}},{"before":null,"after":"2800a323a28f706501e7a40f78012c8942b3b2bf","ref":"refs/heads/revert-only-fast-queries","pushedAt":"2024-06-19T20:58:24.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"snejus","name":"Šarūnas Nejus","path":"/snejus","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16212750?s=80&v=4"},"commit":{"message":"Revert \"Make queries fast, filter all flexible attributes (#5240)\"\n\nThis reverts commit 143b9202f3f2bb95738db3260b29827199273260, reversing\nchanges made to 8508a57d776433df5d331d58c4d7a6fcc178b6c0.","shortMessageHtmlLink":"Revert \"Make queries fast, filter all flexible attributes (#5240)\""}},{"before":"2c4b42d16733f8c2e79c6c114230e878ebf97bb8","after":null,"ref":"refs/heads/only-fast-filtering","pushedAt":"2024-06-17T08:10:59.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"snejus","name":"Šarūnas Nejus","path":"/snejus","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16212750?s=80&v=4"}},{"before":"8508a57d776433df5d331d58c4d7a6fcc178b6c0","after":"143b9202f3f2bb95738db3260b29827199273260","ref":"refs/heads/master","pushedAt":"2024-06-17T08:10:47.000Z","pushType":"pr_merge","commitsCount":15,"pusher":{"login":"snejus","name":"Šarūnas Nejus","path":"/snejus","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16212750?s=80&v=4"},"commit":{"message":"Make queries fast, filter all flexible attributes (#5240)\n\nAnother and (hopefully) final attempt to improve querying speed.\r\n\r\nFixes #4360 \r\nFixes #3515\r\nand possibly more issues to do with slow queries.\r\n\r\nThis PR supersedes #4746.\r\n\r\n## What's been done\r\nThe `album` and `item` tables are joined, and corresponding data from\r\n`item_attributes` and `album_attributes` is merged and made available\r\nfor filtering. This enables to achieve the following:\r\n\r\n- [x] Faster album path queries, `beet list -a path::some/path` \r\n- [x] Faster flexible attributes queries, both albums and tracks, `beet\r\nlist play_count:10`\r\n- [x] (New) Ability to filter albums with track-level (and vice-versa)\r\n**db** field queries, `beet list -a title:something`\r\n- [x] (New) Ability to filter tracks with album-level **flexible** field\r\nqueries, `beet list artpath:cover`\r\n- [x] (New) Ability to filter albums with track-level **flexible** field\r\nqueries, `beet list -a art_source:something`\r\n\r\n## Benchmarks\r\n\r\n\r\n\r\nYou can see that now querying speed is more or less constant regardless\r\nof the query, and the speed is mostly influenced by how many results\r\nneed to be printed out\r\n\r\n\r\n\r\nCompare this with what we had previously\r\n\r\n\r\n\r\n## Later\r\nhttps://github.com/beetbox/beets/issues/5318\r\nhttps://github.com/beetbox/beets/issues/5319","shortMessageHtmlLink":"Make queries fast, filter all flexible attributes (#5240)"}},{"before":"2f80ff07e46e1cafeba15b048929a6972c35f03c","after":"2c4b42d16733f8c2e79c6c114230e878ebf97bb8","ref":"refs/heads/only-fast-filtering","pushedAt":"2024-06-17T07:59:27.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"snejus","name":"Šarūnas Nejus","path":"/snejus","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16212750?s=80&v=4"},"commit":{"message":"Keep the same FieldQuery.field interface as before","shortMessageHtmlLink":"Keep the same FieldQuery.field interface as before"}},{"before":"29da72b1d9b32c23b9485d0adafbe5807387d0d8","after":null,"ref":"refs/heads/bring-back-source-files-to-codecov","pushedAt":"2024-06-16T23:57:02.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"Serene-Arc","name":"Serene ","path":"/Serene-Arc","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33189705?s=80&v=4"}},{"before":"0e87389994a9969fa0930ffaa607609d02e286a8","after":"8508a57d776433df5d331d58c4d7a6fcc178b6c0","ref":"refs/heads/master","pushedAt":"2024-06-16T23:56:59.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"Serene-Arc","name":"Serene ","path":"/Serene-Arc","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33189705?s=80&v=4"},"commit":{"message":"Bring back source files to codecov (#5316)","shortMessageHtmlLink":"Bring back source files to codecov (#5316)"}},{"before":"11d584aa838d5dd2788707016d4de5205fbac004","after":"2f80ff07e46e1cafeba15b048929a6972c35f03c","ref":"refs/heads/only-fast-filtering","pushedAt":"2024-06-16T22:45:58.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"snejus","name":"Šarūnas Nejus","path":"/snejus","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16212750?s=80&v=4"},"commit":{"message":"Add a changelog note and a mention in queries.rst","shortMessageHtmlLink":"Add a changelog note and a mention in queries.rst"}},{"before":null,"after":"29da72b1d9b32c23b9485d0adafbe5807387d0d8","ref":"refs/heads/bring-back-source-files-to-codecov","pushedAt":"2024-06-16T17:27:50.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"snejus","name":"Šarūnas Nejus","path":"/snejus","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16212750?s=80&v=4"},"commit":{"message":"Show source files on codecov\n\nWhile the commit merged yesterday fixed the coverage upload to\ncoveralls, it broke the source files preview on the platform.\n\nThis was due to the missing actions/checkout step in the coverage upload\njob.","shortMessageHtmlLink":"Show source files on codecov"}},{"before":"8190fc54ae7af852fe01ca60c98e1f9314d45b26","after":"11d584aa838d5dd2788707016d4de5205fbac004","ref":"refs/heads/only-fast-filtering","pushedAt":"2024-06-16T17:24:44.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"snejus","name":"Šarūnas Nejus","path":"/snejus","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16212750?s=80&v=4"},"commit":{"message":"Define json functions for old SQLite versions","shortMessageHtmlLink":"Define json functions for old SQLite versions"}},{"before":"77685d5948b01923e3012eb1e2ffce39ec88b09e","after":"8190fc54ae7af852fe01ca60c98e1f9314d45b26","ref":"refs/heads/only-fast-filtering","pushedAt":"2024-06-16T17:14:01.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"snejus","name":"Šarūnas Nejus","path":"/snejus","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16212750?s=80&v=4"},"commit":{"message":"Try fixing source files not being shown in coverage","shortMessageHtmlLink":"Try fixing source files not being shown in coverage"}},{"before":"11d584aa838d5dd2788707016d4de5205fbac004","after":"77685d5948b01923e3012eb1e2ffce39ec88b09e","ref":"refs/heads/only-fast-filtering","pushedAt":"2024-06-16T17:03:15.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"snejus","name":"Šarūnas Nejus","path":"/snejus","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16212750?s=80&v=4"},"commit":{"message":"Try fixing source files not being shown in coverage","shortMessageHtmlLink":"Try fixing source files not being shown in coverage"}},{"before":"123217d113c368c61aa290bec76cae5ab121b5c9","after":"11d584aa838d5dd2788707016d4de5205fbac004","ref":"refs/heads/only-fast-filtering","pushedAt":"2024-06-16T16:56:46.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"snejus","name":"Šarūnas Nejus","path":"/snejus","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16212750?s=80&v=4"},"commit":{"message":"Define json functions for old SQLite versions","shortMessageHtmlLink":"Define json functions for old SQLite versions"}},{"before":"0587ebfd48b2f0abef6296981ab3f788fd418d75","after":"123217d113c368c61aa290bec76cae5ab121b5c9","ref":"refs/heads/only-fast-filtering","pushedAt":"2024-06-16T16:09:04.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"snejus","name":"Šarūnas Nejus","path":"/snejus","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16212750?s=80&v=4"},"commit":{"message":"Define json functions for old SQLite versions","shortMessageHtmlLink":"Define json functions for old SQLite versions"}},{"before":"ed5afd2f1bec55b6fab903abd433a997dd11bdee","after":"0587ebfd48b2f0abef6296981ab3f788fd418d75","ref":"refs/heads/only-fast-filtering","pushedAt":"2024-06-16T15:53:36.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"snejus","name":"Šarūnas Nejus","path":"/snejus","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16212750?s=80&v=4"},"commit":{"message":"Define json functions for old SQLite versions","shortMessageHtmlLink":"Define json functions for old SQLite versions"}},{"before":"1f932078237d30e336a766da6b92a23e3fdfa66d","after":"ed5afd2f1bec55b6fab903abd433a997dd11bdee","ref":"refs/heads/only-fast-filtering","pushedAt":"2024-06-16T15:06:50.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"snejus","name":"Šarūnas Nejus","path":"/snejus","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16212750?s=80&v=4"},"commit":{"message":"Define json_group_object aggregate for old SQLite versions","shortMessageHtmlLink":"Define json_group_object aggregate for old SQLite versions"}},{"before":"6d8cec9b22c8e95cfedf07695f0eeb7f14f90850","after":"1f932078237d30e336a766da6b92a23e3fdfa66d","ref":"refs/heads/only-fast-filtering","pushedAt":"2024-06-16T14:28:49.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"snejus","name":"Šarūnas Nejus","path":"/snejus","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16212750?s=80&v=4"},"commit":{"message":"Add any_writable_field_query to fix bpd search","shortMessageHtmlLink":"Add any_writable_field_query to fix bpd search"}},{"before":"dd2c9f821b5817a6f118ba20b8aa142e1f629de5","after":"6d8cec9b22c8e95cfedf07695f0eeb7f14f90850","ref":"refs/heads/only-fast-filtering","pushedAt":"2024-06-16T14:22:58.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"snejus","name":"Šarūnas Nejus","path":"/snejus","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16212750?s=80&v=4"},"commit":{"message":"Add any_writable_field_query to fix bpd search","shortMessageHtmlLink":"Add any_writable_field_query to fix bpd search"}},{"before":"4136be2dfd15c9f841eb086025cb6cbb29fd5808","after":"dd2c9f821b5817a6f118ba20b8aa142e1f629de5","ref":"refs/heads/only-fast-filtering","pushedAt":"2024-06-16T13:31:53.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"snejus","name":"Šarūnas Nejus","path":"/snejus","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16212750?s=80&v=4"},"commit":{"message":"Ensure that any field query uses the table name\n\nIn order to include the table name for fields in this query, use the\n`field_query` method.\n\nSince `AnyFieldQuery` is just an `OrQuery` under the hood, remove it and\nconstruct `OrQuery` explicitly instead.","shortMessageHtmlLink":"Ensure that any field query uses the table name"}},{"before":"f253d4d608e3082fd9f1036d11bce269b5b1c087","after":"4136be2dfd15c9f841eb086025cb6cbb29fd5808","ref":"refs/heads/only-fast-filtering","pushedAt":"2024-06-16T13:20:11.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"snejus","name":"Šarūnas Nejus","path":"/snejus","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16212750?s=80&v=4"},"commit":{"message":"Ensure that any field query uses the table name\n\nIn order to include the table name for fields in this query, use the\n`field_query` method.\n\nSince `AnyFieldQuery` is just an `OrQuery` under the hood, remove it and\nconstruct `OrQuery` explicitly instead.","shortMessageHtmlLink":"Ensure that any field query uses the table name"}},{"before":"c7924badc7d5dab83d1b936c37206dc3c594cdcd","after":"f253d4d608e3082fd9f1036d11bce269b5b1c087","ref":"refs/heads/only-fast-filtering","pushedAt":"2024-06-16T13:08:52.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"snejus","name":"Šarūnas Nejus","path":"/snejus","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16212750?s=80&v=4"},"commit":{"message":"Ensure that any field query uses the table name\n\nIn order to include the table name for fields in this query, use the\n`field_query` method.\n\nSince `AnyFieldQuery` is just an `OrQuery` under the hood, remove it and\nconstruct `OrQuery` explicitly instead.","shortMessageHtmlLink":"Ensure that any field query uses the table name"}},{"before":"e3c233f1468152f4e00541294442635b8d666645","after":"c7924badc7d5dab83d1b936c37206dc3c594cdcd","ref":"refs/heads/only-fast-filtering","pushedAt":"2024-06-16T12:27:08.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"snejus","name":"Šarūnas Nejus","path":"/snejus","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16212750?s=80&v=4"},"commit":{"message":"Ensure that any field query uses the table name\n\nIn order to include the table name for fields in this query, use the\n`field_query` method.\n\nSince `AnyFieldQuery` is just an `OrQuery` under the hood, remove it and\nconstruct `OrQuery` explicitly instead.","shortMessageHtmlLink":"Ensure that any field query uses the table name"}},{"before":"c02217def6b2d2a4b1c39e606ec9e70d5e92a3d7","after":"e3c233f1468152f4e00541294442635b8d666645","ref":"refs/heads/only-fast-filtering","pushedAt":"2024-06-16T12:18:22.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"snejus","name":"Šarūnas Nejus","path":"/snejus","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16212750?s=80&v=4"},"commit":{"message":"Ensure that any field query uses the table name\n\nIn order to include the table name for fields in this query, use the\n`field_query` method.\n\nSince `AnyFieldQuery` is just an `OrQuery` under the hood, remove it and\nconstruct `OrQuery` explicitly instead.","shortMessageHtmlLink":"Ensure that any field query uses the table name"}},{"before":"30d345dd7d958069401b0f3a13172153172105af","after":null,"ref":"refs/heads/fix-running-tests-with-coverage","pushedAt":"2024-06-16T12:07:14.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"snejus","name":"Šarūnas Nejus","path":"/snejus","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16212750?s=80&v=4"}},{"before":"0e1b5c20eddc75813e1821e7e3c2e321285f5a8b","after":null,"ref":"refs/heads/do-not-run-coverage-by-default","pushedAt":"2024-06-16T12:06:03.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"snejus","name":"Šarūnas Nejus","path":"/snejus","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16212750?s=80&v=4"}},{"before":"a8c0cf4de0e1101046014db0d7a029ef9c4d9b41","after":"c02217def6b2d2a4b1c39e606ec9e70d5e92a3d7","ref":"refs/heads/only-fast-filtering","pushedAt":"2024-06-16T11:53:05.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"snejus","name":"Šarūnas Nejus","path":"/snejus","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16212750?s=80&v=4"},"commit":{"message":"Ensure that any field query uses the table name\n\nIn order to include the table name for fields in this query, use the\n`field_query` method.\n\nSince `AnyFieldQuery` is just an `OrQuery` under the hood, remove it and\nconstruct `OrQuery` explicitly instead.","shortMessageHtmlLink":"Ensure that any field query uses the table name"}},{"before":"6b63a3090d788942ef4c6c1a742d21c25d110aa9","after":"0e87389994a9969fa0930ffaa607609d02e286a8","ref":"refs/heads/master","pushedAt":"2024-06-16T10:50:27.000Z","pushType":"pr_merge","commitsCount":3,"pusher":{"login":"snejus","name":"Šarūnas Nejus","path":"/snejus","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16212750?s=80&v=4"},"commit":{"message":"Replace `py3_path` and `cpu_count` implementations with builtins (#5227)\n\nReplace py3_path by standard os.fsdecode and use native os.cpu_count.\r\n\r\nThese functions had been written before builtins achieving the same have\r\nbeen made available (in Python 3.2 and 3.4). \r\n\r\nNow that they are available though, this PR updates the codebase to use\r\nbuiltin implementations rather than the custom ones.","shortMessageHtmlLink":"Replace py3_path and cpu_count implementations with builtins (#5227)"}},{"before":"076ec6f7738f6bda6bd8258be8aac916b1c8e8a8","after":"6b63a3090d788942ef4c6c1a742d21c25d110aa9","ref":"refs/heads/master","pushedAt":"2024-06-16T01:55:49.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"snejus","name":"Šarūnas Nejus","path":"/snejus","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16212750?s=80&v=4"},"commit":{"message":"Remove flake8 docstrings and its exclusion rules (#5234)","shortMessageHtmlLink":"Remove flake8 docstrings and its exclusion rules (#5234)"}},{"before":"494c67603a6b76dc7d81591b9326c0749d3b6549","after":"076ec6f7738f6bda6bd8258be8aac916b1c8e8a8","ref":"refs/heads/master","pushedAt":"2024-06-16T00:33:00.000Z","pushType":"pr_merge","commitsCount":3,"pusher":{"login":"snejus","name":"Šarūnas Nejus","path":"/snejus","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16212750?s=80&v=4"},"commit":{"message":"Do not run coverage by default (#5312)\n\nFixes #5242.\r\n\r\nThis PR moves coverage measurement from the default `pytest` invocation\r\nto a separate action `test-with-coverage`.","shortMessageHtmlLink":"Do not run coverage by default (#5312)"}},{"before":null,"after":"0e1b5c20eddc75813e1821e7e3c2e321285f5a8b","ref":"refs/heads/do-not-run-coverage-by-default","pushedAt":"2024-06-15T22:55:55.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"snejus","name":"Šarūnas Nejus","path":"/snejus","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16212750?s=80&v=4"},"commit":{"message":"Gitignore the .reports directory","shortMessageHtmlLink":"Gitignore the .reports directory"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEae3aNQA","startCursor":null,"endCursor":null}},"title":"Activity · beetbox/beets"}