{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":138341622,"defaultBranch":"main","name":"sqlite","ownerLogin":"shareup","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2018-06-22T19:37:53.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/34288754?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1707438235.0","currentOid":""},"activityList":{"items":[{"before":"044cf23412ad875b4ae9fcb0a5d961d592212e2c","after":"09d4b60eaa5725939f6103788cfd31448eac3f3d","ref":"refs/heads/main","pushedAt":"2024-02-09T00:22:09.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"},"commit":{"message":"Coordinate truncate and close (#55)","shortMessageHtmlLink":"Coordinate truncate and close (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2126270541\" data-permission-text=\"Title is private\" data-url=\"https://github.com/shareup/sqlite/issues/55\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/shareup/sqlite/pull/55/hovercard\" href=\"https://github.com/shareup/sqlite/pull/55\">#55</a>)"}},{"before":"c96fe0933699eccb8566f567ae910b54f9df3421","after":null,"ref":"refs/heads/file-coordinator","pushedAt":"2024-02-09T00:22:09.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"}},{"before":null,"after":"c96fe0933699eccb8566f567ae910b54f9df3421","ref":"refs/heads/file-coordinator","pushedAt":"2024-02-09T00:19:10.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"},"commit":{"message":"Coordinate truncate and close","shortMessageHtmlLink":"Coordinate truncate and close"}},{"before":"2da2a6a560824625ad7d0608b1815b21f91af28f","after":null,"ref":"refs/heads/fix-ci-issues","pushedAt":"2024-02-05T11:08:49.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"}},{"before":"4563f1ce306447141f6527b709c0a9903a623650","after":"044cf23412ad875b4ae9fcb0a5d961d592212e2c","ref":"refs/heads/main","pushedAt":"2024-02-05T11:08:49.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"},"commit":{"message":"Prevent long-running tasks from preventing the database from closing (#54)","shortMessageHtmlLink":"Prevent long-running tasks from preventing the database from closing (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2118259822\" data-permission-text=\"Title is private\" data-url=\"https://github.com/shareup/sqlite/issues/54\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/shareup/sqlite/pull/54/hovercard\" href=\"https://github.com/shareup/sqlite/pull/54\">#…</a>"}},{"before":null,"after":"2da2a6a560824625ad7d0608b1815b21f91af28f","ref":"refs/heads/fix-ci-issues","pushedAt":"2024-02-05T10:55:37.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"},"commit":{"message":"Prevent long-running tasks from preventing the database from closing","shortMessageHtmlLink":"Prevent long-running tasks from preventing the database from closing"}},{"before":"892b15a9e89b48664c230e42f140a9a994861a3c","after":null,"ref":"refs/heads/test-vacuum","pushedAt":"2024-02-01T19:02:19.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"}},{"before":"ed1923069f284f6d4f3ec230eb7ca3ea85fc0398","after":"4563f1ce306447141f6527b709c0a9903a623650","ref":"refs/heads/main","pushedAt":"2024-02-01T19:02:18.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"},"commit":{"message":"Use writeWithoutTransaction when appropriate (#53)\n\nThis pull request fixes SQLITE_BUSY errors caused by the shift to IMMEDIATE transactions.\r\n\r\nUpdating the transaction type https://sqlite.org/lang_transaction.html#deferred_immediate_and_exclusive_transactions from the default DEFERRED to IMMEDIATE exposed some issues with the way SQLite wrapped GRDB. SQLite was wrapping some writes in an unnecessary transaction. This caused issues because IMMEDIATE transactions immediately begin a write, meaning other writes will receive a SQLITE_BUSY error. Before applying the changes in this pull request, vacuuming and checkpointing tests failed when IMMEDIATE transactions were used.","shortMessageHtmlLink":"Use writeWithoutTransaction when appropriate (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2111067550\" data-permission-text=\"Title is private\" data-url=\"https://github.com/shareup/sqlite/issues/53\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/shareup/sqlite/pull/53/hovercard\" href=\"https://github.com/shareup/sqlite/pull/53\">#53</a>)"}},{"before":"fa79c785e0d8ce5f4a6f2b08f8c281a5e3261289","after":"892b15a9e89b48664c230e42f140a9a994861a3c","ref":"refs/heads/test-vacuum","pushedAt":"2024-02-01T14:44:01.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"},"commit":{"message":"Fix issues with immediate transactions","shortMessageHtmlLink":"Fix issues with immediate transactions"}},{"before":"b3de32e2c368a4bb294ce63cb044cf900db80de2","after":"fa79c785e0d8ce5f4a6f2b08f8c281a5e3261289","ref":"refs/heads/test-vacuum","pushedAt":"2024-02-01T13:29:20.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"},"commit":{"message":"Fix errors when running PRAGMA","shortMessageHtmlLink":"Fix errors when running PRAGMA"}},{"before":"fe0420d70e955026b0126bf995a8806fb0103d19","after":"b3de32e2c368a4bb294ce63cb044cf900db80de2","ref":"refs/heads/test-vacuum","pushedAt":"2024-01-31T22:22:39.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"},"commit":{"message":"Use GitHub runner","shortMessageHtmlLink":"Use GitHub runner"}},{"before":null,"after":"fe0420d70e955026b0126bf995a8806fb0103d19","ref":"refs/heads/test-vacuum","pushedAt":"2024-01-31T22:11:49.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"},"commit":{"message":"Use self-hosted runner","shortMessageHtmlLink":"Use self-hosted runner"}},{"before":"bf7941002246b188ff9cf82c91fbcde4f27d8eaf","after":null,"ref":"refs/heads/catalyst-fixes","pushedAt":"2024-01-30T22:27:24.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"}},{"before":"c7466eab47b2335055ef1c12cd411d18ee554aa2","after":"ed1923069f284f6d4f3ec230eb7ca3ea85fc0398","ref":"refs/heads/main","pushedAt":"2024-01-30T22:27:23.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"},"commit":{"message":"Catalyst fixes (#52)\n\n- Fall back to URL(filePath:directoryHint:) if URL(string:) fails\r\n- Use immediate transactions for writes https://github.com/groue/GRDB.swift/pull/1485","shortMessageHtmlLink":"Catalyst fixes (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2108903995\" data-permission-text=\"Title is private\" data-url=\"https://github.com/shareup/sqlite/issues/52\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/shareup/sqlite/pull/52/hovercard\" href=\"https://github.com/shareup/sqlite/pull/52\">#52</a>)"}},{"before":null,"after":"bf7941002246b188ff9cf82c91fbcde4f27d8eaf","ref":"refs/heads/catalyst-fixes","pushedAt":"2024-01-30T22:11:50.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"},"commit":{"message":"Use immediate transactions","shortMessageHtmlLink":"Use immediate transactions"}},{"before":"a2d387bafe0c97b37d32177c462bd36e11416638","after":"c7466eab47b2335055ef1c12cd411d18ee554aa2","ref":"refs/heads/main","pushedAt":"2024-01-15T19:17:37.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"},"commit":{"message":"Fix testInsertInvalidJSON","shortMessageHtmlLink":"Fix testInsertInvalidJSON"}},{"before":"2af481402d2102b3e42c41e03dd6f70f69e7cc9c","after":null,"ref":"refs/heads/vacuum-into-file","pushedAt":"2023-09-14T18:39:00.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"}},{"before":"28a7b34eafde462e4e710f7fce3201b2638db679","after":"a2d387bafe0c97b37d32177c462bd36e11416638","ref":"refs/heads/main","pushedAt":"2023-09-14T18:38:59.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"},"commit":{"message":"Add support for VACUUM INTO (#51)\n\n- Add support for VACUUM INTO\r\n- Update to Swift 5.9","shortMessageHtmlLink":"Add support for VACUUM INTO (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1897092521\" data-permission-text=\"Title is private\" data-url=\"https://github.com/shareup/sqlite/issues/51\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/shareup/sqlite/pull/51/hovercard\" href=\"https://github.com/shareup/sqlite/pull/51\">#51</a>)"}},{"before":"06f2bfb6ec966d365f6e8621ae8e323455768723","after":"2af481402d2102b3e42c41e03dd6f70f69e7cc9c","ref":"refs/heads/vacuum-into-file","pushedAt":"2023-09-14T18:32:29.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"},"commit":{"message":"Update to Swift 5.9","shortMessageHtmlLink":"Update to Swift 5.9"}},{"before":null,"after":"06f2bfb6ec966d365f6e8621ae8e323455768723","ref":"refs/heads/vacuum-into-file","pushedAt":"2023-09-14T18:25:23.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"},"commit":{"message":"Add support for VACUUM INTO","shortMessageHtmlLink":"Add support for VACUUM INTO"}},{"before":"cd1ce319fa6407f99dff810b65ca4333fe4a8ae8","after":null,"ref":"refs/heads/fix-priority-inversion","pushedAt":"2023-09-02T12:55:40.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"}},{"before":"bee5273b35a2be7e6a613cbb946bb23ac6f5e99a","after":"28a7b34eafde462e4e710f7fce3201b2638db679","ref":"refs/heads/main","pushedAt":"2023-09-02T12:55:39.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"},"commit":{"message":"Fix priority inversion (#50)\n\n* Upgrade GRDB\r\n* Fix priority inversion","shortMessageHtmlLink":"Fix priority inversion (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1878677597\" data-permission-text=\"Title is private\" data-url=\"https://github.com/shareup/sqlite/issues/50\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/shareup/sqlite/pull/50/hovercard\" href=\"https://github.com/shareup/sqlite/pull/50\">#50</a>)"}},{"before":null,"after":"cd1ce319fa6407f99dff810b65ca4333fe4a8ae8","ref":"refs/heads/fix-priority-inversion","pushedAt":"2023-09-02T12:50:24.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"},"commit":{"message":"Fix priority inversion","shortMessageHtmlLink":"Fix priority inversion"}},{"before":"6bad74c3f18bd6503c5d6e42f47602887ceb36ee","after":null,"ref":"refs/heads/update-combine-extensions","pushedAt":"2023-08-27T20:41:33.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"}},{"before":"cb078a3f4d3589e4eb49bc3137276eee0f8eaffb","after":"bee5273b35a2be7e6a613cbb946bb23ac6f5e99a","ref":"refs/heads/main","pushedAt":"2023-08-27T20:41:31.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"},"commit":{"message":"Update CombineExtensions (#49)","shortMessageHtmlLink":"Update CombineExtensions (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1868625735\" data-permission-text=\"Title is private\" data-url=\"https://github.com/shareup/sqlite/issues/49\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/shareup/sqlite/pull/49/hovercard\" href=\"https://github.com/shareup/sqlite/pull/49\">#49</a>)"}},{"before":null,"after":"6bad74c3f18bd6503c5d6e42f47602887ceb36ee","ref":"refs/heads/update-combine-extensions","pushedAt":"2023-08-27T20:38:30.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"},"commit":{"message":"Update CombineExtensions","shortMessageHtmlLink":"Update CombineExtensions"}},{"before":"7a5c7d4bb7212cca4e3722a0e3e260e0a2bd20dc","after":null,"ref":"refs/heads/update-grdb","pushedAt":"2023-08-27T16:13:15.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"}},{"before":"64ab2f89b52dd26108e8a0428b702ba1a966afef","after":"cb078a3f4d3589e4eb49bc3137276eee0f8eaffb","ref":"refs/heads/main","pushedAt":"2023-08-27T16:13:14.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"},"commit":{"message":"Update GRDB (#48)\n\n* Update to GRDB 6.17.0 https://github.com/groue/GRDB.swift/blob/master/CHANGELOG.md#6170\r\n* Resume the database on UIApplication.willEnterForegroundNotification","shortMessageHtmlLink":"Update GRDB (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1868544786\" data-permission-text=\"Title is private\" data-url=\"https://github.com/shareup/sqlite/issues/48\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/shareup/sqlite/pull/48/hovercard\" href=\"https://github.com/shareup/sqlite/pull/48\">#48</a>)"}},{"before":"1c6a5eadbc895b2ba61423a7ec7211032c3e24f7","after":"7a5c7d4bb7212cca4e3722a0e3e260e0a2bd20dc","ref":"refs/heads/update-grdb","pushedAt":"2023-08-27T16:09:10.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"},"commit":{"message":"Fix tests","shortMessageHtmlLink":"Fix tests"}},{"before":null,"after":"1c6a5eadbc895b2ba61423a7ec7211032c3e24f7","ref":"refs/heads/update-grdb","pushedAt":"2023-08-27T15:57:12.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"atdrendel","name":"Anthony Drendel","path":"/atdrendel","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/202402?s=80&v=4"},"commit":{"message":"Fix resume app notification","shortMessageHtmlLink":"Fix resume app notification"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAD9g6sIgA","startCursor":null,"endCursor":null}},"title":"Activity · shareup/sqlite"}