{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":188725184,"defaultBranch":"master","name":"postgrest","ownerLogin":"robx","currentUserCanPush":false,"isFork":true,"isEmpty":false,"createdAt":"2019-05-26T19:50:25.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/132113?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1697811159.0","currentOid":""},"activityList":{"items":[{"before":"ceffa37545aca7cc47b11ff08a326081626ae122","after":"cdedf2626b764294f992187867713d9edd62f83d","ref":"refs/heads/readreplica","pushedAt":"2023-10-27T12:30:00.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"robx","name":"Robert","path":"/robx","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/132113?s=80&v=4"},"commit":{"message":"shim the missing replica in integration tests","shortMessageHtmlLink":"shim the missing replica in integration tests"}},{"before":"e424a73d9a96280f291d092a9eb0a7167fe6748e","after":"ceffa37545aca7cc47b11ff08a326081626ae122","ref":"refs/heads/readreplica","pushedAt":"2023-10-27T12:25:09.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robx","name":"Robert","path":"/robx","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/132113?s=80&v=4"},"commit":{"message":"shim the missing replica in integration tests","shortMessageHtmlLink":"shim the missing replica in integration tests"}},{"before":"b8c0e60be51e78e6207d79f259e104834ccf03c4","after":"e424a73d9a96280f291d092a9eb0a7167fe6748e","ref":"refs/heads/readreplica","pushedAt":"2023-10-27T12:13:19.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"robx","name":"Robert","path":"/robx","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/132113?s=80&v=4"},"commit":{"message":"Implement db-uri-read-replicas\n\n- takes a list of URIs to use as read replicas\n- queries are routed based on the transaction mode,\n  with read-mode queries going to the read replicas\n  if any are configured\n- we configure one pool per database uri, all with\n  the same configuration\n- which read replica to use is chosen randomly\n- if you want the master to also be used for read-only\n  queries, put it in both db-uri and db-uri-read-replicas\n\nTest coverage is spotty and work-in-progress. It requires a\nreplicating setup which is not automated. With a locally set\nup read replica, the integration test suite should pass as\nfollows:\n\nPGHOSTREP='/tmp' PGPORTREP=5433 PGHOST='/tmp' PGPORT=5432 \\\n  postgrest-test-io\n\nYou can pass '-k test_readonly' for replication-specific tests.","shortMessageHtmlLink":"Implement db-uri-read-replicas"}},{"before":"a187429a45f5a85864475e71abc41524369e56d6","after":"b8c0e60be51e78e6207d79f259e104834ccf03c4","ref":"refs/heads/readreplica","pushedAt":"2023-10-27T12:12:03.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robx","name":"Robert","path":"/robx","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/132113?s=80&v=4"},"commit":{"message":"back out cabal file change","shortMessageHtmlLink":"back out cabal file change"}},{"before":"aff556549386aa788b6f99ccadfddf11ce4fa55e","after":"a187429a45f5a85864475e71abc41524369e56d6","ref":"refs/heads/readreplica","pushedAt":"2023-10-27T12:05:39.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robx","name":"Robert","path":"/robx","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/132113?s=80&v=4"},"commit":{"message":"backout read_only_session()\n\nthis was a failed attempt to simulate a read-only database connection\nin tests","shortMessageHtmlLink":"backout read_only_session()"}},{"before":null,"after":"aff556549386aa788b6f99ccadfddf11ce4fa55e","ref":"refs/heads/readreplica","pushedAt":"2023-10-20T14:12:39.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"robx","name":"Robert","path":"/robx","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/132113?s=80&v=4"},"commit":{"message":"Implement db-uri-read-replicas\n\n- takes a list of URIs to use as read replicas\n- queries are routed based on the transaction mode,\n  with read-mode queries going to the read replicas\n  if any are configured\n- we configure one pool per database uri, all with\n  the same configuration\n- which read replica to use is chosen randomly\n- if you want the master to also be used for read-only\n  queries, put it in both db-uri and db-uri-read-replicas\n\nTest coverage is spotty and work-in-progress. It requires a\nreplicating setup which is not automated. With a locally set\nup read replica, the integration test suite should pass as\nfollows:\n\nPGHOSTREP='/tmp' PGPORTREP=5433 PGHOST='/tmp' PGPORT=5432 \\\n  postgrest-test-io\n\nYou can pass '-k test_readonly' for replication-specific tests.","shortMessageHtmlLink":"Implement db-uri-read-replicas"}},{"before":null,"after":"983e53882fc9ee1f0ab6efd7c6aa1f5eeed3f594","ref":"refs/heads/show-snippet","pushedAt":"2023-05-26T12:12:17.809Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"robx","name":"Robert","path":"/robx","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/132113?s=80&v=4"},"commit":{"message":"render snippet to bytestring","shortMessageHtmlLink":"render snippet to bytestring"}},{"before":"1c50ba87936049a6ebbdc3d22eee0eafeecf4cf0","after":null,"ref":"refs/heads/bump-pool","pushedAt":"2023-05-16T21:00:43.970Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"robx","name":"Robert","path":"/robx","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/132113?s=80&v=4"}},{"before":"9ee9b33abbe816d185997c2673374f6bac9db274","after":"1c50ba87936049a6ebbdc3d22eee0eafeecf4cf0","ref":"refs/heads/bump-pool","pushedAt":"2023-05-16T16:16:34.838Z","pushType":"push","commitsCount":1,"pusher":{"login":"robx","name":"Robert","path":"/robx","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/132113?s=80&v=4"},"commit":{"message":"use hasql-notifications-0.2.5, remove allow-newer","shortMessageHtmlLink":"use hasql-notifications-0.2.5, remove allow-newer"}},{"before":"aca062fe364e44537548e533b0189350ef4aa57e","after":"9ee9b33abbe816d185997c2673374f6bac9db274","ref":"refs/heads/bump-pool","pushedAt":"2023-05-16T12:50:09.788Z","pushType":"push","commitsCount":1,"pusher":{"login":"robx","name":"Robert","path":"/robx","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/132113?s=80&v=4"},"commit":{"message":"lower idle timeout default to 30s","shortMessageHtmlLink":"lower idle timeout default to 30s"}},{"before":"9a3f4426d7bf6520246044c22332c3e91d48479e","after":"aca062fe364e44537548e533b0189350ef4aa57e","ref":"refs/heads/bump-pool","pushedAt":"2023-05-15T11:09:48.765Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"robx","name":"Robert","path":"/robx","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/132113?s=80&v=4"},"commit":{"message":"feat: use hasql-pool-0.10, add db-pool-max-idletime\n\n- new option db-pool-max-idletime limits the maximal idle time of a\n  postgresql connection, defaults to 10 minutes\n- this essentially restores the db-pool-timeout option from versions\n  <=10, with more specific name\n- temporary overrides to allow building hasql-notifications with\n  hasql-pool-0.10","shortMessageHtmlLink":"feat: use hasql-pool-0.10, add db-pool-max-idletime"}},{"before":null,"after":"9a3f4426d7bf6520246044c22332c3e91d48479e","ref":"refs/heads/bump-pool","pushedAt":"2023-05-15T11:08:33.358Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"robx","name":"Robert","path":"/robx","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/132113?s=80&v=4"},"commit":{"message":"feat: use hasql-pool-0.10, add db-pool-max-idletime\n\n- new option db-pool-max-idletime limits the maximal idle time of a\n  postgresql connection, defaults to 10 minutes\n- this essentially restores the db-pool-timeout option from versions\n  <=10, with more specific name\n- temporary overrides to allow building hasql-notifications with\n  hasql-pool-0.10","shortMessageHtmlLink":"feat: use hasql-pool-0.10, add db-pool-max-idletime"}},{"before":"24b7defc5874846db287d87865f58b36178f6c6f","after":"33d7d26eb3daabbd2f715744678b21218eb0ebf1","ref":"refs/heads/pipeline","pushedAt":"2023-05-05T09:32:37.000Z","pushType":"push","commitsCount":3,"pusher":{"login":"robx","name":"Robert","path":"/robx","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/132113?s=80&v=4"},"commit":{"message":"fix import aliasing warning","shortMessageHtmlLink":"fix import aliasing warning"}},{"before":"e8d50d302c6af32185a43e1d2702f0a6b0d3b58b","after":"24b7defc5874846db287d87865f58b36178f6c6f","ref":"refs/heads/pipeline","pushedAt":"2023-05-03T10:19:21.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"robx","name":"Robert","path":"/robx","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/132113?s=80&v=4"},"commit":{"message":"use pipeline mode","shortMessageHtmlLink":"use pipeline mode"}},{"before":"09447c5c4e4997714fd4cd93b528bc3f3b639d47","after":null,"ref":"refs/heads/pool-lifetime","pushedAt":"2023-04-06T20:40:51.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"robx","name":"Robert","path":"/robx","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/132113?s=80&v=4"}},{"before":"fcca5f236dc9d9dbc7cbfc270417771251e3e2ab","after":"09447c5c4e4997714fd4cd93b528bc3f3b639d47","ref":"refs/heads/pool-lifetime","pushedAt":"2023-04-06T18:34:50.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"robx","name":"Robert","path":"/robx","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/132113?s=80&v=4"},"commit":{"message":"feat: use hasql-pool-0.9, add db-pool-max-lifetime (fixes #2638)\n\n- db-pool-acquisition-timeout is no longer optional, defaults to 10s\n- new option db-pool-max-lifetime limits the maximal lifetime of a\n  postgresql connection, defaults to 30m","shortMessageHtmlLink":"feat: use hasql-pool-0.9, add db-pool-max-lifetime (<span class=\"issue-keyword tooltipped tooltipped-se\" aria-label=\"This commit closes issue #2638.\">fixes</span> <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1560338937\" data-permission-text=\"Title is private\" data-url=\"https://github.com/PostgREST/postgrest/issues/2638\" data-hovercard-type=\"issue\" data-hovercard-url=\"/PostgREST/postgrest/issues/2638/hovercard\" href=\"https://github.com/PostgREST/postgrest/issues/2638\">PostgREST#2638</a>"}},{"before":"4491a373dfeb5e936b116f36a7729b27d2cfcc17","after":"fcca5f236dc9d9dbc7cbfc270417771251e3e2ab","ref":"refs/heads/pool-lifetime","pushedAt":"2023-04-06T18:33:01.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"robx","name":"Robert","path":"/robx","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/132113?s=80&v=4"},"commit":{"message":"feat: use hasql-pool-0.9, add db-pool-max-lifetime (fixes #2638)\n\n- db-pool-acquisition-timeout is no longer optional, defaults to 10s\n- new option db-pool-max-lifetime limits the maximal lifetime of a\n  postgresql connection, defaults to 30m","shortMessageHtmlLink":"feat: use hasql-pool-0.9, add db-pool-max-lifetime (<span class=\"issue-keyword tooltipped tooltipped-se\" aria-label=\"This commit closes issue #2638.\">fixes</span> <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1560338937\" data-permission-text=\"Title is private\" data-url=\"https://github.com/PostgREST/postgrest/issues/2638\" data-hovercard-type=\"issue\" data-hovercard-url=\"/PostgREST/postgrest/issues/2638/hovercard\" href=\"https://github.com/PostgREST/postgrest/issues/2638\">PostgREST#2638</a>"}},{"before":"6befe8c86c0597fed31f9ab109ffe3c4ee79ee0a","after":"4491a373dfeb5e936b116f36a7729b27d2cfcc17","ref":"refs/heads/pool-lifetime","pushedAt":"2023-04-06T17:34:08.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"robx","name":"Robert","path":"/robx","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/132113?s=80&v=4"},"commit":{"message":"feat: use hasql-pool-0.9, add db-pool-max-lifetime (fixes #2638)\n\n- db-pool-acquisition-timeout is no longer optional, defaults to 10s\n- new option db-pool-max-lifetime limits the maximal lifetime of a\n  postgresql connection, defaults to 30m","shortMessageHtmlLink":"feat: use hasql-pool-0.9, add db-pool-max-lifetime (<span class=\"issue-keyword tooltipped tooltipped-se\" aria-label=\"This commit closes issue #2638.\">fixes</span> <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1560338937\" data-permission-text=\"Title is private\" data-url=\"https://github.com/PostgREST/postgrest/issues/2638\" data-hovercard-type=\"issue\" data-hovercard-url=\"/PostgREST/postgrest/issues/2638/hovercard\" href=\"https://github.com/PostgREST/postgrest/issues/2638\">PostgREST#2638</a>"}},{"before":"13e26fbc3a3abd8d8c02eb070b427dee41152420","after":"6befe8c86c0597fed31f9ab109ffe3c4ee79ee0a","ref":"refs/heads/pool-lifetime","pushedAt":"2023-04-06T12:20:33.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"robx","name":"Robert","path":"/robx","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/132113?s=80&v=4"},"commit":{"message":"feat: use hasql-pool-0.9, add db-pool-max-lifetime (fixes #2638)\n\n- db-pool-acquisition-timeout is no longer optional, defaults to 10s\n- new option db-pool-max-lifetime limits the maximal lifetime of a\n  postgresql connection, defaults to 30m","shortMessageHtmlLink":"feat: use hasql-pool-0.9, add db-pool-max-lifetime (<span class=\"issue-keyword tooltipped tooltipped-se\" aria-label=\"This commit closes issue #2638.\">fixes</span> <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1560338937\" data-permission-text=\"Title is private\" data-url=\"https://github.com/PostgREST/postgrest/issues/2638\" data-hovercard-type=\"issue\" data-hovercard-url=\"/PostgREST/postgrest/issues/2638/hovercard\" href=\"https://github.com/PostgREST/postgrest/issues/2638\">PostgREST#2638</a>"}},{"before":"7ab10d5190b6b14d77bf0d8966eb53ce0b1dab0c","after":null,"ref":"refs/heads/with-slow","pushedAt":"2023-03-20T14:00:15.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"robx","name":"Robert","path":"/robx","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/132113?s=80&v=4"}},{"before":"bc692880d321a4d56197e917f05d62632aba1fe8","after":"7ab10d5190b6b14d77bf0d8966eb53ce0b1dab0c","ref":"refs/heads/with-slow","pushedAt":"2023-03-20T13:06:01.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"robx","name":"Robert","path":"/robx","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/132113?s=80&v=4"},"commit":{"message":"test: optionally build postgrest with cabal in postgrest-loadtest\n\nBy default, postgrest-with-pgrst builds postgrest as a nix package,\nwhich means that source changes cause a full rebuild. With this\nchange, running the loadtest as\n\nPGRST_BUILD_CABAL=1 postgrest-loadtest\n\nrebuilds directly using cabal, like postgrest-build. Note that\nresults between nix and cabal builds aren't necessarily comparable\ndue to differing build parameters.","shortMessageHtmlLink":"test: optionally build postgrest with cabal in postgrest-loadtest"}},{"before":"e09c9c1a43ff9f3d198cd32d7f9f6ff49f567e54","after":null,"ref":"refs/heads/pre-req","pushedAt":"2023-03-20T12:40:48.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"robx","name":"Robert","path":"/robx","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/132113?s=80&v=4"}},{"before":null,"after":"e8d50d302c6af32185a43e1d2702f0a6b0d3b58b","ref":"refs/heads/pipeline","pushedAt":"2023-03-16T15:31:31.369Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"robx","name":"Robert","path":"/robx","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/132113?s=80&v=4"},"commit":{"message":"use pipeline mode","shortMessageHtmlLink":"use pipeline mode"}},{"before":"fac0b62cae88a637b838422f21435e90da5b4451","after":"bc692880d321a4d56197e917f05d62632aba1fe8","ref":"refs/heads/with-slow","pushedAt":"2023-03-16T15:30:17.078Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"robx","name":"Robert","path":"/robx","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/132113?s=80&v=4"},"commit":{"message":"use withSlowPg, withSlowPgrst for postgrest-test-spec","shortMessageHtmlLink":"use withSlowPg, withSlowPgrst for postgrest-test-spec"}},{"before":"b035210fc1aa3b13f3728849e98f602717435c31","after":"e09c9c1a43ff9f3d198cd32d7f9f6ff49f567e54","ref":"refs/heads/pre-req","pushedAt":"2023-03-16T15:29:37.383Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"robx","name":"Robert","path":"/robx","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/132113?s=80&v=4"},"commit":{"message":"perf: Allow preparing pre-request SQL statement\n\nThis will prepare the pre-request statement (if prepared statements\nare enabled) with a possible minor performance benefit -- the load\ntest is not entirely conclusive.","shortMessageHtmlLink":"perf: Allow preparing pre-request SQL statement"}},{"before":"87c7a0c8b5c50c632dfe8bef0193b57d6384febb","after":"b035210fc1aa3b13f3728849e98f602717435c31","ref":"refs/heads/pre-req","pushedAt":"2023-03-16T15:27:10.568Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"robx","name":"Robert","path":"/robx","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/132113?s=80&v=4"},"commit":{"message":"feat: Allow preparing pre-request SQL statement","shortMessageHtmlLink":"feat: Allow preparing pre-request SQL statement"}}],"hasNextPage":false,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAADoVceNAA","startCursor":null,"endCursor":null}},"title":"Activity · robx/postgrest"}