{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":140912432,"defaultBranch":"main","name":"sqlite-utils","ownerLogin":"simonw","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2018-07-14T03:21:46.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/9599?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1710476053.0","currentOid":""},"activityList":{"items":[{"before":"1d050dcdc7c8099108abd2987932a3d8d7bf55aa","after":"577078fe01da6d876edda6f3ccbd1b5d074aeb6e","ref":"refs/heads/main","pushedAt":"2024-04-10T03:34:42.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"},"commit":{"message":"ReadTheDocs formats: - pdf - epub","shortMessageHtmlLink":"ReadTheDocs formats: - pdf - epub"}},{"before":"1feb0c427124105fc90026bdcae470542a1cae1b","after":"1d050dcdc7c8099108abd2987932a3d8d7bf55aa","ref":"refs/heads/main","pushedAt":"2024-03-17T00:33:33.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"},"commit":{"message":"insert-files multiple --pk support, closes #621","shortMessageHtmlLink":"insert-files multiple --pk support, <span class=\"issue-keyword tooltipped tooltipped-se\" aria-label=\"This commit closes issue #621.\">closes</span> <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2190392911\" data-permission-text=\"Title is private\" data-url=\"https://github.com/simonw/sqlite-utils/issues/621\" data-hovercard-type=\"issue\" data-hovercard-url=\"/simonw/sqlite-utils/issues/621/hovercard\" href=\"https://github.com/simonw/sqlite-utils/issues/621\">#621</a>"}},{"before":"23be5be1dc94299b987f0f47eedda15fb45854f0","after":"1feb0c427124105fc90026bdcae470542a1cae1b","ref":"refs/heads/main","pushedAt":"2024-03-17T00:27:25.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"},"commit":{"message":"Docs for insert with multiple --pk, refs #621","shortMessageHtmlLink":"Docs for insert with multiple --pk, refs <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2190392911\" data-permission-text=\"Title is private\" data-url=\"https://github.com/simonw/sqlite-utils/issues/621\" data-hovercard-type=\"issue\" data-hovercard-url=\"/simonw/sqlite-utils/issues/621/hovercard\" href=\"https://github.com/simonw/sqlite-utils/issues/621\">#621</a>"}},{"before":"1dc5da3e5d62446900176ed8ff8619f988943c62","after":"23be5be1dc94299b987f0f47eedda15fb45854f0","ref":"refs/heads/main","pushedAt":"2024-03-17T00:05:42.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"},"commit":{"message":"create-table now supports multiple --pk, refs #620","shortMessageHtmlLink":"create-table now supports multiple --pk, refs <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2190379241\" data-permission-text=\"Title is private\" data-url=\"https://github.com/simonw/sqlite-utils/issues/620\" data-hovercard-type=\"issue\" data-hovercard-url=\"/simonw/sqlite-utils/issues/620/hovercard\" href=\"https://github.com/simonw/sqlite-utils/issues/620\">#620</a>"}},{"before":"142bb2b93715ade0aab5c40b496712d8ce55b054","after":"1dc5da3e5d62446900176ed8ff8619f988943c62","ref":"refs/heads/main","pushedAt":"2024-03-15T04:20:19.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"},"commit":{"message":"Use context managers for file writes in tests (#618)\n\nThis removes the need to explicitly close files\r\nand avoids accidental unclosed files","shortMessageHtmlLink":"Use context managers for file writes in tests (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2166137068\" data-permission-text=\"Title is private\" data-url=\"https://github.com/simonw/sqlite-utils/issues/618\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/simonw/sqlite-utils/pull/618/hovercard\" href=\"https://github.com/simonw/sqlite-utils/pull/618\">#618</a>)"}},{"before":"5bd7aec4d2aff4cc37af2c6bde9b30888944dd21","after":"142bb2b93715ade0aab5c40b496712d8ce55b054","ref":"refs/heads/main","pushedAt":"2024-03-15T04:15:23.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"},"commit":{"message":"Programming Language :: Python :: 3.13\n\nTested in Python 3.13 as of #619","shortMessageHtmlLink":"Programming Language :: Python :: 3.13"}},{"before":"ddf5ce15e6e77fce8673d45dd36e728b05d85494","after":null,"ref":"refs/heads/python-3.13","pushedAt":"2024-03-15T04:14:13.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"}},{"before":"17eb8184d2794dc4d05f096a45d1fbe0ad426055","after":"5bd7aec4d2aff4cc37af2c6bde9b30888944dd21","ref":"refs/heads/main","pushedAt":"2024-03-15T04:14:10.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"},"commit":{"message":"Test against Python 3.13 pre-release (#619)\n\n* Test against Python 3.13 pre-release\r\n\r\n* Skip tests for numpy on Python 3.13\r\n\r\nRefs https://github.com/simonw/sqlite-utils/pull/619#issuecomment-1998798451\r\n\r\n* Try to avoid Python 3.13 cog differences\r\n\r\n* Hide \\b characters in cli-reference\r\n\r\n* Fixed .rST warning","shortMessageHtmlLink":"Test against Python 3.13 pre-release (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2187564067\" data-permission-text=\"Title is private\" data-url=\"https://github.com/simonw/sqlite-utils/issues/619\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/simonw/sqlite-utils/pull/619/hovercard\" href=\"https://github.com/simonw/sqlite-utils/pull/619\">#619</a>)"}},{"before":"fd803d7043121f8618932c6c45888da60282ff5b","after":"ddf5ce15e6e77fce8673d45dd36e728b05d85494","ref":"refs/heads/python-3.13","pushedAt":"2024-03-15T04:06:32.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"},"commit":{"message":"Fixed .rST warning","shortMessageHtmlLink":"Fixed .rST warning"}},{"before":"995446bc944b2322f3feb707dc7f44e9cbc192be","after":"fd803d7043121f8618932c6c45888da60282ff5b","ref":"refs/heads/python-3.13","pushedAt":"2024-03-15T04:05:41.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"},"commit":{"message":"Hide \\b characters in cli-reference","shortMessageHtmlLink":"Hide \\b characters in cli-reference"}},{"before":"3ab780c39f5ce721336c024f5e2fd1dac9345dad","after":"995446bc944b2322f3feb707dc7f44e9cbc192be","ref":"refs/heads/python-3.13","pushedAt":"2024-03-15T02:28:07.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"},"commit":{"message":"Try to avoid Python 3.13 cog differences","shortMessageHtmlLink":"Try to avoid Python 3.13 cog differences"}},{"before":"4241d478744ed6e175f0e5414f123b1eab164926","after":"3ab780c39f5ce721336c024f5e2fd1dac9345dad","ref":"refs/heads/python-3.13","pushedAt":"2024-03-15T01:59:48.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"},"commit":{"message":"Skip tests for numpy on Python 3.13\n\nRefs https://github.com/simonw/sqlite-utils/pull/619#issuecomment-1998798451","shortMessageHtmlLink":"Skip tests for numpy on Python 3.13"}},{"before":null,"after":"4241d478744ed6e175f0e5414f123b1eab164926","ref":"refs/heads/python-3.13","pushedAt":"2024-03-15T01:47:11.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"},"commit":{"message":"Test against Python 3.13 pre-release","shortMessageHtmlLink":"Test against Python 3.13 pre-release"}},{"before":"d536b3f0d2aeebc8cc3b57d4ce5e79c5194c8f04","after":null,"ref":"refs/heads/macos-14","pushedAt":"2024-01-31T03:02:43.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"}},{"before":"70cc0c91abb4336686bf1307884c65e1bf564a48","after":"17eb8184d2794dc4d05f096a45d1fbe0ad426055","ref":"refs/heads/main","pushedAt":"2024-01-31T03:02:37.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"},"commit":{"message":"Run tests against ARM macos-14 (#615)\n\n* Run tests against ARM macos-14\r\n\r\nhttps://github.blog/changelog/2024-01-30-github-actions-introducing-the-new-m1-macos-runner-available-to-open-source/\r\n\r\n* Skip Python 3.8 and 3.9 on macos-14","shortMessageHtmlLink":"Run tests against ARM macos-14 (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2109139132\" data-permission-text=\"Title is private\" data-url=\"https://github.com/simonw/sqlite-utils/issues/615\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/simonw/sqlite-utils/pull/615/hovercard\" href=\"https://github.com/simonw/sqlite-utils/pull/615\">#615</a>)"}},{"before":"dbda76d6ed3fc917c47dbb48e5fe12726ddf4bd4","after":"d536b3f0d2aeebc8cc3b57d4ce5e79c5194c8f04","ref":"refs/heads/macos-14","pushedAt":"2024-01-31T02:50:01.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"},"commit":{"message":"Skip Python 3.8 and 3.9 on macos-14","shortMessageHtmlLink":"Skip Python 3.8 and 3.9 on macos-14"}},{"before":"976cf81dc93aacce3122315f7fa97b33c138f796","after":"dbda76d6ed3fc917c47dbb48e5fe12726ddf4bd4","ref":"refs/heads/macos-14","pushedAt":"2024-01-31T02:38:24.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"},"commit":{"message":"Drop support for Python 3.7\n\n* Drop support for Python 3.7, closes #616\r\n* Bumped versions on a whole lot of GitHub Actions","shortMessageHtmlLink":"Drop support for Python 3.7"}},{"before":"7ea93af5896d830d001157fd7b1d2ebe1a7aee96","after":null,"ref":"refs/heads/drop-3.7","pushedAt":"2024-01-31T02:37:41.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"}},{"before":"ff57a97482da645163dc58d8c3cc55ada335882a","after":"70cc0c91abb4336686bf1307884c65e1bf564a48","ref":"refs/heads/main","pushedAt":"2024-01-31T02:37:38.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"},"commit":{"message":"Drop support for Python 3.7\n\n* Drop support for Python 3.7, closes #616\r\n* Bumped versions on a whole lot of GitHub Actions","shortMessageHtmlLink":"Drop support for Python 3.7"}},{"before":"c304fc3891b7a5ddddca14dbc52d7cc612dbe1b6","after":"7ea93af5896d830d001157fd7b1d2ebe1a7aee96","ref":"refs/heads/drop-3.7","pushedAt":"2024-01-31T02:26:58.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"},"commit":{"message":"Back to codecov/codecov-action@v1","shortMessageHtmlLink":"Back to codecov/codecov-action@v1"}},{"before":null,"after":"c304fc3891b7a5ddddca14dbc52d7cc612dbe1b6","ref":"refs/heads/drop-3.7","pushedAt":"2024-01-31T02:25:07.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"},"commit":{"message":"Drop support for Python 3.7, refs #616","shortMessageHtmlLink":"Drop support for Python 3.7, refs <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2109153423\" data-permission-text=\"Title is private\" data-url=\"https://github.com/simonw/sqlite-utils/issues/616\" data-hovercard-type=\"issue\" data-hovercard-url=\"/simonw/sqlite-utils/issues/616/hovercard\" href=\"https://github.com/simonw/sqlite-utils/issues/616\">#616</a>"}},{"before":"ea0de7ec0ca7b8a7a03594f0a707f6b74887a04e","after":"976cf81dc93aacce3122315f7fa97b33c138f796","ref":"refs/heads/macos-14","pushedAt":"2024-01-31T02:19:28.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"},"commit":{"message":"Upgrade to latest Black","shortMessageHtmlLink":"Upgrade to latest Black"}},{"before":"b7def00b8c743a9dae592cd319d883e4b13bc931","after":"ff57a97482da645163dc58d8c3cc55ada335882a","ref":"refs/heads/main","pushedAt":"2024-01-31T02:18:55.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"},"commit":{"message":"Upgrade to latest Black","shortMessageHtmlLink":"Upgrade to latest Black"}},{"before":null,"after":"ea0de7ec0ca7b8a7a03594f0a707f6b74887a04e","ref":"refs/heads/macos-14","pushedAt":"2024-01-31T02:03:20.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"},"commit":{"message":"Run tests against ARM macos-14\n\nhttps://github.blog/changelog/2024-01-30-github-actions-introducing-the-new-m1-macos-runner-available-to-open-source/","shortMessageHtmlLink":"Run tests against ARM macos-14"}},{"before":"885a0b321d8daddc2e4e2e5cc991591df9abc44c","after":"b7def00b8c743a9dae592cd319d883e4b13bc931","ref":"refs/heads/main","pushedAt":"2024-01-14T17:28:25.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"},"commit":{"message":"More consistent indentation","shortMessageHtmlLink":"More consistent indentation"}},{"before":"f29189a3ddb3871bf7c46897b4fb76f4e8bbf65e","after":"885a0b321d8daddc2e4e2e5cc991591df9abc44c","ref":"refs/heads/main","pushedAt":"2023-12-08T05:31:17.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"},"commit":{"message":"Release 3.36\n\nRefs #344, #604, #606","shortMessageHtmlLink":"Release 3.36"}},{"before":"1500c19bd0f31b2e7f28a5ec2d7bfa133a2e4d4c","after":"f29189a3ddb3871bf7c46897b4fb76f4e8bbf65e","ref":"refs/heads/main","pushedAt":"2023-12-08T05:22:38.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"},"commit":{"message":"db.supports_strict docs, closes #344","shortMessageHtmlLink":"db.supports_strict docs, <span class=\"issue-keyword tooltipped tooltipped-se\" aria-label=\"This commit closes issue #344.\">closes</span> <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1066474200\" data-permission-text=\"Title is private\" data-url=\"https://github.com/simonw/sqlite-utils/issues/344\" data-hovercard-type=\"issue\" data-hovercard-url=\"/simonw/sqlite-utils/issues/344/hovercard\" href=\"https://github.com/simonw/sqlite-utils/issues/344\">#344</a>"}},{"before":"88bd37220593f46ad2221601d6724dd0198400ad","after":"1500c19bd0f31b2e7f28a5ec2d7bfa133a2e4d4c","ref":"refs/heads/main","pushedAt":"2023-12-08T05:05:27.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"},"commit":{"message":"Add more STRICT table support (#604)\n\n* Add more STRICT table support per https://github.com/simonw/sqlite-utils/issues/344#issuecomment-982014776.\r\n* Make `table.transform()` preserve STRICT mode.\r\n* Fix mypy failures in PR #604\r\n* Link to SQLITE strict page in a few places","shortMessageHtmlLink":"Add more STRICT table support (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2001006157\" data-permission-text=\"Title is private\" data-url=\"https://github.com/simonw/sqlite-utils/issues/604\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/simonw/sqlite-utils/pull/604/hovercard\" href=\"https://github.com/simonw/sqlite-utils/pull/604\">#604</a>)"}},{"before":"9286c1ba432e890b1bb4b2a1f847b15364c1fa18","after":"88bd37220593f46ad2221601d6724dd0198400ad","ref":"refs/heads/main","pushedAt":"2023-12-06T18:49:31.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"},"commit":{"message":"str, int, bytes aliases for column types, closes #606","shortMessageHtmlLink":"str, int, bytes aliases for column types, <span class=\"issue-keyword tooltipped tooltipped-se\" aria-label=\"This commit closes issue #606.\">closes</span> <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2029161033\" data-permission-text=\"Title is private\" data-url=\"https://github.com/simonw/sqlite-utils/issues/606\" data-hovercard-type=\"issue\" data-hovercard-url=\"/simonw/sqlite-utils/issues/606/hovercard\" href=\"https://github.com/simonw/sqlite-utils/issues/606\">#606</a>"}},{"before":"c64c7d1b8caec172c87a73154cc4da90fd3fae3b","after":"9286c1ba432e890b1bb4b2a1f847b15364c1fa18","ref":"refs/heads/main","pushedAt":"2023-11-04T03:55:19.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"simonw","name":"Simon Willison","path":"/simonw","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9599?s=80&v=4"},"commit":{"message":"Fixed some markup bugs","shortMessageHtmlLink":"Fixed some markup bugs"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAELKBvqgA","startCursor":null,"endCursor":null}},"title":"Activity · simonw/sqlite-utils"}