{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":1325587,"defaultBranch":"main","name":"pg-semver","ownerLogin":"theory","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2011-02-03T20:23:51.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/46604?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1706559350.0","currentOid":""},"activityList":{"items":[{"before":"85db4db93f117ae02c1e791402615e1f195058be","after":"804f9541fda7714a3317cbde7f68e6e074e980f6","ref":"refs/heads/main","pushedAt":"2024-03-20T01:03:38.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"theory","name":"David E. Wheeler","path":"/theory","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/46604?s=80&v=4"},"commit":{"message":"Bump version in README to 0.32.1","shortMessageHtmlLink":"Bump version in README to 0.32.1"}},{"before":"9ed9489fb350cf0199511c27415d04967e60ffc3","after":"85db4db93f117ae02c1e791402615e1f195058be","ref":"refs/heads/main","pushedAt":"2024-02-08T21:56:38.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"theory","name":"David E. Wheeler","path":"/theory","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/46604?s=80&v=4"},"commit":{"message":"Ignore DLLs","shortMessageHtmlLink":"Ignore DLLs"}},{"before":"c21646cc0f677d7f9698fadf75cfb2f5272845c7","after":"24134fdad54a6b3c08e0347bf88718159497e496","ref":"refs/heads/namespace-experiment","pushedAt":"2024-01-29T20:33:41.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"theory","name":"David E. Wheeler","path":"/theory","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/46604?s=80&v=4"},"commit":{"message":"Use domain-qualified name for extension\n\nAn experiment to see whether the current PostgreSQL extension\ninstallation and configuration can be abused to avoid namespace\ncollision between extensions with the same names. This shows that\nfor relocatable extensions, at least, it can be done, but it's\npretty ugly: Everything has to refer to the full extension name ---\nhere `github.com+theory+pg-semver` --- including:\n\n*   The Control file\n*   SQL files\n*   The `MODULERDIR` variable in the `Makefile`, to install files into a\n    directory with the long extension name\n*   The `directory` entry in the control file to match `MODULERDIR`\n\nThis change doesn't actually rename all of the `sql/*.sql` files, but\nupdates the `Makefile` to generate the\n`sql/github.com+theory+pg-semver--$VERSION.sql` file\n\nIt's possible a lot of this could be automated in the `Makefile`:\nreplace a short name with a longer name, move and rename files, etc.\nBut it'd be kind of a pain. The alternative is to rename everything\nappropriately in the repository, but that'd be ugly. Besides, changing\nthe extension name like this means that older versions would never be\nproperly upgraded.\n\nIt'd be nicer if PostgreSQL itself were updated to support some sort of\nschema packaging, where everything could go into one directory named for\nthe repository. That's probably the smarter long-term goal.","shortMessageHtmlLink":"Use domain-qualified name for extension"}},{"before":"88b3abd06399e1237f626afcb03e9382ea593058","after":"9ed9489fb350cf0199511c27415d04967e60ffc3","ref":"refs/heads/main","pushedAt":"2024-01-29T20:31:12.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"theory","name":"David E. Wheeler","path":"/theory","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/46604?s=80&v=4"},"commit":{"message":"Use MODULE_PATHNAME and CREATE EXTENSION\n\nUse `MODULE_PATHNAME` in the SQL files to refer to the static library to\nbuild. This allows for the library to be renamed --- e.g., by a\npackaging system --- without having to change the source code, just the\ncontrol file.\n\nAlso use `CREATE EXTENSION` in the tests instead of loading the\n`sql/semver.sql` file directly. The latter was required before extension\nsupport was added to Postgres in 9.1, and 9.2 has been required since\nv0.20.0 back in 2018.\n\nAlso note the change to the module directory in the previous commit\n(88b3abd), ignore generated `*.bin` files, and update the copyright\nyear.","shortMessageHtmlLink":"Use MODULE_PATHNAME and CREATE EXTENSION"}},{"before":null,"after":"c21646cc0f677d7f9698fadf75cfb2f5272845c7","ref":"refs/heads/namespace-experiment","pushedAt":"2024-01-29T20:15:50.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"theory","name":"David E. Wheeler","path":"/theory","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/46604?s=80&v=4"},"commit":{"message":"Use domain-qualified name for extension\n\nAn experiment to see whether the current PostgreSQL extension\ninstallation and configuration can be abused to avoid namespace\ncollision between extensions with the same names. This shows that\nfor relocatable extensions, at least, it can be done, but it's\npretty ugly: Everything has to refer to the full extension name ---\nhere `github.com+theory+pg-semver` --- including file names:\n\n*   Control file\n*   SQL files\n*   The `MODULERDIR` file in `Makefile` to install files into a\n    directory with the long extension name\n*   The `directory` entry in the control file to match `MODULERDIR`\n\nThis change doesn't actually rename all of the `sql/*.sql` files, but\nupdates the Makefile to generate the\n`sql/github.com+theory+pg-semver--$VERSION.sql` file\n\nAlso had to update the SQL file to use `MODULE_PATHNAME` instead of\n`semver` so that it can be dynamically set, and change the tests to use\n`CREATE EXTENSION` to create the extension to test, rather than load the\nfile directly. The latter was required for PostgreSQL 9.0 and earlier,\nwhich are no longer supported anyway.\n\nIt's possible a lot of this could be automated in the `Makefile`:\nreplace a short name with a longer name, move and rename files, etc.,\nbut it'd be kind of a pain. The alternative is to rename everything\nappropriately in the repository, but that'd be ugly. Besides, changing\nthe extension name like this means that older versions would never be\nproperly upgraded.\n\nIt'd be nicer if PostgreSQL itself were updated to support some sort of\nschema packaging, where everything could go into one directory named for\nthe repository. That's probably the smarter long-term goal.","shortMessageHtmlLink":"Use domain-qualified name for extension"}},{"before":"d76707c52da93501401784efcbda0a087523f8ac","after":"88b3abd06399e1237f626afcb03e9382ea593058","ref":"refs/heads/main","pushedAt":"2024-01-26T23:45:00.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"theory","name":"David E. Wheeler","path":"/theory","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/46604?s=80&v=4"},"commit":{"message":"Install in `semver` subdirectory\n\nTo keep all the SQL files together, at least.","shortMessageHtmlLink":"Install in <code>semver</code> subdirectory"}},{"before":"01687057714b35cb18eee232d46732d72a6629b7","after":"d76707c52da93501401784efcbda0a087523f8ac","ref":"refs/heads/main","pushedAt":"2023-08-02T01:53:18.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"theory","name":"David E. Wheeler","path":"/theory","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/46604?s=80&v=4"},"commit":{"message":"Update copyright year","shortMessageHtmlLink":"Update copyright year"}},{"before":"0395d69359d27614de3ed0a99d311a34cb91fe73","after":"01687057714b35cb18eee232d46732d72a6629b7","ref":"refs/heads/main","pushedAt":"2023-08-01T23:23:04.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"theory","name":"David E. Wheeler","path":"/theory","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/46604?s=80&v=4"},"commit":{"message":"Start v0.32.2","shortMessageHtmlLink":"Start v0.32.2"}},{"before":"598a386264e952045bdf96b818f8f01b07185d50","after":"0395d69359d27614de3ed0a99d311a34cb91fe73","ref":"refs/heads/main","pushedAt":"2023-08-01T23:14:07.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"theory","name":"David E. Wheeler","path":"/theory","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/46604?s=80&v=4"},"commit":{"message":"Increment to and timestamp v0.32.1","shortMessageHtmlLink":"Increment to and timestamp v0.32.1"}},{"before":"9f91831e7c921fec0c636ac72960e4686a0d9bff","after":"598a386264e952045bdf96b818f8f01b07185d50","ref":"refs/heads/main","pushedAt":"2023-08-01T23:03:49.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"theory","name":"David E. Wheeler","path":"/theory","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/46604?s=80&v=4"},"commit":{"message":"Test on Postgres 16\n\nAnd note fix in c503d21.","shortMessageHtmlLink":"Test on Postgres 16"}}],"hasNextPage":false,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEGjBO0wA","startCursor":null,"endCursor":null}},"title":"Activity · theory/pg-semver"}