{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":436540330,"defaultBranch":"main","name":"location","ownerLogin":"plausible","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2021-12-09T08:36:38.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/54802774?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1708331337.0","currentOid":""},"activityList":{"items":[{"before":"6caf436f5957deff9140d8d59d0ab13f27e5ae2b","after":null,"ref":"refs/heads/a1-country","pushedAt":"2024-02-19T08:28:57.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"ukutaht","name":"Uku Taht","path":"/ukutaht","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/3731516?s=80&v=4"}},{"before":"31f91c4df430cfc16219000ac667cc665826b77c","after":"3f360af0c9deac1d2ca0bd1c4fcb8769b673d948","ref":"refs/heads/main","pushedAt":"2024-02-19T08:28:55.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"ukutaht","name":"Uku Taht","path":"/ukutaht","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/3731516?s=80&v=4"},"commit":{"message":"Merge pull request #9 from plausible/a1-country\n\nAdd country code for anonymising VPN services","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2134031199\" data-permission-text=\"Title is private\" data-url=\"https://github.com/plausible/location/issues/9\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/plausible/location/pull/9/hovercard\" href=\"https://github.com/plausible/location/pull/9\">#9</a> from plausible/a1-country"}},{"before":null,"after":"6caf436f5957deff9140d8d59d0ab13f27e5ae2b","ref":"refs/heads/a1-country","pushedAt":"2024-02-14T10:25:35.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"cnkk","name":"Cenk Kücük","path":"/cnkk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/22169793?s=80&v=4"},"commit":{"message":"Add country code for anonymising VPN services","shortMessageHtmlLink":"Add country code for anonymising VPN services"}},{"before":"be736124a6d5b795470a914830b4de2325bb797f","after":null,"ref":"refs/heads/fixup-to-speedup-location-loading","pushedAt":"2023-03-27T14:30:36.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"aerosol","name":"hq1","path":"/aerosol","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/173738?s=80&v=4"}},{"before":null,"after":"be736124a6d5b795470a914830b4de2325bb797f","ref":"refs/heads/fixup-to-speedup-location-loading","pushedAt":"2023-03-27T14:30:35.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"aerosol","name":"hq1","path":"/aerosol","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/173738?s=80&v=4"},"commit":{"message":"Fixup: degraded performance with faster db loading\n\nAs pointed out by @vinibrsl, the `select` used\npreviously had a major performance impact, especially with\ncompressed tables.\n\nThis commit reverts the change that naively made\nall lookups go through a single table and circles back\nto two separaretly keyed tables.\n\nAdditionally, both table types are now `set` with\n`decentralized_counters` disabled (that optimization\nmatters only when frequent mutations are run\n- in this case, we only need `write_concurrency`\nfor table initialization phase).","shortMessageHtmlLink":"Fixup: degraded performance with faster db loading"}},{"before":"be736124a6d5b795470a914830b4de2325bb797f","after":null,"ref":"refs/heads/fixup-to-speedup-location-loading","pushedAt":"2023-03-27T14:30:33.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"aerosol","name":"hq1","path":"/aerosol","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/173738?s=80&v=4"}},{"before":"2c672d97f1ee872c5a4161c0945aafcb85ec8e0d","after":"31f91c4df430cfc16219000ac667cc665826b77c","ref":"refs/heads/main","pushedAt":"2023-03-27T14:30:30.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"aerosol","name":"hq1","path":"/aerosol","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/173738?s=80&v=4"},"commit":{"message":"Fixup: degraded performance with faster db loading (#6)\n\nAs pointed out by @vinibrsl, the `select` used\r\npreviously had a major performance impact, especially with\r\ncompressed tables.\r\n\r\nThis commit reverts the change that naively made\r\nall lookups go through a single table and circles back\r\nto two separaretly keyed tables.\r\n\r\nAdditionally, both table types are now `set` with\r\n`decentralized_counters` disabled (that optimization\r\nmatters only when frequent mutations are run\r\n- in this case, we only need `write_concurrency`\r\nfor table initialization phase).","shortMessageHtmlLink":"Fixup: degraded performance with faster db loading (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1642206007\" data-permission-text=\"Title is private\" data-url=\"https://github.com/plausible/location/issues/6\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/plausible/location/pull/6/hovercard\" href=\"https://github.com/plausible/location/pull/6\">#6</a>)"}},{"before":"4a753409bb22d29548b095a913a972f0d4a3743b","after":"be736124a6d5b795470a914830b4de2325bb797f","ref":"refs/heads/fixup-to-speedup-location-loading","pushedAt":"2023-03-27T14:27:35.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"aerosol","name":"hq1","path":"/aerosol","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/173738?s=80&v=4"},"commit":{"message":"Fixup: degraded performance with faster db loading\n\nAs pointed out by @vinibrsl, the `select` used\npreviously had a major performance impact, especially with\ncompressed tables.\n\nThis commit reverts the change that naively made\nall lookups go through a single table and circles back\nto two separaretly keyed tables.\n\nAdditionally, both table types are now `set` with\n`decentralized_counters` disabled (that optimization\nmatters only when frequent mutations are run\n- in this case, we only need `write_concurrency`\nfor table initialization phase).","shortMessageHtmlLink":"Fixup: degraded performance with faster db loading"}},{"before":null,"after":"4a753409bb22d29548b095a913a972f0d4a3743b","ref":"refs/heads/fixup-to-speedup-location-loading","pushedAt":"2023-03-27T14:25:06.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"aerosol","name":"hq1","path":"/aerosol","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/173738?s=80&v=4"},"commit":{"message":"Fixup: degraded performance with faster db loading\n\nAs pointed out by @vinibrsl, the `select` used\npreviously had a major performance impact, especially with\ncompressed tables.\n\nThis commit reverts the change that naively made\nall lookups go through a single table and circles back\nto two separaretly keyed tables.\n\nAdditionally, both table types are now `set` with\n`decentralized_counters` disabled (that optimization\nmatters only when frequent mutations are run\n- in this case, we only need `write_concurrency`\nfor table initialization phase).","shortMessageHtmlLink":"Fixup: degraded performance with faster db loading"}},{"before":"463cb8c39c3cb8e6ca1a30d7d8670464662f92b8","after":null,"ref":"refs/heads/speed-up-location-loading","pushedAt":"2023-03-27T09:11:06.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"aerosol","name":"hq1","path":"/aerosol","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/173738?s=80&v=4"}},{"before":"b74d65e06b4613cc43362d16b532f27774a8bbce","after":"2c672d97f1ee872c5a4161c0945aafcb85ec8e0d","ref":"refs/heads/main","pushedAt":"2023-03-27T09:11:01.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"aerosol","name":"hq1","path":"/aerosol","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/173738?s=80&v=4"},"commit":{"message":"Speed up location db loading by ~10x (#5)\n\n* Speed up location db loading by ~10x\r\n\r\n* Add :infinity timeout to async stream\r\n\r\nIt's not like there was a way to recover from\r\ntime-sensitive failure anyway","shortMessageHtmlLink":"Speed up location db loading by ~10x (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1632556981\" data-permission-text=\"Title is private\" data-url=\"https://github.com/plausible/location/issues/5\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/plausible/location/pull/5/hovercard\" href=\"https://github.com/plausible/location/pull/5\">#5</a>)"}},{"before":"1f65d4b255b2e49aa2c1b7953409f560c5361890","after":"463cb8c39c3cb8e6ca1a30d7d8670464662f92b8","ref":"refs/heads/speed-up-location-loading","pushedAt":"2023-03-21T05:45:49.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"aerosol","name":"hq1","path":"/aerosol","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/173738?s=80&v=4"},"commit":{"message":"Add :infinity timeout to async stream\n\nIt's not like there was a way to recover from\ntime-sensitive failure anyway","shortMessageHtmlLink":"Add :infinity timeout to async stream"}},{"before":null,"after":"1f65d4b255b2e49aa2c1b7953409f560c5361890","ref":"refs/heads/speed-up-location-loading","pushedAt":"2023-03-20T17:14:31.852Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"aerosol","name":"hq1","path":"/aerosol","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/173738?s=80&v=4"},"commit":{"message":"Speed up location db loading by ~10x","shortMessageHtmlLink":"Speed up location db loading by ~10x"}}],"hasNextPage":false,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAD_mOluQA","startCursor":null,"endCursor":null}},"title":"Activity · plausible/location"}