{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":375093206,"defaultBranch":"main","name":"sqlite","ownerLogin":"tailscale","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2021-06-08T17:33:14.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/48932923?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1716592824.0","currentOid":""},"activityList":{"items":[{"before":"e8fd452cddaa1c9f20a2a61b83974b8e73f66237","after":"2ca00fd055673907b14dda55f5ee80a29a90573f","ref":"refs/heads/bradfitz/jsonb","pushedAt":"2024-05-25T18:55:28.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"bradfitz","name":"Brad Fitzpatrick","path":"/bradfitz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2621?s=80&v=4"},"commit":{"message":"jsonb: add package for JSONB parsing","shortMessageHtmlLink":"jsonb: add package for JSONB parsing"}},{"before":null,"after":"387869073682256e5248216880941d191af2b6ef","ref":"refs/heads/raggi/enable-memory-temp","pushedAt":"2024-05-24T23:20:24.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"raggi","name":"James Tucker","path":"/raggi","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/348?s=80&v=4"},"commit":{"message":"cgosqlite: set SQLITE_TEMP_STORE=1\n\nSQLITE_TEMP_STORE=1 allows PRAGMA temp_store = MEMORY, while keeping\ntemporary files as the default behavior for temporary storage.\n\nThis can be used to accelerate some migrations, when building an\nin-memory temporary btree to use in a later correlated subquery is\nfaster than the query planner would normally do things, for example when\noptimizing locality or btree operation order.","shortMessageHtmlLink":"cgosqlite: set SQLITE_TEMP_STORE=1"}},{"before":"53dd251222c40783e177ff0777a05c8e325d0a85","after":"408f95fb27e945c58b13e6955e789db3d186a718","ref":"refs/heads/raggi/c-cleanup","pushedAt":"2024-05-24T23:17:19.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"raggi","name":"James Tucker","path":"/raggi","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/348?s=80&v=4"},"commit":{"message":"cgosqlite: cleanup the import layout some more","shortMessageHtmlLink":"cgosqlite: cleanup the import layout some more"}},{"before":null,"after":"53dd251222c40783e177ff0777a05c8e325d0a85","ref":"refs/heads/raggi/c-cleanup","pushedAt":"2024-05-24T22:55:45.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"raggi","name":"James Tucker","path":"/raggi","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/348?s=80&v=4"},"commit":{"message":"cgosqlite: cleanup the import layout some more","shortMessageHtmlLink":"cgosqlite: cleanup the import layout some more"}},{"before":"a2f4638cc4490d8c520f58a7caeebc529ce84c98","after":"e8fd452cddaa1c9f20a2a61b83974b8e73f66237","ref":"refs/heads/bradfitz/jsonb","pushedAt":"2024-05-24T19:20:45.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"bradfitz","name":"Brad Fitzpatrick","path":"/bradfitz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2621?s=80&v=4"},"commit":{"message":"jsonb: add package for JSONB parsing","shortMessageHtmlLink":"jsonb: add package for JSONB parsing"}},{"before":null,"after":"a2f4638cc4490d8c520f58a7caeebc529ce84c98","ref":"refs/heads/bradfitz/jsonb","pushedAt":"2024-05-24T13:46:30.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"bradfitz","name":"Brad Fitzpatrick","path":"/bradfitz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2621?s=80&v=4"},"commit":{"message":"jsonb: add package for JSONB parsing","shortMessageHtmlLink":"jsonb: add package for JSONB parsing"}},{"before":"17576186fefbe3fafdb34a4a47fcf14b9d0e5bec","after":"99c0716c0f74afbfdcd13d9c451e1ee7983a8d78","ref":"refs/heads/main","pushedAt":"2024-05-23T15:30:07.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"bradfitz","name":"Brad Fitzpatrick","path":"/bradfitz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2621?s=80&v=4"},"commit":{"message":"sqlstats: use Go 1.19 atomics, round MeanDuration more\n\nAnd split the QueryStats type into an internal accounting half (with\nthe atomics) and a public half (with natural types).\n\nUpdates tailscale/tailscale#5210\n\nSigned-off-by: Brad Fitzpatrick <bradfitz@tailscale.com>","shortMessageHtmlLink":"sqlstats: use Go 1.19 atomics, round MeanDuration more"}},{"before":null,"after":"6a0a95061d623782a790bb2aca30dc03c9c776f3","ref":"refs/heads/bradfitz/mean","pushedAt":"2024-05-23T14:30:18.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"bradfitz","name":"Brad Fitzpatrick","path":"/bradfitz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2621?s=80&v=4"},"commit":{"message":"sqlstats: use Go 1.19 atomics, round MeanDuration more\n\nAnd split the QueryStats type into an internal accounting half (with\nthe atomics) and a public half (with natural types).\n\nUpdates tailscale/tailscale#5210\n\nSigned-off-by: Brad Fitzpatrick <bradfitz@tailscale.com>","shortMessageHtmlLink":"sqlstats: use Go 1.19 atomics, round MeanDuration more"}},{"before":"00a242273d13bf54096cb9a8e324ace741ab15e8","after":null,"ref":"refs/heads/raggi/bump-sqlite","pushedAt":"2024-05-21T19:44:05.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"raggi","name":"James Tucker","path":"/raggi","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/348?s=80&v=4"}},{"before":"16551f200e90167c5f4e8110f5e630f4dbaf628b","after":"17576186fefbe3fafdb34a4a47fcf14b9d0e5bec","ref":"refs/heads/main","pushedAt":"2024-05-21T19:44:01.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"raggi","name":"James Tucker","path":"/raggi","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/348?s=80&v=4"},"commit":{"message":"cgosqlite: update to SQLite 3.45.3\n\nThe 3.45 series has been out long enough now that the initial JSONB\nissues have shaken out, and fixes to some regressions in the 3.44\nseries.\n\nOf some interest are:\n- Fix a couple of obscure UAF errors and an obscure memory leak.\n- In partial index scans, if the WHERE clause implies a constant value for a table column, replace occurrences of that table column with the constant. This increases the likelihood of the partial index being a covering index.\n- JSONB types.","shortMessageHtmlLink":"cgosqlite: update to SQLite 3.45.3"}},{"before":null,"after":"00a242273d13bf54096cb9a8e324ace741ab15e8","ref":"refs/heads/raggi/bump-sqlite","pushedAt":"2024-05-21T00:00:03.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"raggi","name":"James Tucker","path":"/raggi","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/348?s=80&v=4"},"commit":{"message":"cgosqlite: update to SQLite 3.45.3\n\nThe 3.45 series has been out long enough now that the initial JSONB\nissues have shaken out, and fixes to some regressions in the 3.44\nseries.\n\nOf some interest are:\n- Fix a couple of obscure UAF errors and an obscure memory leak.\n- In partial index scans, if the WHERE clause implies a constant value for a table column, replace occurrences of that table column with the constant. This increases the likelihood of the partial index being a covering index.\n- JSONB types.","shortMessageHtmlLink":"cgosqlite: update to SQLite 3.45.3"}},{"before":null,"after":"c667cbe57c66df1df0bf3a03066858e9e213fac6","ref":"refs/heads/raggi/more-faster-intern","pushedAt":"2024-05-15T18:13:03.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"raggi","name":"James Tucker","path":"/raggi","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/348?s=80&v=4"},"commit":{"message":"cgosqlite: add more string interns, and optimize\n\nThis adds string interning to column names, table names and database\nnames, as well as optimizing the decltype interning code path to use\nruntime.findnull rather than C.strlen that must cross cgo again.\n\nWe don't yet know if this is effective in practice, and should test this\nbefore integrating.","shortMessageHtmlLink":"cgosqlite: add more string interns, and optimize"}},{"before":"a76c0c528324966481ab847a51156b097ff769c5","after":null,"ref":"refs/heads/raggi/darwin-source","pushedAt":"2024-05-14T00:15:19.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"raggi","name":"James Tucker","path":"/raggi","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/348?s=80&v=4"}},{"before":"9961a0c91e84cc1c2f9b4f104975a856f2c1b8f0","after":"16551f200e90167c5f4e8110f5e630f4dbaf628b","ref":"refs/heads/main","pushedAt":"2024-05-14T00:15:15.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"raggi","name":"James Tucker","path":"/raggi","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/348?s=80&v=4"},"commit":{"message":".github: add a macOS workflow\n\nThis will catch regressions such as the one introduced in #95.\n\nUpdates tailscale/corp#19964","shortMessageHtmlLink":".github: add a macOS workflow"}},{"before":"04eb05a390b8a94d023ad9e59fe068a09c905b5f","after":"a76c0c528324966481ab847a51156b097ff769c5","ref":"refs/heads/raggi/darwin-source","pushedAt":"2024-05-14T00:01:32.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"raggi","name":"James Tucker","path":"/raggi","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/348?s=80&v=4"},"commit":{"message":".github: add a macOS workflow\n\nThis will catch regressions such as the one introduced in #95.\n\nUpdates tailscale/corp#19964","shortMessageHtmlLink":".github: add a macOS workflow"}},{"before":null,"after":"04eb05a390b8a94d023ad9e59fe068a09c905b5f","ref":"refs/heads/raggi/darwin-source","pushedAt":"2024-05-13T23:57:02.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"raggi","name":"James Tucker","path":"/raggi","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/348?s=80&v=4"},"commit":{"message":"cgosqlite: add DARWIN_C_SOURCE for flock on macOS\n\nAfter adding _XOPEN_SOURCE to ensure that gcc / glibc will have\nclock_gettime defined, we trigger the Darwin toolchain behavior of\nexcluding non-POSIX extensions, so macOS' flock disappeared. Adding\nDARWIN_C_SOURCE restores access to flock on macOS.\n\nUpdates tailscale/corp#19964","shortMessageHtmlLink":"cgosqlite: add DARWIN_C_SOURCE for flock on macOS"}},{"before":"9bde6c01b8573facd2a4be12ae585c339aaac447","after":null,"ref":"refs/heads/crawshaw/testsqlite","pushedAt":"2024-05-13T22:45:21.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"raggi","name":"James Tucker","path":"/raggi","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/348?s=80&v=4"}},{"before":"3a8bdde6eec170f40b53336011f7d600bf3746d7","after":"9961a0c91e84cc1c2f9b4f104975a856f2c1b8f0","ref":"refs/heads/main","pushedAt":"2024-05-13T22:45:18.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"raggi","name":"James Tucker","path":"/raggi","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/348?s=80&v=4"},"commit":{"message":".github: add tests to CI","shortMessageHtmlLink":".github: add tests to CI"}},{"before":"46d292db41a131fa9d4cb2049ef9cd67f41634d2","after":null,"ref":"refs/heads/raggi/posix","pushedAt":"2024-05-13T22:45:00.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"raggi","name":"James Tucker","path":"/raggi","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/348?s=80&v=4"}},{"before":"b529d1db934c81dbc6009706bc8418036fb1591b","after":"3a8bdde6eec170f40b53336011f7d600bf3746d7","ref":"refs/heads/main","pushedAt":"2024-05-13T22:44:57.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"raggi","name":"James Tucker","path":"/raggi","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/348?s=80&v=4"},"commit":{"message":"cgosqlite: use POSIX 2014 explicitly\n\nUnless this is defined a strict compiler will error with an implicit\ndefinition error at least, or at worst will not even find a definition\nas one may optionally not be provided at all:\n\n```\n  ./cgosqlite.h: In function 'monotonic_clock_gettime':\n  ./cgosqlite.h:52:9: error: implicit declaration of function 'clock_gettime' [-Wimplicit-function-declaration]\n    52 |         clock_gettime(CLOCK_MONOTONIC, t);\n        |         ^~~~~~~~~~~~~\n```\n\nThis resolves an earlier TODO, where crawshaw had observed\nCLOCK_MONOTONIC not being defined.\n\nAs a very minor change: use the system import syntax for system imports.","shortMessageHtmlLink":"cgosqlite: use POSIX 2014 explicitly"}},{"before":"3c19dab0a7d8437a4024e6960ede71d3468af675","after":"9bde6c01b8573facd2a4be12ae585c339aaac447","ref":"refs/heads/crawshaw/testsqlite","pushedAt":"2024-05-13T22:22:36.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"raggi","name":"James Tucker","path":"/raggi","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/348?s=80&v=4"},"commit":{"message":".github: add tests to CI","shortMessageHtmlLink":".github: add tests to CI"}},{"before":"233924670cbe39510a9a85dd49779ed62388e519","after":"46d292db41a131fa9d4cb2049ef9cd67f41634d2","ref":"refs/heads/raggi/posix","pushedAt":"2024-05-13T22:19:02.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"raggi","name":"James Tucker","path":"/raggi","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/348?s=80&v=4"},"commit":{"message":"cgosqlite: use POSIX 2014 explicitly\n\nUnless this is defined a strict compiler will error with an implicit\ndefinition error at least, or at worst will not even find a definition\nas one may optionally not be provided at all:\n\n```\n  ./cgosqlite.h: In function 'monotonic_clock_gettime':\n  ./cgosqlite.h:52:9: error: implicit declaration of function 'clock_gettime' [-Wimplicit-function-declaration]\n    52 |         clock_gettime(CLOCK_MONOTONIC, t);\n        |         ^~~~~~~~~~~~~\n```\n\nThis resolves an earlier TODO, where crawshaw had observed\nCLOCK_MONOTONIC not being defined.\n\nAs a very minor change: use the system import syntax for system imports.","shortMessageHtmlLink":"cgosqlite: use POSIX 2014 explicitly"}},{"before":"a74666e44146f6145b0790459f45d6c0b9f53e29","after":"233924670cbe39510a9a85dd49779ed62388e519","ref":"refs/heads/raggi/posix","pushedAt":"2024-05-13T22:16:55.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"raggi","name":"James Tucker","path":"/raggi","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/348?s=80&v=4"},"commit":{"message":"cgosqlite: use POSIX 2014 explicitly\n\nUnless this is defined a strict compiler will error with an implicit\ndefinition error at least, or at worst will not even find a definition\nas one may optionally not be provided at all:\n\n```\n  ./cgosqlite.h: In function 'monotonic_clock_gettime':\n  ./cgosqlite.h:52:9: error: implicit declaration of function 'clock_gettime' [-Wimplicit-function-declaration]\n    52 |         clock_gettime(CLOCK_MONOTONIC, t);\n        |         ^~~~~~~~~~~~~\n```\n\nThis resolves an earlier TODO, where crawshaw had observed\nCLOCK_MONOTONIC not being defined.\n\nAs a very minor change: use the system import syntax for system imports.","shortMessageHtmlLink":"cgosqlite: use POSIX 2014 explicitly"}},{"before":null,"after":"a74666e44146f6145b0790459f45d6c0b9f53e29","ref":"refs/heads/raggi/posix","pushedAt":"2024-05-13T22:05:43.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"raggi","name":"James Tucker","path":"/raggi","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/348?s=80&v=4"},"commit":{"message":"cgosqlite: use POSIX 2014 explicitly\n\nUnless this is defined a strict compiler will error with an implicit\ndefinition error at least, or at worst will not even find a definition\nas one may optionally not be provided at all:\n\n```\n  ./cgosqlite.h: In function 'monotonic_clock_gettime':\n  ./cgosqlite.h:52:9: error: implicit declaration of function 'clock_gettime' [-Wimplicit-function-declaration]\n    52 |         clock_gettime(CLOCK_MONOTONIC, t);\n        |         ^~~~~~~~~~~~~\n```\n\nAs a very minor change: use the system import syntax for system imports.","shortMessageHtmlLink":"cgosqlite: use POSIX 2014 explicitly"}},{"before":"df646f0351bd497e49f796679981d60ad8ceac80","after":null,"ref":"refs/heads/raggi/clock-gettime","pushedAt":"2024-04-24T23:42:38.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"raggi","name":"James Tucker","path":"/raggi","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/348?s=80&v=4"}},{"before":"aacc0a6538f9cb9e5c1ad7afa0afe6ba6d7dda7a","after":"b529d1db934c81dbc6009706bc8418036fb1591b","ref":"refs/heads/main","pushedAt":"2024-04-24T23:42:35.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"raggi","name":"James Tucker","path":"/raggi","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/348?s=80&v=4"},"commit":{"message":"Merge pull request #94 from tailscale/raggi/clock-gettime\n\ncgosqlite: include time.h for clock_gettime","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2262215259\" data-permission-text=\"Title is private\" data-url=\"https://github.com/tailscale/sqlite/issues/94\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/tailscale/sqlite/pull/94/hovercard\" href=\"https://github.com/tailscale/sqlite/pull/94\">#94</a> from tailscale/raggi/clock-gettime"}},{"before":null,"after":"df646f0351bd497e49f796679981d60ad8ceac80","ref":"refs/heads/raggi/clock-gettime","pushedAt":"2024-04-24T21:25:44.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"raggi","name":"James Tucker","path":"/raggi","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/348?s=80&v=4"},"commit":{"message":"cgosqlite: include time.h for clock_gettime\n\nThis has been missing for some time, but my compiler driver got stricter\nand started failing on this.","shortMessageHtmlLink":"cgosqlite: include time.h for clock_gettime"}},{"before":"46fb9eb44355dd308769349c417c544ca4bc02c3","after":"aacc0a6538f9cb9e5c1ad7afa0afe6ba6d7dda7a","ref":"refs/heads/main","pushedAt":"2024-03-09T17:02:17.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"bradfitz","name":"Brad Fitzpatrick","path":"/bradfitz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/2621?s=80&v=4"},"commit":{"message":"sqlite: fix short time parsing\n\nSigned-off-by: Ilya Mateyko <me@astrophena.name>","shortMessageHtmlLink":"sqlite: fix short time parsing"}},{"before":"0c357e70ccf48c000a0874a7015f6b05f986b3b3","after":null,"ref":"refs/heads/icio/racey-reset","pushedAt":"2024-01-29T10:18:43.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"icio","name":"Paul Scott","path":"/icio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/408401?s=80&v=4"}},{"before":"c3059d39980ac9762bcfbd2bde89c9db2056084a","after":"46fb9eb44355dd308769349c417c544ca4bc02c3","ref":"refs/heads/main","pushedAt":"2024-01-29T10:18:38.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"icio","name":"Paul Scott","path":"/icio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/408401?s=80&v=4"},"commit":{"message":"sqlstats: fix Tracer.Reset data races (#92)","shortMessageHtmlLink":"sqlstats: fix Tracer.Reset data races (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2096002263\" data-permission-text=\"Title is private\" data-url=\"https://github.com/tailscale/sqlite/issues/92\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/tailscale/sqlite/pull/92/hovercard\" href=\"https://github.com/tailscale/sqlite/pull/92\">#92</a>)"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEU9YqSQA","startCursor":null,"endCursor":null}},"title":"Activity · tailscale/sqlite"}