meoyawn / pggen

Не вдалося зібрати розв'язаний набір залежностей для цього звіту: GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository

{
  "data": {
    "repo": {
      "topics": [],
      "is_fork": true,
      "size_kb": 1214,
      "has_wiki": true,
      "homepage": null,
      "languages": {
        "Go": 369366,
        "Shell": 2304,
        "PLpgSQL": 2748
      },
      "pushed_at": "2026-07-20T13:17:00Z",
      "created_at": "2026-05-05T12:33:43Z",
      "owner_type": "User",
      "updated_at": "2026-07-20T13:16:11Z",
      "description": "Generate type-safe Go for any Postgres query. If Postgres can run the query, pggen can generate code for it.",
      "is_archived": false,
      "is_disabled": false,
      "license_spdx": "MIT",
      "default_branch": "main",
      "license_spdx_raw": "MIT",
      "primary_language": "Go",
      "significant_languages": [
        "Go"
      ]
    },
    "owner": {
      "blog": "adelnz.com",
      "name": "Adel Nizamutdinov",
      "type": "User",
      "login": "meoyawn",
      "company": null,
      "location": null,
      "followers": 138,
      "avatar_url": "https://avatars.githubusercontent.com/u/1594148?v=4",
      "created_at": "2012-03-31T21:33:09Z",
      "is_verified": null,
      "public_repos": 57,
      "account_age_days": 5232
    },
    "license": {
      "state": "standard",
      "spdx_id": "MIT",
      "raw_spdx": "MIT",
      "file_present": true,
      "scorecard_found": true,
      "profile_has_license": false
    },
    "activity": {
      "releases": [
        {
          "tag": "v0.2.0",
          "kind": "minor",
          "published_at": "2026-07-20T13:14:28Z"
        },
        {
          "tag": "v0.1.0",
          "kind": "minor",
          "published_at": "2026-06-19T16:22:44Z"
        },
        {
          "tag": "v0.0.4",
          "kind": "patch",
          "published_at": "2026-06-02T20:17:21Z"
        },
        {
          "tag": "v0.0.3",
          "kind": "patch",
          "published_at": "2026-06-02T19:53:55Z"
        },
        {
          "tag": "v0.0.2-pgxv5.20260507",
          "kind": "prerelease",
          "published_at": "2026-05-07T11:33:18Z"
        },
        {
          "tag": "v0.0.1-pgxv5.20260507",
          "kind": "prerelease",
          "published_at": "2026-05-07T08:25:22Z"
        }
      ],
      "recent_commits": [
        {
          "oid": "9fc19c8979eb3592baa02c4af91db9d1fc7b0d15",
          "body": null,
          "is_bot": false,
          "headline": "Require downstream Postgres connection for generation",
          "author_name": "adelnizamutdinov",
          "author_login": "meoyawn",
          "committed_at": "2026-07-20T13:14:28Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "abf9635060a3907ca44afdbd75a034d06b75ad47",
          "body": null,
          "is_bot": false,
          "headline": "Document shared row structs and streaming queries",
          "author_name": "adelnizamutdinov",
          "author_login": "meoyawn",
          "committed_at": "2026-06-19T16:39:12Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "740c219d7fc11411bccb44419175645c39bbc6a0",
          "body": null,
          "is_bot": false,
          "headline": "Add domain type resolution for custom IDs",
          "author_name": "adelnizamutdinov",
          "author_login": "meoyawn",
          "committed_at": "2026-06-19T16:22:44Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d7606d8b1b273ef3d2dd113b6fc59c52e03b53d6",
          "body": "Fixes https://github.com/meoyawn/pggen/issues/2",
          "is_bot": false,
          "headline": "Add stream query support",
          "author_name": "adelnizamutdinov",
          "author_login": "meoyawn",
          "committed_at": "2026-06-18T14:27:02Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "db035d4328d65aa407725de61371298859eb3108",
          "body": "Fixes https://github.com/meoyawn/pggen/issues/1",
          "is_bot": false,
          "headline": "Add shared row annotations",
          "author_name": "adelnizamutdinov",
          "author_login": "meoyawn",
          "committed_at": "2026-06-18T13:44:23Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8055dbf62bce4523b5b1e6e23edbaa1c08aedcb8",
          "body": null,
          "is_bot": false,
          "headline": "gitignore",
          "author_name": "adelnizamutdinov",
          "author_login": "meoyawn",
          "committed_at": "2026-06-18T13:11:09Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "3a56366e8057af5462bdb1c5e1d806a0ac391831",
          "body": null,
          "is_bot": false,
          "headline": "taskfile",
          "author_name": "adelnizamutdinov",
          "author_login": "meoyawn",
          "committed_at": "2026-06-18T13:08:47Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "29ec1980c735b718353a3a0641f0ed51bb33b510",
          "body": null,
          "is_bot": false,
          "headline": "Use pointer receivers for projection getters",
          "author_name": "adelnizamutdinov",
          "author_login": "meoyawn",
          "committed_at": "2026-06-02T20:17:21Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0751c2b0c689716c1822796c759250ca501e72e5",
          "body": "Closes https://github.com/jschaf/pggen/issues/44",
          "is_bot": false,
          "headline": "Add projection interfaces for query rows",
          "author_name": "adelnizamutdinov",
          "author_login": "meoyawn",
          "committed_at": "2026-06-02T19:53:55Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "10ab9427e3ce14fa938c2e5864d2957652463586",
          "body": null,
          "is_bot": false,
          "headline": "Upgrade Docker dependencies",
          "author_name": "meoyawn",
          "author_login": "meoyawn",
          "committed_at": "2026-05-07T11:33:18Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "5106fe911aac7a8eabae0c3821d7806cdeaf6f7a",
          "body": null,
          "is_bot": false,
          "headline": "Make pgx v5 fork go-gettable",
          "author_name": "meoyawn",
          "author_login": "meoyawn",
          "committed_at": "2026-05-07T08:25:22Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a6e9a749132d9fea68f873819ef9b009c39328f5",
          "body": null,
          "is_bot": false,
          "headline": "Update README for pgx v5",
          "author_name": "meoyawn",
          "author_login": "meoyawn",
          "committed_at": "2026-05-06T21:42:44Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "adb89a8cd471ee6da0e769e05eca493f83973709",
          "body": null,
          "is_bot": false,
          "headline": "Wrap collection errors with query context",
          "author_name": "meoyawn",
          "author_login": "meoyawn",
          "committed_at": "2026-05-06T21:32:31Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "24c47e8eb95c973dd04dae0ecd17fe064c56688d",
          "body": null,
          "is_bot": false,
          "headline": "Use CollectOneRow for one queries",
          "author_name": "meoyawn",
          "author_login": "meoyawn",
          "committed_at": "2026-05-06T21:23:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ddc4ef26b84cecc040fb364c1317a04d583c16a0",
          "body": null,
          "is_bot": false,
          "headline": "Fix zero returns for custom scalar results",
          "author_name": "meoyawn",
          "author_login": "meoyawn",
          "committed_at": "2026-05-06T21:11:52Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "47c914855b558509371e9a1a94a4325f89ee1a37",
          "body": null,
          "is_bot": false,
          "headline": "Trim blank declarer output",
          "author_name": "meoyawn",
          "author_login": "meoyawn",
          "committed_at": "2026-05-06T19:33:43Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8b76a4d96d02afbdcd60e77f193e498bdc0965ec",
          "body": null,
          "is_bot": false,
          "headline": "Add pgx ltree array override coverage",
          "author_name": "meoyawn",
          "author_login": "meoyawn",
          "committed_at": "2026-05-06T19:16:03Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ebeee45a92af65b87a3bb2cc307454e4428216c6",
          "body": null,
          "is_bot": false,
          "headline": "Restore generated type registration test coverage",
          "author_name": "meoyawn",
          "author_login": "meoyawn",
          "committed_at": "2026-05-06T19:01:13Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "79e1b92769af8f70e18ca21b546189711a62456c",
          "body": null,
          "is_bot": false,
          "headline": "Finish pgx v5 generated query support",
          "author_name": "meoyawn",
          "author_login": "meoyawn",
          "committed_at": "2026-05-06T14:40:57Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6dfe30cb5fbf1cbe1582f8cccfcfda54f7887c49",
          "body": "# Conflicts:\n#\texample/composite/query.sql_test.go\n#\texample/custom_types/query.sql_test.go\n#\texample/device/query.sql_test.go\n#\texample/enums/query.sql_test.go\n#\texample/erp/order/customer.sql_test.go\n#\texample/inline_param_count/inline0/query.sql_test.go\n#\texample/inline_param_count/inline1/query.\n[…]\ninternal/pg/type_cache.go\n#\tinternal/pg/type_fetcher.go\n#\tinternal/pg/types.go\n#\tinternal/pgdocker/pgdocker.go\n#\tinternal/pginfer/pginfer.go\n#\tinternal/pgplan/pgplan.go\n#\tinternal/pgtest/pg_test_db.go",
          "is_bot": false,
          "headline": "Merge remote-tracking branch 'upstream/joe/pgxv5' into meoyawn/pgxv5",
          "author_name": "meoyawn",
          "author_login": "meoyawn",
          "committed_at": "2026-05-06T13:20:29Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "6d5a5fff2bdbd6867544dd0aa1de7d63fde65364",
          "body": null,
          "is_bot": false,
          "headline": "Run tests through dockerized Postgres wrapper",
          "author_name": "meoyawn",
          "author_login": "meoyawn",
          "committed_at": "2026-05-06T12:55:57Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "632aa8e2e34733a36dbda854dcb4aa8a9b57f884",
          "body": "- Upgrade golangci-lint. Fix a bunch of lints.",
          "is_bot": false,
          "headline": "Upgrade to go 1.24.1 (#106)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2025-03-14T05:00:27Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7ca7c671954af85d8e511ec15c7d2417be335e15",
          "body": null,
          "is_bot": false,
          "headline": "update template for code",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-26T18:13:40Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "2b41dd18069be924125027b2c63c7362243ffe4a",
          "body": null,
          "is_bot": false,
          "headline": "move codecs into template",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-26T01:27:34Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1b29c21c3998c76af787ed3cd089593aaaaa4f68",
          "body": null,
          "is_bot": false,
          "headline": "fix most author example tests",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-25T07:21:16Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8e58ee07478620e863ba20506fb978877d24a060",
          "body": null,
          "is_bot": false,
          "headline": "Simplify codec",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-25T06:16:37Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "500b5c6be650536cc5b4cb45a13c45002d6d04ca",
          "body": null,
          "is_bot": false,
          "headline": "More experiments with codecs",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-06T01:45:35Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4bb40e2b95c380ce9d386688af28a408521121d8",
          "body": null,
          "is_bot": false,
          "headline": "experiment with codecs",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-05T23:12:55Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b52421341541e98ca5a8c08d8da6ed6c6033720b",
          "body": "- For pggen row structs, implement pgx.RowScanner.\n- Remove the typeResolver, since we're punting type resolution to the pgx.Conn\n  type map for now.\n\n#74",
          "is_bot": false,
          "headline": "Upgrade to pgx v5",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-05T06:24:08Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "3259c9ab0b7ddcf7d614f05491455b57242d96b0",
          "body": "We don't need the wordy description in every generated file.",
          "is_bot": false,
          "headline": "Shorten docs for generic conn (#103)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-05T06:23:07Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "104c6ec88482326f2ed338d9ca29afec674d749a",
          "body": "Follow-up to #100.",
          "is_bot": false,
          "headline": "Remove reference to NewQuerierConfig (#101)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-03T23:45:03Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c25070dd55607b08f4f5b8bc2bc83263df8f6303",
          "body": "It was a way to override the type encoders and decoders. It wasn't documented\r\nand makes it harder to upgrade to to pgx v5. Plus, we can't really change it in\r\na way to that won't break existing users, so just remove it.e",
          "is_bot": false,
          "headline": "Remove QuerierConfig (#100)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-02T06:03:14Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d0025c1de489a975fea5cae95c82dad6421617c7",
          "body": "I never used it so I think usage is probably low. Complicates the pgx v5\r\nupgrade, so drop it.\r\n\r\nIt's easy enough to workaround by writing the prepare manually.\r\n\r\nAdditionally, it won't work well if we eventually support dynamic queries.",
          "is_bot": false,
          "headline": "Remove PrepareAllQueries (#98)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-02T05:26:11Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1018a30e40067e8e25793bc181b51a4518d742cf",
          "body": "Speeds up testing by about 25%, from 57 seconds to 42 seconds.",
          "is_bot": false,
          "headline": "Use buildjet for actions (#97)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-02T05:15:27Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8529e51c1e898929c8af8687c228bc77f9e12459",
          "body": "Prefer the standard library to limit dependencies.",
          "is_bot": false,
          "headline": "Replace multierror with stdlib errors.Join (#96)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-02T05:01:51Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "fed2faa3f735537759523517f943068a3dbce208",
          "body": "Prefer the standard library to limit dependencies.",
          "is_bot": false,
          "headline": "Replace zap with slog (#95)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-02T04:56:46Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "eed46625728d1122f8d6bccfa4eccc5263fd3b34",
          "body": null,
          "is_bot": false,
          "headline": "Upgrade all go.mod deps (#94)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-02T04:42:11Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "323805032c9a4f05d6dab88b845e01505e75c535",
          "body": "PGXv5 dramatically changes how batch queries work. In v4 we use a separate\r\nbatch and scan call. In v5, we use a callback with generics for type safety.\r\n\r\nRemove batch queries for now since it complicates upgrading to pgx V5. We may\r\nthem back in later with more ergonomic API.\r\n\r\n#74",
          "is_bot": false,
          "headline": "Remove all batch queries (#93)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2024-01-02T04:25:38Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8ecc0cbb97740104749b48689c6a47515d83d16a",
          "body": "* Add JSON tags for input structs as well\r\n\r\n* Add string padding for EmitParamStruct\r\n\r\n* Update tests\r\n\r\n* Add RawName, still need to fix tests\r\n\r\n* Refactor functions for aligning spacing\r\n\r\n* Update getLongestInput to use RawName instead of UpperName\r\n\r\n* Update acceptance tests",
          "is_bot": false,
          "headline": "Add JSON tags for parameter structs (#90)",
          "author_name": "Faraz Fazli",
          "author_login": "farazfazli",
          "committed_at": "2023-10-16T23:57:18Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "db00fd2ab2770c45935e0c30a0648feded6ec898",
          "body": null,
          "is_bot": false,
          "headline": "Avoid deprecated goreleaser settings",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2023-06-17T23:11:55Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "fe0c28d62d37d84ccd7f2cf48ff34b3a8354b1dc",
          "body": "Default to two to match previous behavior. Main use case is to always output a\r\nstruct for parameters. Useful so that structure doesn't change when adding a\r\nnew param.\r\n\r\nFixes #83.",
          "is_bot": false,
          "headline": "Add pggen --inline-param-count=2 flag (#87)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2023-06-17T22:53:26Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c57cb1e626f2ef312e71e28412f668bddf4f2daa",
          "body": null,
          "is_bot": false,
          "headline": "Sync dev/words.dic",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2023-06-17T21:00:50Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "55d8fc95461d9145d27145eeaeee188d9670912e",
          "body": "Previously, we used the higher level pgx Exec method to run a Postgres PREPARE\ncommand and then inspected the Postgres catalog.\n\nInstead, issue a prepare command directly with the lower-level pgconn which\nreturns the fields and parameter OIDs directly.",
          "is_bot": false,
          "headline": "Infer types with prepare instead of execution",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2023-06-17T17:12:49Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "85a861340f8c29c155f9201433672c3cd18ea538",
          "body": null,
          "is_bot": false,
          "headline": "Run gofmt simplify to fix docs",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2023-06-17T16:40:42Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4272ee3e6dd82b766dcdbfa8045911d6b08aaf4f",
          "body": null,
          "is_bot": false,
          "headline": "Fix IntelliJ Go lints",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2023-06-17T16:37:54Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "95dc2643202b9aeac8a9fc5ec1a8dab42ad39e95",
          "body": null,
          "is_bot": false,
          "headline": "Fix IntelliJ lints",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2023-06-17T16:34:36Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7aa983baa5ce5cf60f971d7474ecba5de73195da",
          "body": "Sync it from IntelliJ.",
          "is_bot": false,
          "headline": "Add word list dictionary",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2023-06-17T15:59:39Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "363cf19563c6f8fcc9cdc59b20b7d27fc81e2f85",
          "body": null,
          "is_bot": false,
          "headline": "Remove unused pginfer.InputParam DefaultVal",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2023-06-16T04:38:09Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8c1a3a3a85fea3b62844b43a437b8677f1cf37ec",
          "body": null,
          "is_bot": false,
          "headline": "allow overriding \"id\" acronym (#80)",
          "author_name": "Sergey Shumov",
          "author_login": "darkxanter",
          "committed_at": "2023-01-27T20:08:01Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "943a70caede2e68b419c59d7dec95264e279b849",
          "body": null,
          "is_bot": false,
          "headline": "handle dot paths on the output directory (#78)",
          "author_name": "Bradley Weston",
          "author_login": "bweston92",
          "committed_at": "2022-12-30T04:57:21Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b7cb7995a131262d794e6704a5c807606c306a73",
          "body": null,
          "is_bot": false,
          "headline": "Upgrade postgres version to 15 in test docker image",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-12-16T01:20:45Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ef6fa918bb8e2ae86851be77fb84fdab61409843",
          "body": null,
          "is_bot": false,
          "headline": "Add explain plan support for Postgres 14 (#76)",
          "author_name": "Amari Robinson",
          "author_login": "amari",
          "committed_at": "2022-12-16T01:15:38Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4e47108cde7ec44ee49efda8b670e550309e81e6",
          "body": "Previously, if a query returned a single nullable column, pggen would\r\nreturn the correct type *string, but only because we took the address\r\nof the input.\r\n\r\nBad code:\r\n\r\n\tvar item string\r\n\tif err := row.Scan(&item); err != nil {\r\n\t\treturn &item, fmt.Errorf(\"query StringAggFirstName: %w\", err)\r\n\t}\r\n\treturn &item, nil\r\n\r\nFixed code:\r\n\r\n\tvar item *string\r\n\tif err := row.Scan(&item); err != nil {\r\n\t\treturn item, fmt.Errorf(\"query StringAggFirstName: %w\", err)\r\n\t}\r\n\treturn item, nil\r\n\r\nFixes #75.",
          "is_bot": false,
          "headline": "Fix result type decl for nullable :one queries (#77)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-12-16T00:59:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f664a918378a9de8e912417ad07eeed98fc17404",
          "body": "This is an attempt to repro #75. The nullability is working as intended.\nThe OutputColumn has nullable=true. I suspect the issue occurs when\ntemplating the query for the :one case since the :many case work as\nexpected.",
          "is_bot": false,
          "headline": "Add pginfer test for aggregating a non-null column",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-12-15T23:58:47Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0abc8830f4dd120c5b5c5818622dd3d79bab7fde",
          "body": "Since go 1.16, `ioutil` has been deprecated. Its use triggers warnings\r\nwhen linting with `golangci-lint`.\r\n\r\nMigrate from `ioutil` to `io` and `os`, as specified at:\r\nhttps://go.dev/doc/go1.16#ioutil",
          "is_bot": false,
          "headline": "refactor: remove deprecated ioutil (#72)",
          "author_name": "Jacques Dafflon",
          "author_login": "0xjac",
          "committed_at": "2022-08-18T17:15:23Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "176eeb1d7651598f6ecc3e0ce157cdaa47c7b5e1",
          "body": "Adds the field names when instantiating the `compositeField` and\r\n`textPreferrer` struct in the generated code.\r\n\r\nThis allows to run the fieldalignment linter without errors on the\r\ngenerated code.",
          "is_bot": false,
          "headline": "fix: use struct field names in generated code (#71)",
          "author_name": "Jacques Dafflon",
          "author_login": "0xjac",
          "committed_at": "2022-08-18T17:12:58Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "92ff9121ffbadbaba2a0eef713500334a750a88f",
          "body": null,
          "is_bot": false,
          "headline": "Fix typo.",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-07-17T07:26:07Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4ac3aef27ef385ebad5789be41c6ac2da4e7718b",
          "body": null,
          "is_bot": false,
          "headline": "Update readme with new download instructions.",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-07-17T07:20:24Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "276211556f4d83708b56d281d75c63695ecfd78e",
          "body": "GitHub releaser stopped working.",
          "is_bot": false,
          "headline": "Switch to GoReleaser",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-07-17T06:59:10Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c97b1bd606b2503a7f9153680ca6d74f3460903a",
          "body": "Previously, we unwrapped the type before running QualifyType which meant we\nlost the import path. Run QualifyType on the original type before unwrapping.\n\nFixes #67.",
          "is_bot": false,
          "headline": "Fix custom user type declaration inside composite type.",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-07-17T05:56:14Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b7cb617f2b20bd644f621c30a4c249125011f5f6",
          "body": "The main trick is to SELECT FROM the function which converts the record\r\ntype into proper postgres columns.\r\n\r\nFixes #25.",
          "is_bot": false,
          "headline": "Add example for querying with function out parameters (#64)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-05-30T06:47:37Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "50da59827af5e467529487c09d7dcd8651048b28",
          "body": "Previously, we would attempt to create a newArrayInit function, but instead we\r\ncan use the pgtype array variants, like pgtype.BoolArray.",
          "is_bot": false,
          "headline": "Fix primitive array types inside a composite type (#63)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-05-30T06:07:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8c321e695369a01afe2a51091498355134aff23c",
          "body": null,
          "is_bot": false,
          "headline": "Add more logging to release script",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-05-26T05:46:56Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7eb2a5bb4513e1281d52e76d7f723729ff28140e",
          "body": "Fixes #45.",
          "is_bot": false,
          "headline": "Add nullability inference test for update query with returning (#62)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-05-22T23:25:07Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "133aca8dd4d9b5e96d71f030b8095abce1060a22",
          "body": "Most of the groundwork was in #60. Add a test to make sure it works. Custom type\r\nsupport is probably still dodgy. I suspect the code will compile, but you'd have\r\nto implement the pgx.ValueTranscoder interface for it to actually work.\r\n\r\nFixes #43.",
          "is_bot": false,
          "headline": "Fix imported types with slices and pointers (#61)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-05-22T23:22:29Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "2489d54a806652d73f2c83bb5736a7574582092c",
          "body": "Previously, pggen struggled with types like `[]*time.Time`. Use a proper parse\r\ntree with nodes for pointers and arrays. The output should be a no-op; this\r\nis an internal change.",
          "is_bot": false,
          "headline": "Make type parsing more robust (#60)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-05-22T08:32:24Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "80ac24d15306681e36e827a3f631e065d1b5ae60",
          "body": null,
          "is_bot": false,
          "headline": "Update golangci-lint to fix error (#59)",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-05-22T07:07:36Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0c474a61b820bc89bf9242b92d371a7063f5646f",
          "body": "As discussed in https://github.com/jschaf/pggen/issues/55",
          "is_bot": false,
          "headline": "Suggest a better IDE Integration (#56)",
          "author_name": "Benjamin Thomas",
          "author_login": "benjamin-thomas",
          "committed_at": "2022-04-28T18:30:31Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1266d15e85c54237d9b58b1a701acd5274bc2c45",
          "body": null,
          "is_bot": false,
          "headline": "Add non-nullability support for LIMIT queries",
          "author_name": "djsavvy",
          "author_login": null,
          "committed_at": "2022-02-05T22:54:50Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "43bad0138c31130afd69dc90f208dfc278bde484",
          "body": "Relates to #51.",
          "is_bot": false,
          "headline": "Attempt to limit release to push on main branch",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2022-02-05T22:40:17Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7f878880d5f9f7d25dec867850c6831e8c4402e7",
          "body": "The main trick is to specify the override on NewQuerierConfig and not on\nConnInfo.RegisterDataType. We can't easily get the data types for pgxpool.Pool\nbecause we need to get a real *Conn which then fetches a connection from the\n pool.\n\nPartially resolves #39.",
          "is_bot": false,
          "headline": "Add example of custom numeric type",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-09-07T02:29:37Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e7492c17d64fc11117eab2338e753b0a95b8808c",
          "body": "pggen surfaces constraint violations for a query that returns no rows but\nis marked :one or :many instead of :exec, like:\n\n    -- name: Foo :one\n    UPDATE foo SET bar = 1;\n\npggen needs at least one output column result type for :one and :many queries.\nPostgres happily provides the types even if the\n[…]\nis marked :one).\n              Use :exec if you don't need the query output.\n        ERROR: null value in column \"display_name\" of relation \"item_current\" violates not-null constraint (SQLSTATE 23502)",
          "is_bot": false,
          "headline": "Add hint for :one and :many queries with no output columns",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-08-31T18:55:52Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "43bb88da5ee99ad332801a87b5c7a654c3fd7983",
          "body": "- Handle undefined $TMPDIR.\n- Have curl show errors.\n- Fix install when cwd is ~/bin.",
          "is_bot": false,
          "headline": "Fix README install commands",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-08-23T06:55:57Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "df3838f1b99bed22dfc60be03a63ca0cb1b4b84a",
          "body": "I want to allow for custom implementations of batch functionality. I\nspecifically need it to allow for customizing the generated SQL. By implementing\ngenericConn, we can modify the SQL that's sent with conn.SendBatch.\n\nFor Query, QueryRow, and Exec, we can implement genericConn for similar hooks.\nBut since *pgx.Batch is a struct, we can't override it. By using an interface,\nwe can pass a custom wrapper over *pgx.Batch.",
          "is_bot": false,
          "headline": "Use genericBatch in place of *pgx.Batch",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-08-23T06:15:41Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "bd75a04698056d56b4d8a78c830d12046931abac",
          "body": null,
          "is_bot": false,
          "headline": "Fix doc comments mentioning bibtex",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-08-23T05:41:46Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8d43ddabaecf1bee035c69ab062092b3ec6a0e03",
          "body": "Without the `cmd/pggen` suffix the source is downloaded, but it is not actually compiled into a binary.",
          "is_bot": false,
          "headline": "Update `go get` URL in README to actually install the command",
          "author_name": "Savvy Raghuvanshi",
          "author_login": null,
          "committed_at": "2021-06-22T01:54:21Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "cece7af82c5f4d9505ba6393784bbdf4a41590a2",
          "body": "Fixes #30.",
          "is_bot": false,
          "headline": "Add pggen version command",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-05-17T09:13:11Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0a4051d6de72ef0712b69f8522864684bab608af",
          "body": "Instead of making a proper parser that understands expressions, hardcode logic\nto match \"pggen.arg (\".\n\nFixes #34.",
          "is_bot": false,
          "headline": "Allow 1 space after pggen.arg during parsing",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-05-17T08:34:05Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6570c99972a92ea42400767acec6349cf5d9ec38",
          "body": "Really, I'd like something akin to httptrace in the Go stdlib but settle for\nthis as a light-weight stop-gap.",
          "is_bot": false,
          "headline": "Add context value with key \"pggen_query_name\"",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-29T05:59:23Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f36faea3a3270b81438dc3b6ca980a76806abf50",
          "body": null,
          "is_bot": false,
          "headline": "Remove unneeded textPreferrer wrapping around composite init factory",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-27T07:22:38Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a5b736dcd4dfe103b03fec076be17e072a3d5853",
          "body": "The bug occurs when a file alpha.sql creates a declarer that bravo.sql doesn't\nneed. When pggen templates bravo.sql, it throws away all previous declarers.",
          "is_bot": false,
          "headline": "Fix declarers from being clobbered by later files",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-26T20:03:45Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "45e3a27b07b34fdb55569c27128814379f4f2aee",
          "body": null,
          "is_bot": false,
          "headline": "Remove statik from contributing instructions",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-26T17:30:57Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0056cfbec4a2258e1e0d14a9464613861a06e551",
          "body": "Allows overriding the ValueTranscoder used by type name with NewQuerierConfig.\nWe can't use the native RegisterDataType because Querier works with pgx.Conn,\nor pgxpool.Pool which both have query methods but don't both share ConnInfo.\n\n- Upgrade pgtype for https://github.com/jackc/pgx/issues/874.\n\nRelates to #29 in that it lays the ground work for customizing types.",
          "is_bot": false,
          "headline": "Introduce typeResolver for choosing ValueTranscoders",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-26T08:37:49Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ddb0c0b95aa0b46f9f9008d6d564e8285eea49c5",
          "body": null,
          "is_bot": false,
          "headline": "Update pgx to 4.11.0",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-23T22:35:00Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6a707032170fc6fa0e50314f228fd5aba0c13d17",
          "body": "For a type SomeTable:\n\n- newSomeTable creates an uninitialized pgtype.ValueTranscoder that can decode\n  the type.\n- newSomeTableInit creates an initialized pgtype.ValueTranscoder that can decode\n  that's initialized using the raw variants through the Set method.\n- newSomeTableRaw creates the raw form of the type so that we can pass it to the\n  pgtype.ValueTranscoder Set method.",
          "is_bot": false,
          "headline": "Rename declarers for input types to Raw and Init",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-23T22:25:29Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "513d781304bc110383eaa2c7a8ec98c7e802e2a7",
          "body": null,
          "is_bot": false,
          "headline": "Fix doc comment for gotype.FindKnownTypePgx",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-23T22:21:07Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "26426a3afd0651dbd94d93255dae0aa85eb336f9",
          "body": "The triple nesting fails with the pgx bug so skip it.\n\nRelates to #29.",
          "is_bot": false,
          "headline": "Add test for int array and triply nested params",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-21T23:44:50Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "cc7780010fc7b10e07514ad6cac713fecb06aaa2",
          "body": "- Generate an assigner for every composite and array type to avoid duplicating\n  logic in the encoder and assigner methods.\n- When calling the array assigner, correctly delegate to the elem assigner if\n  necessary.\n\nRelates to #29.",
          "is_bot": false,
          "headline": "Fix params that are arrays of composite types",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-21T23:39:25Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "21dddeee1e1db65f5e40175cec14a4bb552a4792",
          "body": "When using the pgtype.Value Set method, we have to use interface{} slices all\nthe way down. Create \"assigner\" functions that create an []interface slice for\ncomposite and array types that we can use from the top level encoder functions.\n\nRelates to #29.",
          "is_bot": false,
          "headline": "Fix decoding nested composite types.",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-21T23:13:19Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b25f3a599cd304b30c2071b0044bcc61e195f258",
          "body": "Relates to #29.",
          "is_bot": false,
          "headline": "Add test example for composite types in query params",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-21T22:12:39Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7603c3867d2881889b97b6f89343f6c6884f468c",
          "body": "This supports using composite and array types in pggen.arg functions, i.e. as\nquery parameters.\n\nRelated to #29.",
          "is_bot": false,
          "headline": "Declare query param formatter for composite and array types",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-21T22:10:07Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8c7ce3994a542fedfcef9f390d7fac502129b2ac",
          "body": "We need the underlying gotype to choose appropriate encoders. For a composite\ntype, we'll wrap the expression in a encode<CompositeType> call.",
          "is_bot": false,
          "headline": "Add Type to TemplateParam",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-21T22:04:20Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "9df1767bf2a6db97508d1dd9e8c0d4efb3c575b9",
          "body": "We generate different declaration based on whether the type is an input or\noutput param. An input param needs all output params and the textEncoder.\n\nThe purpose of this change is to avoid generating unnecessary methods.",
          "is_bot": false,
          "headline": "Split FindDeclarers to FindInputDeclarers and FindOutputDeclarers",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-21T22:02:44Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "01bb30bcb7e4395240483fe2894e15e0c3f266bc",
          "body": "We need to wrap the pgtype.ValueTranscoder so we can set the preferred param\nformat to text. We need to encode params as text because we don't have the OIDs\nof the types. The Postgres binary format requires OIDs.",
          "is_bot": false,
          "headline": "Add NewTextEncoderDeclarer",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-21T21:57:24Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "346ef9a484756bbe7844dc3ab7a2db227354762b",
          "body": null,
          "is_bot": false,
          "headline": "Fix composite decoder with array field",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-20T07:50:34Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "65057b212abc55f1e60259a87f26e3bbd79c4f42",
          "body": null,
          "is_bot": false,
          "headline": "Use assignTo instead of unsafe for enum arrays",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-20T07:02:04Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c36d0826361ca21d83834dd0ea387c26778cd9a3",
          "body": null,
          "is_bot": false,
          "headline": "Use declarers for result init in generated code",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-20T06:56:44Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "096602fc0d6cfa0707c8ada6d5b8bf6d2eeaac7b",
          "body": "Not used yet. We'll enable in the next few PRs.",
          "is_bot": false,
          "headline": "Add array decoder declarer",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-20T06:46:50Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e58e85d897d90cdaed35c9c15ada701146934e1f",
          "body": null,
          "is_bot": false,
          "headline": "Move enum and composite declarers to separate files",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-20T05:45:09Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "746d952234f00da2326b6d3b5deab50280b1f375",
          "body": "Once we land array decoders, we'll convert the all generated code to use these\ndecoder factories.",
          "is_bot": false,
          "headline": "Add EnumDecoderDeclarer as replacement for emitting custom decoders",
          "author_name": "Joe Schafer",
          "author_login": "jschaf",
          "committed_at": "2021-04-20T05:37:04Z",
          "body_truncated": false,
          "is_coding_agent": false
        }
      ],
      "releases_count": 6,
      "commits_last_year": 21,
      "latest_release_at": "2026-07-20T13:14:28Z",
      "latest_release_tag": "v0.2.0",
      "releases_from_tags": true,
      "days_since_last_push": 8,
      "active_weeks_last_year": 4,
      "days_since_latest_release": 8,
      "mean_days_between_releases": 14.8
    },
    "community": {
      "has_readme": false,
      "has_license": false,
      "has_description": false,
      "has_contributing": false,
      "health_percentage": null,
      "has_issue_template": false,
      "has_code_of_conduct": false,
      "has_pull_request_template": false
    },
    "ecosystem": {
      "packages": [
        {
          "name": "github.com/meoyawn/pggen",
          "exists": true,
          "license": null,
          "keywords": [],
          "ecosystem": "go",
          "matches_repo": true,
          "registry_url": "https://pkg.go.dev/github.com/meoyawn/pggen",
          "is_deprecated": false,
          "latest_version": "v0.2.0",
          "repository_url": "https://github.com/meoyawn/pggen",
          "versions_count": 6,
          "total_downloads": null,
          "dependents_count": null,
          "deprecation_note": null,
          "maintainers_count": null,
          "monthly_downloads": null,
          "first_published_at": null,
          "latest_published_at": "2026-07-20T13:14:28Z",
          "latest_version_yanked": null,
          "days_since_latest_publish": 8
        }
      ]
    },
    "popularity": {
      "forks": 0,
      "stars": 1,
      "watchers": 0,
      "fork_history": {
        "days": [],
        "complete": true,
        "collected": 0,
        "total_forks": 0
      },
      "star_history": null,
      "open_issues_and_prs": 0
    },
    "ai_readiness": {
      "has_nix": false,
      "example_dirs": [
        "example"
      ],
      "has_llms_txt": false,
      "has_dockerfile": true,
      "has_mcp_signal": false,
      "bootstrap_files": [
        "Taskfile.yaml"
      ],
      "api_schema_files": [],
      "has_devcontainer": false,
      "typecheck_configs": [],
      "toolchain_manifests": [
        "go.mod"
      ],
      "largest_source_bytes": 19008,
      "source_files_sampled": 131,
      "oversized_source_files": 0,
      "agent_instruction_files": [],
      "agent_instruction_max_bytes": null
    },
    "dependencies": {
      "manifests": [
        "go.mod"
      ],
      "advisories": {
        "error": null,
        "scope": null,
        "source": null,
        "findings": [],
        "collected": false,
        "malicious": [],
        "truncated": false,
        "by_severity": {},
        "advisory_count": 0,
        "affected_count": 0,
        "assessed_count": 0,
        "malicious_count": 0,
        "assessed_package": null,
        "unassessed_count": 0,
        "direct_affected_count": 0
      },
      "ecosystems": [
        "go"
      ],
      "dependencies": [
        {
          "name": "github.com/bmatcuk/doublestar",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v1.3.4"
        },
        {
          "name": "github.com/docker/docker",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v28.5.2+incompatible"
        },
        {
          "name": "github.com/docker/go-connections",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v0.7.0"
        },
        {
          "name": "github.com/google/go-cmp",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v0.7.0"
        },
        {
          "name": "github.com/jackc/pgx/v5",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v5.10.0"
        },
        {
          "name": "github.com/peterbourgon/ff/v3",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v3.4.0"
        },
        {
          "name": "github.com/stretchr/testify",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v1.11.1"
        },
        {
          "name": "golang.org/x/mod",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v0.37.0"
        }
      ],
      "all_dependencies": {
        "error": "GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository",
        "source": null,
        "packages": [],
        "collected": false,
        "truncated": false,
        "total_count": null,
        "direct_count": null,
        "indirect_count": null
      }
    },
    "maintainership": {
      "issues": {
        "open_prs": 0,
        "merged_prs": 0,
        "open_issues": 0,
        "closed_ratio": 1,
        "closed_issues": 4,
        "closed_unmerged_prs": 0
      },
      "bus_factor": 1,
      "bot_contributors": 0,
      "top_contributors": [
        {
          "type": "User",
          "login": "jschaf",
          "commits": 494,
          "avatar_url": "https://avatars.githubusercontent.com/u/22385?v=4"
        },
        {
          "type": "User",
          "login": "meoyawn",
          "commits": 21,
          "avatar_url": "https://avatars.githubusercontent.com/u/1594148?v=4"
        },
        {
          "type": "User",
          "login": "0xjac",
          "commits": 2,
          "avatar_url": "https://avatars.githubusercontent.com/u/2848217?v=4"
        },
        {
          "type": "User",
          "login": "amari",
          "commits": 1,
          "avatar_url": "https://avatars.githubusercontent.com/u/534126?v=4"
        },
        {
          "type": "User",
          "login": "benjamin-thomas",
          "commits": 1,
          "avatar_url": "https://avatars.githubusercontent.com/u/1557738?v=4"
        },
        {
          "type": "User",
          "login": "bweston92",
          "commits": 1,
          "avatar_url": "https://avatars.githubusercontent.com/u/1764057?v=4"
        },
        {
          "type": "User",
          "login": "td0m",
          "commits": 1,
          "avatar_url": "https://avatars.githubusercontent.com/u/30264244?v=4"
        },
        {
          "type": "User",
          "login": "farazfazli",
          "commits": 1,
          "avatar_url": "https://avatars.githubusercontent.com/u/8684210?v=4"
        },
        {
          "type": "User",
          "login": "darkxanter",
          "commits": 1,
          "avatar_url": "https://avatars.githubusercontent.com/u/5780198?v=4"
        },
        {
          "type": "User",
          "login": "ngld",
          "commits": 1,
          "avatar_url": "https://avatars.githubusercontent.com/u/5465775?v=4"
        }
      ],
      "contributors_sampled": 10,
      "top_contributor_share": 0.943
    },
    "quality_signals": {
      "has_ci": true,
      "has_tests": true,
      "ci_workflows": [
        "go_lint.yaml",
        "go_test.yaml"
      ],
      "has_docs_dir": false,
      "linter_configs": [
        ".golangci.yaml"
      ],
      "has_editorconfig": false,
      "has_linter_config": true,
      "has_precommit_config": false
    },
    "security_signals": {
      "lockfiles": [
        "go.sum"
      ],
      "scorecard": {
        "checks": [
          {
            "name": "Binary-Artifacts",
            "score": 10,
            "reason": "no binaries found in the repo",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#binary-artifacts"
          },
          {
            "name": "Branch-Protection",
            "score": 0,
            "reason": "branch protection not enabled on development/release branches",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#branch-protection"
          },
          {
            "name": "CI-Tests",
            "score": null,
            "reason": "no pull request found",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#ci-tests"
          },
          {
            "name": "CII-Best-Practices",
            "score": 0,
            "reason": "no effort to earn an OpenSSF best practices badge detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#cii-best-practices"
          },
          {
            "name": "Code-Review",
            "score": 0,
            "reason": "Found 0/30 approved changesets -- score normalized to 0",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#code-review"
          },
          {
            "name": "Contributors",
            "score": 6,
            "reason": "project has 2 contributing companies or organizations -- score normalized to 6",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#contributors"
          },
          {
            "name": "Dangerous-Workflow",
            "score": 10,
            "reason": "no dangerous workflow patterns detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dangerous-workflow"
          },
          {
            "name": "Dependency-Update-Tool",
            "score": 0,
            "reason": "no update tool detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dependency-update-tool"
          },
          {
            "name": "Fuzzing",
            "score": 0,
            "reason": "project is not fuzzed",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#fuzzing"
          },
          {
            "name": "License",
            "score": 10,
            "reason": "license file detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#license"
          },
          {
            "name": "Maintained",
            "score": 0,
            "reason": "project was created within the last 90 days. Please review its contents carefully",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#maintained"
          },
          {
            "name": "Packaging",
            "score": null,
            "reason": "packaging workflow not detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#packaging"
          },
          {
            "name": "Pinned-Dependencies",
            "score": 0,
            "reason": "dependency not pinned by hash detected -- score normalized to 0",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#pinned-dependencies"
          },
          {
            "name": "SAST",
            "score": 0,
            "reason": "no SAST tool detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#sast"
          },
          {
            "name": "Security-Policy",
            "score": 0,
            "reason": "security policy file not detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#security-policy"
          },
          {
            "name": "Signed-Releases",
            "score": null,
            "reason": "no releases found",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#signed-releases"
          },
          {
            "name": "Token-Permissions",
            "score": 0,
            "reason": "detected GitHub workflow tokens with excessive permissions",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#token-permissions"
          },
          {
            "name": "Vulnerabilities",
            "score": 1,
            "reason": "9 existing vulnerabilities detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#vulnerabilities"
          }
        ],
        "commit": "9fc19c8979eb3592baa02c4af91db9d1fc7b0d15",
        "ran_at": "2026-07-29T08:48:33Z",
        "aggregate_score": 2.5,
        "scorecard_version": "v5.5.0"
      },
      "has_codeql_workflow": false,
      "has_security_policy": false,
      "has_dependabot_config": false
    },
    "contribution_flow": {
      "collected": true,
      "ci_last_run_at": null,
      "oldest_open_prs": [],
      "last_merged_pr_at": null,
      "ci_last_conclusion": null,
      "oldest_open_issues": []
    }
  },
  "config": {
    "disabled_metrics": [],
    "disabled_categories": [],
    "disabled_components": {}
  },
  "source": {
    "url": "https://github.com/meoyawn/pggen",
    "host": "github.com",
    "name": "pggen",
    "owner": "meoyawn"
  },
  "metrics": {
    "overall": {
      "key": "overall",
      "band": "at_risk",
      "name": "Overall health",
      "note": null,
      "notes": [],
      "value": 46,
      "inputs": {
        "security": 25,
        "vitality": 62,
        "community": 12,
        "governance": 64,
        "engineering": 52
      },
      "components": []
    },
    "categories": [
      {
        "key": "vitality",
        "band": "moderate",
        "name": "Vitality",
        "value": 62,
        "weight": 0.22,
        "metrics": [
          {
            "key": "development_activity",
            "band": "at_risk",
            "name": "Development activity",
            "note": null,
            "notes": [],
            "value": 44,
            "inputs": {
              "commits_last_year": 21,
              "human_commit_share": 1,
              "days_since_last_push": 8,
              "active_weeks_last_year": 4
            },
            "components": [
              {
                "key": "push_recency",
                "name": "Push recency",
                "detail": "last push 8 days ago",
                "points": 28.8,
                "status": "partial",
                "details": [
                  {
                    "code": "push_recency",
                    "params": {
                      "days": 8
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "commit_cadence",
                "name": "Commit cadence",
                "detail": "4/52 weeks with commits",
                "points": 2.8,
                "status": "partial",
                "details": [
                  {
                    "code": "commit_cadence_weeks",
                    "params": {
                      "weeks": 4
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "commit_volume",
                "name": "Commit volume",
                "detail": "21 commits in the last year",
                "points": 12.1,
                "status": "partial",
                "details": [
                  {
                    "code": "commits_last_year",
                    "params": {
                      "count": 21
                    }
                  }
                ],
                "max_points": 18
              },
              {
                "key": "openssf_scorecard_maintained",
                "name": "OpenSSF Scorecard: Maintained",
                "detail": "project was created within the last 90 days. Please review its contents carefully",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "release_discipline",
            "band": "excellent",
            "name": "Release discipline",
            "note": "Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Signed-Releases. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "openssf_scorecard_signed_releases"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 88,
            "inputs": {
              "releases_count": 6,
              "latest_release_tag": "v0.2.0",
              "releases_from_tags": true,
              "days_since_latest_release": 8,
              "mean_days_between_releases": 14.8
            },
            "components": [
              {
                "key": "ships_releases",
                "name": "Ships releases",
                "detail": "6 version tags (no GitHub releases)",
                "points": 16.2,
                "status": "partial",
                "details": [
                  {
                    "code": "version_tags_no_releases",
                    "params": {
                      "count": 6
                    }
                  }
                ],
                "max_points": 27
              },
              {
                "key": "release_recency",
                "name": "Release recency",
                "detail": "latest release 8 days ago",
                "points": 36,
                "status": "met",
                "details": [
                  {
                    "code": "release_recency",
                    "params": {
                      "days": 8
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "release_cadence",
                "name": "Release cadence",
                "detail": "a release every ~14.8 days",
                "points": 27,
                "status": "met",
                "details": [
                  {
                    "code": "release_cadence",
                    "params": {
                      "gap": 14.8
                    }
                  }
                ],
                "max_points": 27
              },
              {
                "key": "openssf_scorecard_signed_releases",
                "name": "OpenSSF Scorecard: Signed-Releases",
                "detail": "no releases found",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "max_points": 10
              }
            ]
          },
          {
            "key": "abandonment",
            "band": "excellent",
            "name": "Abandonment",
            "note": null,
            "notes": [],
            "value": 100,
            "inputs": {
              "cap": null,
              "state": "unverified",
              "guards": [],
              "signals": [],
              "red_flag": false,
              "multiplier_pct": 100,
              "declared_reason": null,
              "unverified_reason": "repository_too_young",
              "unanswered_open_prs": null,
              "unanswered_open_issues": null,
              "days_since_last_merged_pr": null,
              "days_since_last_human_commit": null,
              "days_since_last_human_commit_is_floor": false
            },
            "components": [
              {
                "key": "project_is_still_maintained",
                "name": "Project is still maintained",
                "detail": "maintenance record not established from the collected data",
                "points": 100,
                "status": "met",
                "details": [
                  {
                    "code": "abandonment_unverified",
                    "params": {}
                  }
                ],
                "max_points": 100
              }
            ]
          }
        ],
        "description": "Is the project alive — is code being written and are releases shipping?"
      },
      {
        "key": "community",
        "band": "critical",
        "name": "Community & Adoption",
        "value": 12,
        "weight": 0.18,
        "metrics": [
          {
            "key": "popularity",
            "band": "critical",
            "name": "Popularity & adoption",
            "note": null,
            "notes": [],
            "value": 1,
            "inputs": {
              "forks": 0,
              "stars": 1,
              "watchers": 0,
              "growth_state": "unverified",
              "growth_factor_pct": 100,
              "growth_unverified_reason": "no_history"
            },
            "components": [
              {
                "key": "stars",
                "name": "Stars",
                "detail": "1 stars",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "stars",
                    "params": {
                      "count": 1
                    }
                  }
                ],
                "max_points": 60
              },
              {
                "key": "forks",
                "name": "Forks",
                "detail": "0 forks",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "forks",
                    "params": {
                      "count": 0
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "watchers",
                "name": "Watchers",
                "detail": "0 watchers",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "watchers",
                    "params": {
                      "count": 0
                    }
                  }
                ],
                "max_points": 15
              }
            ]
          },
          {
            "key": "community_health",
            "band": "critical",
            "name": "Community health",
            "note": null,
            "notes": [],
            "value": 25,
            "inputs": {
              "has_readme": false,
              "has_license": false,
              "has_contributing": false,
              "has_issue_template": false,
              "has_code_of_conduct": false,
              "has_pull_request_template": false
            },
            "components": [
              {
                "key": "readme",
                "name": "README",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 22.5
              },
              {
                "key": "license",
                "name": "License",
                "detail": "recognized license (MIT)",
                "points": 22.5,
                "status": "met",
                "details": [
                  {
                    "code": "license_standard",
                    "params": {}
                  },
                  {
                    "code": "license_spdx",
                    "params": {
                      "spdx": "MIT"
                    }
                  }
                ],
                "max_points": 22.5
              },
              {
                "key": "contributing_guide",
                "name": "CONTRIBUTING guide",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 18
              },
              {
                "key": "code_of_conduct",
                "name": "Code of conduct",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 13.5
              },
              {
                "key": "issue_template",
                "name": "Issue template",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.2
              },
              {
                "key": "pr_template",
                "name": "PR template",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 6.3
              }
            ]
          }
        ],
        "description": "Does the project have users, downloads, attention, and a welcoming setup for contributors?"
      },
      {
        "key": "governance",
        "band": "moderate",
        "name": "Sustainability & Governance",
        "value": 64,
        "weight": 0.24,
        "metrics": [
          {
            "key": "maintainer_resilience",
            "band": "at_risk",
            "name": "Maintainer resilience (bus factor)",
            "note": null,
            "notes": [],
            "value": 30,
            "inputs": {
              "bus_factor": 1,
              "contributors_sampled": 10,
              "top_contributor_share": 0.943
            },
            "components": [
              {
                "key": "bus_factor",
                "name": "Bus factor",
                "detail": "1 contributor(s) cover half of all commits",
                "points": 9,
                "status": "partial",
                "details": [
                  {
                    "code": "bus_factor",
                    "params": {
                      "count": 1
                    }
                  }
                ],
                "max_points": 54
              },
              {
                "key": "commit_distribution",
                "name": "Commit distribution",
                "detail": "top contributor authored 94% of commits",
                "points": 1.3,
                "status": "partial",
                "details": [
                  {
                    "code": "top_contributor_share",
                    "params": {
                      "share": 94
                    }
                  }
                ],
                "max_points": 22.5
              },
              {
                "key": "contributor_breadth",
                "name": "Contributor breadth",
                "detail": "10 contributors",
                "points": 13.5,
                "status": "met",
                "details": [
                  {
                    "code": "contributors_sampled",
                    "params": {
                      "count": 10
                    }
                  }
                ],
                "max_points": 13.5
              },
              {
                "key": "openssf_scorecard_contributors",
                "name": "OpenSSF Scorecard: Contributors",
                "detail": "project has 2 contributing companies or organizations -- score normalized to 6",
                "points": 6,
                "status": "partial",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "responsiveness",
            "band": "good",
            "name": "Issue & PR responsiveness",
            "note": "Excluded from scoring (no data or not applicable): PR acceptance. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "pr_acceptance"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 76,
            "inputs": {
              "merged_prs": 0,
              "open_issues": 0,
              "closed_issues": 4,
              "issue_closed_ratio": 1,
              "closed_unmerged_prs": 0
            },
            "components": [
              {
                "key": "issue_resolution",
                "name": "Issue resolution",
                "detail": "100% of issues closed",
                "points": 46.8,
                "status": "met",
                "details": [
                  {
                    "code": "issues_closed_share",
                    "params": {
                      "share": 100
                    }
                  }
                ],
                "max_points": 46.75
              },
              {
                "key": "pr_acceptance",
                "name": "PR acceptance",
                "detail": "no decided pull requests or no data",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_decided_prs_or_data",
                    "params": {}
                  }
                ],
                "max_points": 38.25
              },
              {
                "key": "openssf_scorecard_code_review",
                "name": "OpenSSF Scorecard: Code-Review",
                "detail": "Found 0/30 approved changesets -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 15
              }
            ]
          },
          {
            "key": "stewardship",
            "band": "moderate",
            "name": "Ownership & stewardship",
            "note": "Excluded from scoring (no data or not applicable): Verified domain. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "verified_domain"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 63,
            "inputs": {
              "followers": 138,
              "owner_type": "User",
              "is_verified": null,
              "owner_login": "meoyawn",
              "public_repos": 57,
              "account_age_days": 5232
            },
            "components": [
              {
                "key": "ownership_backing",
                "name": "Ownership backing",
                "detail": "personal (user) account",
                "points": 10,
                "status": "partial",
                "details": [
                  {
                    "code": "owner_personal",
                    "params": {}
                  }
                ],
                "max_points": 30
              },
              {
                "key": "verified_domain",
                "name": "Verified domain",
                "detail": "not applicable to user accounts",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "not_applicable_to_user_accounts",
                    "params": {}
                  }
                ],
                "max_points": 20
              },
              {
                "key": "owner_reach",
                "name": "Owner reach",
                "detail": "138 followers of meoyawn",
                "points": 15.4,
                "status": "partial",
                "details": [
                  {
                    "code": "owner_followers",
                    "params": {
                      "count": 138,
                      "login": "meoyawn"
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "track_record",
                "name": "Track record",
                "detail": "57 public repos, account ~14 yr old",
                "points": 24.8,
                "status": "partial",
                "details": [
                  {
                    "code": "public_repos",
                    "params": {
                      "count": 57
                    }
                  },
                  {
                    "code": "account_age_years",
                    "params": {
                      "years": 14
                    }
                  }
                ],
                "max_points": 25
              }
            ]
          },
          {
            "key": "package_maintenance",
            "band": "excellent",
            "name": "Package maintenance",
            "note": null,
            "notes": [],
            "value": 100,
            "inputs": {
              "packages": [
                "github.com/meoyawn/pggen"
              ],
              "ecosystems": "go",
              "any_deprecated": false,
              "min_days_since_publish": 8
            },
            "components": [
              {
                "key": "published_resolvable",
                "name": "Published & resolvable",
                "detail": "1 package(s) on go",
                "points": 25,
                "status": "met",
                "details": [
                  {
                    "code": "packages_published",
                    "params": {
                      "count": 1,
                      "ecosystems": "go"
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "publish_recency",
                "name": "Publish recency",
                "detail": "latest publish 8 days ago",
                "points": 35,
                "status": "met",
                "details": [
                  {
                    "code": "publish_recency",
                    "params": {
                      "days": 8
                    }
                  }
                ],
                "max_points": 35
              },
              {
                "key": "version_history",
                "name": "Version history",
                "detail": "6 published versions",
                "points": 20,
                "status": "met",
                "details": [
                  {
                    "code": "published_versions",
                    "params": {
                      "count": 6
                    }
                  }
                ],
                "max_points": 20
              },
              {
                "key": "not_deprecated",
                "name": "Not deprecated",
                "detail": "active, not deprecated or yanked",
                "points": 20,
                "status": "met",
                "details": [
                  {
                    "code": "package_not_deprecated",
                    "params": {}
                  }
                ],
                "max_points": 20
              }
            ]
          }
        ],
        "description": "Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep?"
      },
      {
        "key": "engineering",
        "band": "moderate",
        "name": "Engineering Quality",
        "value": 52,
        "weight": 0.2,
        "metrics": [
          {
            "key": "engineering_practices",
            "band": "good",
            "name": "Engineering practices",
            "note": "Excluded from scoring (no data or not applicable): OpenSSF Scorecard: CI-Tests. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "openssf_scorecard_ci_tests"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 80,
            "inputs": {
              "has_ci": true,
              "has_tests": true,
              "has_editorconfig": false,
              "has_linter_config": true,
              "has_precommit_config": false
            },
            "components": [
              {
                "key": "ci_workflows",
                "name": "CI workflows",
                "detail": "2 workflow(s)",
                "points": 24,
                "status": "met",
                "details": [
                  {
                    "code": "ci_workflows",
                    "params": {
                      "count": 2
                    }
                  }
                ],
                "max_points": 24
              },
              {
                "key": "tests_present",
                "name": "Tests present",
                "detail": null,
                "points": 24,
                "status": "met",
                "details": [],
                "max_points": 24
              },
              {
                "key": "linter_config",
                "name": "Linter config",
                "detail": ".golangci.yaml",
                "points": 16,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": ".golangci.yaml"
                    }
                  }
                ],
                "max_points": 16
              },
              {
                "key": "pre_commit_hooks",
                "name": "Pre-commit hooks",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 9.6
              },
              {
                "key": "editorconfig",
                "name": ".editorconfig",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 6.4
              },
              {
                "key": "openssf_scorecard_ci_tests",
                "name": "OpenSSF Scorecard: CI-Tests",
                "detail": "no pull request found",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "max_points": 20
              }
            ]
          },
          {
            "key": "documentation",
            "band": "critical",
            "name": "Documentation",
            "note": null,
            "notes": [],
            "value": 10,
            "inputs": {
              "topics": [],
              "has_wiki": true,
              "homepage": null,
              "has_readme": false,
              "has_docs_dir": false,
              "has_description": false
            },
            "components": [
              {
                "key": "readme",
                "name": "README",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 30
              },
              {
                "key": "documentation_directory",
                "name": "Documentation directory",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 25
              },
              {
                "key": "documentation_homepage_site",
                "name": "Documentation / homepage site",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 15
              },
              {
                "key": "repository_description",
                "name": "Repository description",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 10
              },
              {
                "key": "topics",
                "name": "Topics",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 10
              },
              {
                "key": "wiki",
                "name": "Wiki",
                "detail": null,
                "points": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              }
            ]
          }
        ],
        "description": "Are baseline engineering and documentation practices in place?"
      },
      {
        "key": "security",
        "band": "critical",
        "name": "Security",
        "value": 25,
        "weight": 0.16,
        "metrics": [
          {
            "key": "security_posture",
            "band": "critical",
            "name": "Security posture",
            "note": "Excluded from scoring (no data or not applicable): CI-Tests, Packaging, Signed-Releases. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "ci_tests",
                    "packaging",
                    "signed_releases"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 25,
            "inputs": {
              "source": "openssf_scorecard",
              "checks_evaluated": 15,
              "scorecard_version": "v5.5.0",
              "checks_inconclusive": 3,
              "scorecard_aggregate": 2.5
            },
            "components": [
              {
                "key": "binary_artifacts",
                "name": "Binary-Artifacts",
                "detail": "no binaries found in the repo",
                "points": 7.5,
                "status": "met",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "branch_protection",
                "name": "Branch-Protection",
                "detail": "branch protection not enabled on development/release branches",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "ci_tests",
                "name": "CI-Tests",
                "detail": "no pull request found",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "max_points": 2.5
              },
              {
                "key": "cii_best_practices",
                "name": "CII-Best-Practices",
                "detail": "no effort to earn an OpenSSF best practices badge detected",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 2.5
              },
              {
                "key": "code_review",
                "name": "Code-Review",
                "detail": "Found 0/30 approved changesets -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "contributors",
                "name": "Contributors",
                "detail": "project has 2 contributing companies or organizations -- score normalized to 6",
                "points": 1.5,
                "status": "partial",
                "details": [],
                "max_points": 2.5
              },
              {
                "key": "dangerous_workflow",
                "name": "Dangerous-Workflow",
                "detail": "no dangerous workflow patterns detected",
                "points": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              },
              {
                "key": "dependency_update_tool",
                "name": "Dependency-Update-Tool",
                "detail": "no update tool detected",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "fuzzing",
                "name": "Fuzzing",
                "detail": "project is not fuzzed",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 5
              },
              {
                "key": "license",
                "name": "License",
                "detail": "license file detected",
                "points": 2.5,
                "status": "met",
                "details": [],
                "max_points": 2.5
              },
              {
                "key": "maintained",
                "name": "Maintained",
                "detail": "project was created within the last 90 days. Please review its contents carefully",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "packaging",
                "name": "Packaging",
                "detail": "packaging workflow not detected",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "max_points": 5
              },
              {
                "key": "pinned_dependencies",
                "name": "Pinned-Dependencies",
                "detail": "dependency not pinned by hash detected -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 5
              },
              {
                "key": "sast",
                "name": "SAST",
                "detail": "no SAST tool detected",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 5
              },
              {
                "key": "security_policy",
                "name": "Security-Policy",
                "detail": "security policy file not detected",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 5
              },
              {
                "key": "signed_releases",
                "name": "Signed-Releases",
                "detail": "no releases found",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "max_points": 7.5
              },
              {
                "key": "token_permissions",
                "name": "Token-Permissions",
                "detail": "detected GitHub workflow tokens with excessive permissions",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "vulnerabilities",
                "name": "Vulnerabilities",
                "detail": "9 existing vulnerabilities detected",
                "points": 0.8,
                "status": "partial",
                "details": [],
                "max_points": 7.5
              }
            ]
          },
          {
            "key": "high_risk_jurisdiction_exposure",
            "band": "excellent",
            "name": "High-Risk Jurisdiction Exposure",
            "note": "Only high-confidence self-published location evidence affects this multiplier. Ambiguous matches are review-only; country evidence is not proof of nationality, citizenship, legal registration, malicious intent, or sanctions status.",
            "notes": [
              {
                "code": "jurisdiction_evidence_limits",
                "params": {}
              }
            ],
            "value": 100,
            "inputs": {
              "meaning": "self-published location evidence; not nationality or citizenship",
              "red_flag": false,
              "exposures": [],
              "policy_countries": [
                "Russia",
                "Iran",
                "North Korea"
              ],
              "review_only_matches": 0,
              "assessed_self_published_locations": 7
            },
            "components": [
              {
                "key": "policy_exposure_multiplier",
                "name": "Policy exposure multiplier",
                "detail": "no confirmed policy-scope location match",
                "points": 100,
                "status": "met",
                "details": [
                  {
                    "code": "jurisdiction_no_match",
                    "params": {}
                  }
                ],
                "max_points": 100
              }
            ]
          }
        ],
        "description": "Are visible security and supply-chain practices strong, with no malicious dependency and no unresolved high-risk jurisdiction exposure?"
      },
      {
        "key": "ai_readiness",
        "band": "moderate",
        "name": "AI Readiness",
        "value": 57,
        "weight": 0,
        "metrics": [
          {
            "key": "ai_agent_context",
            "band": "critical",
            "name": "Agent context & guidance",
            "note": null,
            "notes": [],
            "value": 25,
            "inputs": {
              "has_llms_txt": false,
              "legible_history_share": 0.47,
              "agent_instruction_files": [],
              "agent_instruction_max_bytes": null
            },
            "components": [
              {
                "key": "agent_instructions",
                "name": "Agent instructions",
                "detail": "no CLAUDE.md / AGENTS.md / editor rules",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "no_agent_instructions",
                    "params": {}
                  }
                ],
                "max_points": 45
              },
              {
                "key": "machine_readable_docs_llms_txt",
                "name": "Machine-readable docs (llms.txt)",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 15
              },
              {
                "key": "legible_commit_history",
                "name": "Legible commit history",
                "detail": "47 of 100 human commits state their intent (structured subject or explanatory body)",
                "points": 25.1,
                "status": "partial",
                "details": [
                  {
                    "code": "legible_history",
                    "params": {
                      "legible": 47,
                      "sampled": 100
                    }
                  }
                ],
                "max_points": 40
              }
            ]
          },
          {
            "key": "ai_verify_loop",
            "band": "good",
            "name": "Verify loop (build / test / typecheck)",
            "note": null,
            "notes": [],
            "value": 72,
            "inputs": {
              "has_nix": false,
              "has_tests": true,
              "lockfiles": [
                "go.sum"
              ],
              "has_dockerfile": true,
              "typed_language": true,
              "bootstrap_files": [
                "Taskfile.yaml"
              ],
              "has_devcontainer": false,
              "has_linter_config": true,
              "typecheck_configs": [],
              "agent_commit_share": 0,
              "toolchain_manifests": [
                "go.mod"
              ],
              "dependency_bot_commit_share": 0
            },
            "components": [
              {
                "key": "one_command_bootstrap",
                "name": "One-command bootstrap",
                "detail": "Taskfile.yaml",
                "points": 18,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "Taskfile.yaml"
                    }
                  }
                ],
                "max_points": 18
              },
              {
                "key": "automated_tests",
                "name": "Automated tests",
                "detail": null,
                "points": 22,
                "status": "met",
                "details": [],
                "max_points": 22
              },
              {
                "key": "lint_format_config",
                "name": "Lint / format config",
                "detail": ".golangci.yaml",
                "points": 11,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": ".golangci.yaml"
                    }
                  }
                ],
                "max_points": 11
              },
              {
                "key": "static_type_checking",
                "name": "Static type checking",
                "detail": "Go (statically typed)",
                "points": 11,
                "status": "met",
                "details": [
                  {
                    "code": "statically_typed_language",
                    "params": {
                      "language": "Go"
                    }
                  }
                ],
                "max_points": 11
              },
              {
                "key": "reproducible_environment",
                "name": "Reproducible environment",
                "detail": "Dockerfile, lockfile",
                "points": 10,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "Dockerfile, lockfile"
                    }
                  }
                ],
                "max_points": 10
              },
              {
                "key": "demonstrated_agent_practice",
                "name": "Demonstrated agent practice",
                "detail": "no agent-authored commits among the last 100",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "no_agent_authored_commits",
                    "params": {
                      "sampled": 100
                    }
                  }
                ],
                "max_points": 10
              },
              {
                "key": "automated_maintenance",
                "name": "Automated maintenance",
                "detail": "no automated dependency updates observed",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "no_dependency_automation",
                    "params": {}
                  }
                ],
                "max_points": 8
              },
              {
                "key": "openssf_scorecard_pinned_dependencies",
                "name": "OpenSSF Scorecard: Pinned-Dependencies",
                "detail": "dependency not pinned by hash detected -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "ai_code_legibility",
            "band": "excellent",
            "name": "Code legibility for models",
            "note": null,
            "notes": [],
            "value": 100,
            "inputs": {
              "primary_language": "Go",
              "largest_source_bytes": 19008,
              "source_files_sampled": 131,
              "oversized_source_files": 0
            },
            "components": [
              {
                "key": "type_checkable_code",
                "name": "Type-checkable code",
                "detail": "Go (statically typed)",
                "points": 45,
                "status": "met",
                "details": [
                  {
                    "code": "statically_typed_language",
                    "params": {
                      "language": "Go"
                    }
                  }
                ],
                "max_points": 45
              },
              {
                "key": "manageable_file_sizes",
                "name": "Manageable file sizes",
                "detail": "0/131 source files over 60KB",
                "points": 55,
                "status": "met",
                "details": [
                  {
                    "code": "oversized_source_files",
                    "params": {
                      "kb": 60,
                      "sampled": 131,
                      "oversized": 0
                    }
                  }
                ],
                "max_points": 55
              }
            ]
          },
          {
            "key": "ai_interfaces",
            "band": "at_risk",
            "name": "Machine-readable interfaces",
            "note": null,
            "notes": [],
            "value": 40,
            "inputs": {
              "example_dirs": [
                "example"
              ],
              "has_mcp_signal": false,
              "api_schema_files": []
            },
            "components": [
              {
                "key": "api_schema_openapi_graphql_proto",
                "name": "API schema (OpenAPI/GraphQL/proto)",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 40
              },
              {
                "key": "mcp_server",
                "name": "MCP server",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 20
              },
              {
                "key": "runnable_examples",
                "name": "Runnable examples",
                "detail": "example",
                "points": 40,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "example"
                    }
                  }
                ],
                "max_points": 40
              }
            ]
          }
        ],
        "description": "How well is the repo equipped to be developed and maintained with AI coding agents? An independent, experimental badge — weight 0.0, so it is surfaced on its own and does not affect the overall health score."
      }
    ],
    "metrics_version": "1.13.0"
  },
  "warnings": [
    "Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token",
    "Community profile unavailable",
    "GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository"
  ],
  "report_type": "repository",
  "generated_at": "2026-07-29T08:48:42.168782Z",
  "schema_version": "0.27.0",
  "badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/m/meoyawn/pggen.svg",
  "full_name": "meoyawn/pggen",
  "license_state": "standard",
  "license_spdx": "MIT"
}