Public record
Software health reportschema 0.27.0 · metrics 1.13.0 · 2026-07-23 19:31 UTC

foxcpp / go-imap-sql

SQL-based storage backend for go-imap v2

GoMIT★ 26 stars⑂ 12 forkssince Feb 2019View on GitHub ↗

foxcpp/go-imap-sql holds a health index of 8 out of 100, placing it in the Critical band. It scores highest on AI Readiness (56/100) and lowest on Security (24/100). It was last updated 102 days ago. A single contributor accounts for most of its recent work.

8
overall / 100
Critical

Software health index

Metrics are grouped into weighted categories on one standardized 1–100 scale. Overall starts as their weighted mean; when public evidence triggers the High-Risk Jurisdiction Policy, the rating is adjusted and receives an At risk ceiling of 49. AI Readiness sits outside the overall score.

8
Excellent85-100Exemplary; meets essentially all checked criteria
Good70-84Healthy; minor gaps
Moderate50-69Acceptable with notable gaps; review recommended
At risk30-49Significant weaknesses; adoption warrants caution
Critical1-29Severe problems (abandoned, single-maintainer, no hygiene)
VitalityCommunity &AdoptionSustainability &GovernanceEngineeringQualitySecurityAI Readiness

Score profile

Each axis is a category. The shape matters more than the average — a healthy subject fills the whole shape, while a spike-and-crater profile means strength in one dimension is masking risk in another.

High-Risk Jurisdiction Policy applies a 20% multiplier to weighted overall health and gives it an At risk ceiling of 49.

Ownership

Max MazurovPersonal account
221 followers72 public repossince Mar 2018VK Tech

This repository is owned by a personal account. A single-owner project carries more continuity risk than an organization-backed one.

Package ecosystems

RegistryPackageVersionDownloads / moVersionsLast publish
Gogithub.com/foxcpp/go-imap-sqlv0.5.0-62160 days ago

Metrics by category

Vitality

Is the project alive — is code being written and are releases shipping?

27Critical · 22% of overall
How it's scored
9.9/36Push recency — last push 102 days ago
0.7/36Commit cadence — 1/52 weeks with commits
4.3/18Commit volume — 2 commits in the last year
0/10OpenSSF Scorecard: Maintained — 0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0
Inputs used
commits_last_year2
human_commit_share1
days_since_last_push102
active_weeks_last_year1
How it's scored
27/27Ships releases — 6 releases published
0/36Release recency — latest release 1,808 days ago
12.6/27Release cadence — a release every ~165.6 days
0/10OpenSSF Scorecard: Signed-Releases — no data
Inputs used
releases_count6
latest_release_tagv0.5.0
releases_from_tagsno
days_since_latest_release1,808
mean_days_between_releases165.6
Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Signed-Releases. Remaining weights renormalized.

Community & Adoption

Does the project have users, downloads, attention, and a welcoming setup for contributors?

41At risk · 18% of overall
How it's scored
22.7/60Stars — 26 stars
8.7/25Forks — 12 forks
1.7/15Watchers — 3 watchers
Inputs used
forks12
stars26
watchers3
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history
How it's scored
22.5/22.5README
22.5/22.5License — recognized license (MIT)
0/18CONTRIBUTING guide
0/13.5Code of conduct
0/7.2Issue template
0/6.3PR template
Inputs used
has_readmeyes
has_licenseyes
has_contributingno
has_issue_templateno
has_code_of_conductno
has_pull_request_templateno

Sustainability & Governance

Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep?

51Moderate · 24% of overall
How it's scored
9/54Bus factor — 1 contributor(s) cover half of all commits
0.5/22.5Commit distribution — top contributor authored 98% of commits
5.4/13.5Contributor breadth — 4 contributors
3/10OpenSSF Scorecard: Contributors — project has 1 contributing companies or organizations -- score normalized to 3
Inputs used
bus_factor1
contributors_sampled4
top_contributor_share0.98
How it's scored
23.9/46.8Issue resolution — 51% of issues closed
38.2/38.3PR acceptance — 4/4 decided PRs merged
1.5/15OpenSSF Scorecard: Code-Review — Found 3/27 approved changesets -- score normalized to 1
Inputs used
merged_prs4
open_issues20
closed_issues21
issue_closed_ratio0.512
closed_unmerged_prs0
How it's scored
10/30Ownership backing — personal (user) account
0/20Verified domain — not applicable to user accounts
16.9/25Owner reach — 221 followers of foxcpp
25/25Track record — 72 public repos, account ~8 yr old
Inputs used
followers221
owner_typeUser
is_verified
owner_loginfoxcpp
public_repos72
account_age_days3,038
Excluded from scoring (no data or not applicable): Verified domain. Remaining weights renormalized.
How it's scored
25/25Published & resolvable — 1 package(s) on go
4/35Publish recency — latest publish 2,160 days ago
20/20Version history — 6 published versions
20/20Not deprecated — active, not deprecated or yanked
Inputs used
packagesgithub.com/foxcpp/go-imap-sql
ecosystemsgo
any_deprecatedno
min_days_since_publish2,160

Engineering Quality

Are baseline engineering and documentation practices in place?

44At risk · 20% of overall
How it's scored
0/24CI workflows
24/24Tests present
16/16Linter config — .golangci.yml
0/9.6Pre-commit hooks
0/6.4.editorconfig
0/20OpenSSF Scorecard: CI-Tests — 0 out of 3 merged PRs checked by a CI test -- score normalized to 0
Inputs used
has_cino
has_testsyes
has_editorconfigno
has_linter_configyes
has_precommit_configno

Documentation

50Moderate
How it's scored
30/30README
0/25Documentation directory
0/15Documentation / homepage site
10/10Repository description
10/10Topics — 3 topics
0/10Wiki
Inputs used
topicsimap, imap-server, mail
has_wikino
homepage
has_readmeyes
has_docs_dirno
has_descriptionyes

Security

Are visible security and supply-chain practices strong, without unresolved high-risk jurisdiction exposure?

24Critical · 16% of overall
How it's scored
7.5/7.5Binary-Artifacts — no binaries found in the repo
0/7.5Branch-Protection — branch protection not enabled on development/release branches
0/2.5CI-Tests — 0 out of 3 merged PRs checked by a CI test -- score normalized to 0
0/2.5CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected
0.8/7.5Code-Review — Found 3/27 approved changesets -- score normalized to 1
0.8/2.5Contributors — project has 1 contributing companies or organizations -- score normalized to 3
0/10Dangerous-Workflow — no data
0/7.5Dependency-Update-Tool — no update tool detected
0/5Fuzzing — project is not fuzzed
2.5/2.5License — license file detected
0/7.5Maintained — 0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0
0/5Packaging — no data
0/5Pinned-Dependencies — no data
0/5SAST — SAST tool is not run on all commits -- score normalized to 0
0/5Security-Policy — security policy file not detected
0/7.5Signed-Releases — no data
0/7.5Token-Permissions — no data
6.8/7.5Vulnerabilities — 1 existing vulnerabilities detected
Inputs used
sourceopenssf_scorecard
checks_evaluated13
scorecard_versionv5.5.0
checks_inconclusive5
scorecard_aggregate2.6
high_risk_jurisdiction_cap49
high_risk_jurisdiction_multiplier20
security_posture_after_multiplier5
security_posture_before_jurisdiction26
Excluded from scoring (no data or not applicable): dangerous_workflow, packaging, pinned_dependencies, signed_releases, token_permissions. Remaining weights renormalized. High-Risk Jurisdiction Policy applies a 20% multiplier and gives Security posture an At risk ceiling of 49.
How it's scored
35/35Direct dependencies free of known advisories — no direct dependency carries a known advisory
0/25Indirect dependencies free of known advisories — transitive set not separable from development and test dependencies in this scope
0/40No advisories left outstanding — no advisory carries a publication date
Inputs used
sourceosv
advisories0
affected_packages0
assessed_packages18
unassessed_packages0
affected_by_severitynone
direct_affected_packages0
Excluded from scoring (no data or not applicable): Indirect dependencies free of known advisories, No advisories left outstanding. Remaining weights renormalized. Matched 18 resolved dependencies against OSV. This repository publishes no package the index resolves, so the repository dependency graph was assessed instead. That graph mixes development and test pins with shipped dependencies, so only the declared runtime dependencies are scored; transitive findings are reported as context and excluded from the score. Reachability is not analyzed.

AI Readiness

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.

56Moderate · 0% of overall
How it's scored
0/45Agent instructions — no CLAUDE.md / AGENTS.md / editor rules
0/15Machine-readable docs (llms.txt)
9.6/40Legible commit history — 18 of 100 human commits state their intent (structured subject or explanatory body)
Inputs used
has_llms_txtno
legible_history_share0.18
agent_instruction_files
agent_instruction_max_bytes
How it's scored
12.6/18One-command bootstrap — go.mod (toolchain convention, no task runner)
22/22Automated tests
11/11Lint / format config — .golangci.yml
11/11Static type checking — Go (statically typed)
10/10Reproducible environment — lockfile
0/10Demonstrated agent practice — no agent-authored commits among the last 100
0/8Automated maintenance — no automated dependency updates observed
0/10OpenSSF Scorecard: Pinned-Dependencies — no data
Inputs used
has_nixno
has_testsyes
lockfilesgo.sum
has_dockerfileno
typed_languageyes
bootstrap_files
has_devcontainerno
has_linter_configyes
typecheck_configs
agent_commit_share0
toolchain_manifestsgo.mod
dependency_bot_commit_share0
Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Pinned-Dependencies. Remaining weights renormalized.
How it's scored
45/45Type-checkable code — Go (statically typed)
55/55Manageable file sizes — 0/43 source files over 60KB
Inputs used
primary_languageGo
largest_source_bytes24,875
source_files_sampled43
oversized_source_files0

Key facts

26GitHub stars
4contributors
2commits, last 12 months
102days since last push
6releases
1bus factor
20open issues
Gopackage ecosystems

Data collection warnings

  • Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token

More detail

Star and fork history 0 ★ / 12 ⇿
0Stars
12Forks
6Releases

When each star and fork was added, collected from GitHub and bucketed by day. Cumulative growth sits directly above the daily additions it is made of, so the two read against each other: steady organic accretion looks nothing like an abrupt, short-lived burst. Where that difference is measurable, it is reported as growth authenticity.

0246810121222019-032022-082026-02
Major 0Minor 5Patch 1

Each point covers 7 days.

OpenSSF Scorecard 2.6 / 10
2.6aggregate

Independent, tool-agnostic security assessment from the open-source OpenSSF Scorecard. Each check rewards a security practice, not a specific vendor's tool. Checks Scorecard could not determine are marked n/a and excluded from the security score (never counted as zero).Scorecard v5.5.0 · 2026-07-23 19:31 UTC

10Binary-Artifactsno binaries found in the repo
0Branch-Protectionbranch protection not enabled on development/release branches
0CI-Tests0 out of 3 merged PRs checked by a CI test -- score normalized to 0
0CII-Best-Practicesno effort to earn an OpenSSF best practices badge detected
1Code-ReviewFound 3/27 approved changesets -- score normalized to 1
3Contributorsproject has 1 contributing companies or organizations -- score normalized to 3
n/aDangerous-Workflowno workflows found
0Dependency-Update-Toolno update tool detected
0Fuzzingproject is not fuzzed
10Licenselicense file detected
0Maintained0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0
n/aPackagingpackaging workflow not detected
n/aPinned-Dependenciesno dependencies found
0SASTSAST tool is not run on all commits -- score normalized to 0
0Security-Policysecurity policy file not detected
n/aSigned-Releasesno releases found
n/aToken-PermissionsNo tokens found
9Vulnerabilities1 existing vulnerabilities detected
Direct dependencies 14
RegistryPackageVersion constraintManifest
Gogithub.com/emersion/go-imapv1.2.2-0.20220928192137-6fac715be9cfgo.mod
Gogithub.com/emersion/go-imap-sortthreadv1.2.0go.mod
Gogithub.com/emersion/go-messagev0.18.0go.mod
Gogithub.com/foxcpp/go-imap-backend-testsv0.0.0-20220105184719-e80aa29a5e16go.mod
Gogithub.com/foxcpp/go-imap-messv0.0.0-20230108134257-b7ec3a649613go.mod
Gogithub.com/foxcpp/go-imap-namespacev0.0.0-20200802091432-08496dd8e0edgo.mod
Gogithub.com/go-sql-driver/mysqlv1.7.1go.mod
Gogithub.com/klauspost/compressv1.17.4go.mod
Gogithub.com/lib/pqv1.10.9go.mod
Gogithub.com/mailru/easyjsonv0.7.7go.mod
Gogithub.com/mattn/go-sqlite3v1.14.19go.mod
Gogithub.com/pierrec/lz4v2.6.1+incompatiblego.mod
Gogithub.com/urfave/cliv1.22.14go.mod
Gogotest.toolsv2.2.0+incompatiblego.mod
All dependencies 18

Full resolved dependency set from the GitHub dependency graph: 14 direct and 4 indirect (transitive) packages. The transitive closure is complete when the repository commits a lockfile.

RegistryPackageVersionRelation
Gogithub.com/emersion/go-imap1.2.2-0.20220928192137-6fac715be9cfdirect
Gogithub.com/emersion/go-imap-sortthread1.2.0direct
Gogithub.com/emersion/go-message0.18.0direct
Gogithub.com/foxcpp/go-imap-backend-tests0.0.0-20220105184719-e80aa29a5e16direct
Gogithub.com/foxcpp/go-imap-mess0.0.0-20230108134257-b7ec3a649613direct
Gogithub.com/foxcpp/go-imap-namespace0.0.0-20200802091432-08496dd8e0eddirect
Gogithub.com/go-sql-driver/mysql1.7.1direct
Gogithub.com/klauspost/compress1.17.4direct
Gogithub.com/lib/pq1.10.9direct
Gogithub.com/mailru/easyjson0.7.7direct
Gogithub.com/mattn/go-sqlite31.14.19direct
Gogithub.com/pierrec/lz42.6.1+incompatibledirect
Gogithub.com/urfave/cli1.22.14direct
Gogotest.tools2.2.0+incompatibledirect
Gogithub.com/cpuguy83/go-md2man/v22.0.3indirect
Gogithub.com/emersion/go-sasl0.0.0-20231106173351-e73c9f7bad43indirect
Gogithub.com/frankban/quicktest1.5.0indirect
Gogithub.com/google/go-cmp0.5.5indirect
Dependency advisories 0

This repository publishes no package the index resolves, so its own dependency graph was assessed — 18 packages, which also include development and test pins that never ship: 0 carry known advisories, of which 0 are direct.

No known advisories affect the assessed dependencies.

An advisory means the version recorded in the dependency graph falls inside an advisory’s affected range. Reachability is not analysed, and the graph includes development and test pins — a finding may concern tooling rather than shipped software.

Raw JSON report machine-readable
{
  "data": {
    "repo": {
      "topics": [
        "imap",
        "imap-server",
        "mail"
      ],
      "is_fork": false,
      "size_kb": 475,
      "has_wiki": false,
      "homepage": null,
      "languages": {
        "Go": 195105
      },
      "pushed_at": "2026-04-12T19:09:42Z",
      "created_at": "2019-02-22T18:55:37Z",
      "owner_type": "User",
      "updated_at": "2026-05-07T15:56:58Z",
      "description": "SQL-based storage backend for go-imap v2",
      "is_archived": false,
      "is_disabled": false,
      "license_spdx": "MIT",
      "default_branch": "master",
      "license_spdx_raw": "MIT",
      "primary_language": "Go",
      "significant_languages": [
        "Go"
      ]
    },
    "owner": {
      "blog": null,
      "name": "Max Mazurov",
      "type": "User",
      "login": "foxcpp",
      "company": "VK Tech",
      "location": "Moscow, Russia",
      "followers": 221,
      "avatar_url": "https://avatars.githubusercontent.com/u/37885127?v=4",
      "created_at": "2018-03-28T22:27:39Z",
      "is_verified": null,
      "public_repos": 72,
      "account_age_days": 3038
    },
    "license": {
      "state": "standard",
      "spdx_id": "MIT",
      "raw_spdx": "MIT",
      "file_present": true,
      "scorecard_found": true,
      "profile_has_license": true
    },
    "activity": {
      "releases": [
        {
          "tag": "v0.5.0",
          "kind": "minor",
          "published_at": "2021-08-10T17:09:37Z"
        },
        {
          "tag": "v0.4.0",
          "kind": "minor",
          "published_at": "2020-02-26T21:35:16Z"
        },
        {
          "tag": "v0.3.1",
          "kind": "patch",
          "published_at": "2019-06-09T21:40:58Z"
        },
        {
          "tag": "v0.3.0",
          "kind": "minor",
          "published_at": "2019-05-29T10:12:33Z"
        },
        {
          "tag": "v0.2.0",
          "kind": "minor",
          "published_at": "2019-05-20T17:48:20Z"
        },
        {
          "tag": "v0.1.0",
          "kind": "minor",
          "published_at": "2019-05-05T15:32:02Z"
        }
      ],
      "recent_commits": [
        {
          "oid": "b5e85e90f14d8fecc7082fa9de82f93d47c048c4",
          "body": "Read Committed will do just fine in most cases. Remaining specific\ncases already explicitly use Repeatable Read.",
          "is_bot": false,
          "headline": "Stop using Repeatable Read isolation by default",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2026-04-12T18:45:17Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "20097edd35ec6c5cff85e3fa393c59de603deac4",
          "body": null,
          "is_bot": false,
          "headline": "Fix SQLite transaction upgrade problem resulting in SQLITE_BUSY spam",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2026-04-12T13:31:45Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8da5567429d5050a302362112770c4a135110f6a",
          "body": null,
          "is_bot": false,
          "headline": "Fix dbhacks.go ALERT TABLE typo",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2025-01-24T14:00:07Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "655e4cb87d20312621e67eb6add387518082ce9c",
          "body": null,
          "is_bot": false,
          "headline": "Check for modernc sqlite driver in dbhacks",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2024-08-31T12:22:36Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ee5bc28d4278a40b348b5461f203e1211147bfda",
          "body": null,
          "is_bot": false,
          "headline": "Fix-up pg.Error reference",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2024-02-14T17:22:11Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7f314a0fe78a40571b5c182bebaf85b013faaa14",
          "body": null,
          "is_bot": false,
          "headline": "go get -u ./... && go mod tidy",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2024-01-21T16:02:44Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "48f9dc0b4abfd985b8cfefb2309af532eabeecd9",
          "body": null,
          "is_bot": false,
          "headline": "Add support for modernc.org/sqlite driver",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2024-01-20T17:41:34Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "507a39800ed7fdeffde49086c039df9f3c6886df",
          "body": null,
          "is_bot": false,
          "headline": "Fix sorting algorithm",
          "author_name": "ptrcnull",
          "author_login": "ptrcnull",
          "committed_at": "2023-05-04T18:50:13Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c0176dad679cec731960369b01dc8242bf10ea6d",
          "body": "Apparently, people have more than 10k messages in a folder.",
          "is_bot": false,
          "headline": "Bump uidMap limitation to 100k and log a warning for large mailboxes",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2023-03-13T08:04:58Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "2c2868ce7ca7123c806bed2220657fa021705dca",
          "body": null,
          "is_bot": false,
          "headline": "Fix-up 96c5127f5348dbd503083fe6d18c09bfc9e9cda1",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2023-01-19T22:57:22Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7d6532f9a71fdf8dd41f5049be1e83d93003b292",
          "body": null,
          "is_bot": false,
          "headline": "Fixing wrong variable reassignment in sortthread.",
          "author_name": "Riad Vargas",
          "author_login": "RiadVargas",
          "committed_at": "2023-01-19T22:56:32Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4c0f39a1ad632f94cc69f1f5f0da3326598e43c6",
          "body": null,
          "is_bot": false,
          "headline": "Relying on `msgs` table for searches.",
          "author_name": "Riad Vargas",
          "author_login": "RiadVargas",
          "committed_at": "2023-01-19T22:56:32Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "df3b66a5b04f4036237d7b150c134b5279be8835",
          "body": "Lack of UIDs sorting trips go-imap-mess algorithms\nthat expect sorted uidsMap (e.g. for binary search).\n\nSee https://github.com/foxcpp/maddy/issues/512",
          "is_bot": false,
          "headline": "Ensure consistent ordering for messages and mailboxes",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2022-06-27T22:05:18Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7af3dd26e54c10e796ff4b4b8ccc6f3a58b4e871",
          "body": null,
          "is_bot": false,
          "headline": "Merge pull request #40",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2022-06-25T17:44:39Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "26d630d396a32a5262774d12991a50f96f26e18c",
          "body": "…l into ptrcnull-date-formats",
          "is_bot": false,
          "headline": "Merge branch 'date-formats' of https://github.com/ptrcnull/go-imap-sq…",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2022-06-25T17:44:13Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "220be7ba4d1996213523f49e82f92caa5e06bac3",
          "body": null,
          "is_bot": false,
          "headline": "Fix-up 70f09b5f83c9497d72a9b562b976615fc222dcda",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2022-06-25T15:46:04Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "70f09b5f83c9497d72a9b562b976615fc222dcda",
          "body": "* Bump go-imap-mess version and pass key to management handle\n* Never auto-set \\Seen if mailbox is open read-only\n* Add missing ResolveSeq call to DeleteMessages",
          "is_bot": false,
          "headline": "More v2 fixes",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2022-06-25T15:38:06Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6e3bebef681a7c6919a5274746b7c7ed8b60e373",
          "body": null,
          "is_bot": false,
          "headline": "Use go-imap-mess ManagementHandle for connection-less Mailbox handles",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2022-06-25T12:16:48Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c20be1a387b4bc727cda5ed4079996d87c7c89e1",
          "body": null,
          "is_bot": false,
          "headline": "Merge branch 'dev'",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2022-06-23T18:16:04Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ff6140707c5aa21c8fcb2adcc1c9383fee68b7b4",
          "body": null,
          "is_bot": false,
          "headline": "Fix non-functional schema upgrade",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2022-06-23T18:13:32Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "fd47f96410d5f91f93f845fe321fe541c9aa67d8",
          "body": null,
          "is_bot": false,
          "headline": "Parse date correctly while sorting messages",
          "author_name": "ptrcnull",
          "author_login": "ptrcnull",
          "committed_at": "2022-05-21T01:25:26Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "06843d8225284c46fe97cc0d19f637ec0a3d18df",
          "body": null,
          "is_bot": false,
          "headline": "Add better envelope date parsing",
          "author_name": "ptrcnull",
          "author_login": "ptrcnull",
          "committed_at": "2022-05-20T23:35:50Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "946daf36ce81a5b82f8dfe814afcb57a07d0bfe7",
          "body": "Closes #38",
          "is_bot": false,
          "headline": "Fix count() missing * in sql_search.go flag query builder",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2022-01-05T23:36:36Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7953ccf4536cee89b55b43463766a8acb71018b6",
          "body": null,
          "is_bot": false,
          "headline": "Merge branch 'dev' into go-imap-v2",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2022-01-05T23:20:56Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4c4add7e325bb633b906222ee2203bf5aa7c28a4",
          "body": "Fixes some issues in RECENT update generation",
          "is_bot": false,
          "headline": "Bump go-imap-mess version",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2022-01-05T23:00:56Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "bd5ac8f3f559127216385277f16d9ed40d7c6d24",
          "body": null,
          "is_bot": false,
          "headline": "Fix-up go-imap-backend-tests dependency",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2022-01-05T21:28:22Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "81f9df6abb9e57beb4345721ceb74f6d58bd5b17",
          "body": null,
          "is_bot": false,
          "headline": "Fix imapsql-ctl to work with go-imap v2 interface",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2022-01-05T18:48:48Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "fb01ffa019c73c5f7aa3bcd6c80dc608a7489994",
          "body": null,
          "is_bot": false,
          "headline": "Migrate to the latest go-imap v2 revision",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2022-01-05T18:48:15Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f74ead8f06cdd7925cad691fd7b380a6d692a6bc",
          "body": "Part of https://github.com/foxcpp/maddy/issues/395 fix",
          "is_bot": false,
          "headline": "Add objectSize argument to ExternalStore.Create",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2021-08-28T12:39:43Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "208ef2022031c5e357d81d8b1ecb8f1624120b2f",
          "body": "Part of https://github.com/foxcpp/maddy/issues/395 fix",
          "is_bot": false,
          "headline": "Add objectSize argument to ExternalStore.Create",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2021-08-28T12:18:10Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "5001789b3f0a218e00e955de1eeb2e5ea09f38c5",
          "body": null,
          "is_bot": false,
          "headline": "Bump go-imap-mess version",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2021-07-18T18:08:42Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d38d40f5442c7bb3b88ef2fdd925e73e4ff25b91",
          "body": null,
          "is_bot": false,
          "headline": "Add schema migration code for go-imap-v2",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2021-07-18T08:25:46Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7f103db60f2200333caa1579b1222cae2e48c0e8",
          "body": null,
          "is_bot": false,
          "headline": "Add Mailbox.Idle for use by go-imap-idle in go-imap v2",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2021-07-18T08:12:50Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "63230a651cf179d0747bd2fc3c4447c070a19a55",
          "body": "Also get rid of SQLite \"tweak\" and allow disabling\n\\Recent unsetting altogether.",
          "is_bot": false,
          "headline": "Expose access to go-imap-mess Manager",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2021-07-18T07:39:23Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4cae950f0d7845c08d36ccff46acc916715d4a55",
          "body": null,
          "is_bot": false,
          "headline": "Mention CockroachDB as supported",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-10-03T15:03:24Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "774dce623d39c133dc3da8747114fc9d2e298273",
          "body": "Now it can actually run with it.",
          "is_bot": false,
          "headline": "Improve CockroachDB compatibility",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-10-03T14:58:45Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "2f57903a7ed00b64fc5213322f8dc0b993e5a55b",
          "body": "Closes #35",
          "is_bot": false,
          "headline": "Fix X-Priority header field being missing from header cache",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-08-23T12:43:37Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d9d1f011a479c4b1e3cce591abee848d20910720",
          "body": null,
          "is_bot": false,
          "headline": "Document imaptest stats",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-08-02T09:27:03Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "638d9237517d9b29c00d3f8b853740768e84794f",
          "body": null,
          "is_bot": false,
          "headline": "Add minimal imapd executable for use with imaptest",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-08-02T09:26:39Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "5d27958d98cfd4789a4b82d61c5aa7d2b2b40751",
          "body": "…e numbers and \\Recent",
          "is_bot": false,
          "headline": "Update for go-imap v2, use go-imap-mess to implement updates, sequenc…",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-08-02T09:26:00Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "71a94d145b0d2418f102c5a77e0b48232616a1d1",
          "body": null,
          "is_bot": false,
          "headline": "Add minimal imapd executable for testing purposes",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-07-31T20:05:25Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4586c41d495c7217edeb92bf41e409776a7f4a2a",
          "body": null,
          "is_bot": false,
          "headline": "First round of changes for go-imap v2",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-07-31T20:04:55Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "9d2bcb71fca8a3b467b5ae7be92b91656fa0c1e3",
          "body": null,
          "is_bot": false,
          "headline": "Switch to upstream go-imap-sortthread",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-07-27T13:16:39Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d7321aef429f2e2a6e0cf467ba03797db12029fd",
          "body": null,
          "is_bot": false,
          "headline": "Add IMAP THREAD support",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-07-27T13:14:34Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f26fbc9feb2167ad61f34df0d38ee71ca0b3b669",
          "body": null,
          "is_bot": false,
          "headline": "Add handler for NAMESPACE command to avoid default expensive handling",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-07-22T13:11:09Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e3a1f594544b265f36a1d8fc89f59b8be10b01df",
          "body": null,
          "is_bot": false,
          "headline": "Add IMAP SORT support",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-07-21T21:05:13Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6551cd572c1cb9ccf14dc34cde397183a86504d8",
          "body": null,
          "is_bot": false,
          "headline": "Fix flags-only search returning duplicate IDs",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-07-19T15:31:50Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "17ce9f4538cbe4b33a118c830dfe674b734142d9",
          "body": "…nterface\n\nUsed for IMAP filters in maddy.",
          "is_bot": false,
          "headline": "Add ability to override mailbox/flags on per-user basis in delivery i…",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-07-17T19:03:38Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ee357d06faf300fe71a9d97c0f751b5f732357c8",
          "body": null,
          "is_bot": false,
          "headline": "Fix Sender/Reply-To default values in returned envelope",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-06-17T13:29:16Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "090ab5cc9d2c5df52c33951af459b8865f3a7a33",
          "body": "Closes #24.",
          "is_bot": false,
          "headline": "Fix handling of * seqset",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-06-16T22:15:50Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4ae748ec31e9fe5562782599290a04472745647e",
          "body": null,
          "is_bot": false,
          "headline": "Add debug logging for some IMAP commands",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-06-16T10:51:28Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "692e8cd2fb8e8e7220b9ec33c718610c1d5b89e3",
          "body": null,
          "is_bot": false,
          "headline": "Add missing counters update for EXPUNGE",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-06-16T10:50:06Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "5d621149092880aa86efadedde21147426c51489",
          "body": null,
          "is_bot": false,
          "headline": "Do not assume clients specify date in APPEND command",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-06-13T13:24:00Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "3c4815a7ee1f54c97722531939bc04e92969b537",
          "body": "MySQL does not support \"CREATE INDEX IF NOT EXISTS\".",
          "is_bot": false,
          "headline": "Fix creating index in mysql.",
          "author_name": "Jingyi Wei",
          "author_login": "wjywbs",
          "committed_at": "2020-05-27T14:24:55Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c3172a53940a8e82349c06d418df390ef9486e6e",
          "body": null,
          "is_bot": false,
          "headline": "go get -u && go mod tidy",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-04-26T17:58:44Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "34992e5fbb60fa65e7a124d4283ab4c6b05e7b3d",
          "body": "Was broken after 971cf71cce4f6eab2512baf1b073f2429b2a3a39.",
          "is_bot": false,
          "headline": "Unbreak imapsql-ctl build",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-04-26T17:58:03Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "bf9868d224dc7a6ec40d21d14b82cb017b25b1df",
          "body": "Some clients (Thunderbird) hide unsubscribed mailboxes by default. That\nmay lead to confusing behavior when mailbox is created automatically.\n\nSee https://github.com/foxcpp/maddy/issues/215",
          "is_bot": false,
          "headline": "Create mailboxes with subscription flag set by default",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-04-26T17:54:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "971cf71cce4f6eab2512baf1b073f2429b2a3a39",
          "body": "Part of https://github.com/foxcpp/maddy/issues/212",
          "is_bot": false,
          "headline": "Remove authentication-related functionality",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-04-11T18:29:58Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d7d4cb3f7d1d88e528ee75a0ea5a1489699a5e16",
          "body": null,
          "is_bot": false,
          "headline": "Return SerializationError object for serialization errors",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-02-15T21:50:45Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e21626cc5525cda9c55b6536fc58d86d43bba660",
          "body": null,
          "is_bot": false,
          "headline": "Update dependencies",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-02-15T21:28:36Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b8b8ac738edafca48ceeec81eb35ffa9e7c5c7b3",
          "body": null,
          "is_bot": false,
          "headline": "Fix linter warnings, merge some files",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-02-15T21:24:15Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "bdfe54b320dda6e9669e9a390febfeaabf35ee8b",
          "body": "Log relevant errors, skip problematic messages and attempt to continue.",
          "is_bot": false,
          "headline": "Make SEARCH, FETCH and EXPUNGE commands not fail on DB inconsistency",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-01-11T12:38:25Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "19bcb2aa71de09e3e028336e2bffa0760b1fe8cd",
          "body": null,
          "is_bot": false,
          "headline": "Migrate from pkg/errors library to Go 1.13 error inspection",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-01-11T11:48:59Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b750dd351611bfe30764c1611af5af3b38c963bf",
          "body": null,
          "is_bot": false,
          "headline": "Fix-up updates generation for MOVE and COPY commands",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-01-04T15:38:43Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "161bee854917fe225093964e4793e6c0ac6a596c",
          "body": "MOVE command is rewritten to avoid many unnecessary operations done by\natomic COPY+EXPUNGE pair.\n\nCOPY command is adjusted to benefit from optimizations in shared\nprepared statements.",
          "is_bot": false,
          "headline": "Optimize MOVE and COPY commands a bit",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2020-01-04T15:29:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8b4ec6b19a78ecf640c63182f607647a8e0a1c1a",
          "body": null,
          "is_bot": false,
          "headline": "Close the updates channel in Close",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-12-08T09:47:50Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6cd51e1c116c0a63557e5300138710fdc74f78a5",
          "body": "Ensures the durability of local deliveries.",
          "is_bot": false,
          "headline": "Flush ExternalStore objects (fsync for FSStore)",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-12-07T15:19:07Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "42bd4cfc6673f6122a592e7875b7b1175fe4fcbe",
          "body": "It follows maddy-like structure ofr messages to make it easier to\nintegrate.",
          "is_bot": false,
          "headline": "Log errors returned to clients",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-11-09T13:57:52Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "9f708775d60a50b88c7149bef40630fcadcc9a67",
          "body": "Actually, there is no real reason why Mailbox should contain *pointer*\nto User so it now contains it as a value.",
          "is_bot": false,
          "headline": "Fix accidential User object aliasing in Delivery.Mailbox",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-10-13T20:01:28Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e440204188173a3aeda2bfb38987b5a381d7cb90",
          "body": null,
          "is_bot": false,
          "headline": "Update all code to use CanonicalMIMEHeaderKey instead of ToLower",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-10-13T18:06:16Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f93c4bcb769f68c94a935320eccf8b6e1ef6f9df",
          "body": "Allow Delivery objects to be reused.\nReplace some pointers with values in Delivery code.\nUse CanonicalMIMEHeaderKey instead of strings.ToLower for header\nnormalization.\nReplace encoding/json with easyjson with static code generation\n(reflection is slow and memory hungry)",
          "is_bot": false,
          "headline": "Reduce amount of allocations in message processing code",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-10-13T13:49:54Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1872afa7b5aa87a8c00d0d6271e82f6d3985f706",
          "body": null,
          "is_bot": false,
          "headline": "Fix header being written without compression in delivery.Body",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-10-11T23:47:52Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8ee5c96d4dd9ddbe7630fe27f80eb2a87b728acc",
          "body": null,
          "is_bot": false,
          "headline": "Fix handling of \"null\" compression",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-10-11T22:37:51Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d6bc61c102a8c190f69323bfa580b52fc08592aa",
          "body": null,
          "is_bot": false,
          "headline": "Add support for zstd compression",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-10-11T22:36:47Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "aa76135968a9b292e003c807342f656c03325a69",
          "body": null,
          "is_bot": false,
          "headline": "Implement support for LZ4 compression support",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-10-11T21:47:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "cde9a248445b83eec7396ad23064d3a3d691a312",
          "body": null,
          "is_bot": false,
          "headline": "Update VersionStr constant",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-10-11T21:47:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "2008a7b86916916d289aa8bdc46fe1ee7712901e",
          "body": null,
          "is_bot": false,
          "headline": "Remove schema upgrade operations for older versions",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-10-11T21:47:29Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b6668d0a198e375921cce9de8c2ed40e38761258",
          "body": "No longer relevant.",
          "is_bot": false,
          "headline": "Remove section about Internal/External BLOBs from README",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-10-11T17:30:43Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e91826c07933616ddc7873730e0ade150d9fb56e",
          "body": "Not really useful and even more useless with External Store requirement.",
          "is_bot": false,
          "headline": "cmd/imapsql-ctl: Remove support for reading driver/DSN from text file",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-10-11T17:21:10Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0dca68fdb505639e8f93fc4146ccfb5cb3494b2e",
          "body": null,
          "is_bot": false,
          "headline": "Rename imapsql.Store -> imapsql.FSStore",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-10-11T17:19:25Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4071c69ef91894f1d9028c4d1281b00ef2fc88b8",
          "body": null,
          "is_bot": false,
          "headline": "Remove support for handling messages in table rows",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-10-11T17:18:51Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4c8996e3f23be57ef24d35cbd42e23fc44d20392",
          "body": null,
          "is_bot": false,
          "headline": "Remove most of the code for storing messages in table rows",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-10-11T17:13:01Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b682ac1615cef3a7194eb0bcd7f9f4dcf9f8f232",
          "body": "It was properly skipped only without ExternalStore.",
          "is_bot": false,
          "headline": "Skip header in openBody if needHeader = false",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-10-11T16:52:57Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "2a263c3743fe03b93279cab0e290fe312c170620",
          "body": "Remove separate tests for non-fsstore behavior.",
          "is_bot": false,
          "headline": "Require fsstore to be used",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-10-11T16:21:02Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "45b437d31a435504b8f2eb5136d0f1c69cc22a0b",
          "body": "This effectively ends MariaDB support. As practice shows, PostgreSQL\noutperforms MariaDB in every aspect.",
          "is_bot": false,
          "headline": "Remove CI job for testing with MariaDB",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-10-11T15:42:13Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8d3034619148c19bc5d1514aa3d553ad7f0870bf",
          "body": "Go 1.13 keeps autoadding 'go 1.13' and it is annoying.",
          "is_bot": false,
          "headline": "Add 'go 1.12' to go.mod",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-10-11T15:39:13Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1679626f5d77e52b9274d63aec4fae2e3b8ee53b",
          "body": "Results in inboxId of newly created users to be 0, making it\ninaccessible.",
          "is_bot": false,
          "headline": "Fix wrong order of arguments for setInboxId query",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-10-11T13:05:05Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "da0b12ce63811393442ff164481cc59e013cab58",
          "body": "Closes #25.",
          "is_bot": false,
          "headline": "Remove dangling External Store key when message is not added to DB",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-10-08T18:30:21Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c70669132bf37b2d371800fff18a5b42faa662da",
          "body": "If passed io.Reader does have it. It avoids extra copy and\nioutil.ReadAll.",
          "is_bot": false,
          "headline": "Use Bytes() method on Reader passed to Delivery.Body",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-10-08T17:44:43Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "3d2b5b02c3c8b0afaaf13e2cab063643d7de233d",
          "body": null,
          "is_bot": false,
          "headline": "Fix User.inboxId = 0 for newly created users",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-10-08T17:26:31Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "45cd989b5bebfb4746e4a762789d2fa4f6ee52f0",
          "body": "People are supposed to back-up database before doing upgrades\nanyway, so we can just automaticallly run migrations code.",
          "is_bot": false,
          "headline": "Remove schema upgrade restriction",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-09-18T20:44:36Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "9706cdcc0a24adfe24b4022a57cd9155540893f8",
          "body": "Incorrect JOIN condition results in query returning more rows than\nwanted, thus removing more external store keys and leading to FOREIGN\nKEY violation because extra keys are referenced by other existing\nmessages.",
          "is_bot": false,
          "headline": "Fix FOREIGN KEY violation for External Store deletion",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-09-06T18:06:25Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "082dfbd8290a64ec37c13bec948f0ae086b55dd1",
          "body": "Closes #10",
          "is_bot": false,
          "headline": "Actually remove blobs from External Store",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-09-06T17:40:36Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e3ce1b029fe36ce54e49939df865f6b731b22877",
          "body": null,
          "is_bot": false,
          "headline": "Fix-up 7b0ca06",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-09-05T21:16:27Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "48c7c42958f9628227b81a9f9a698bfd6132540f",
          "body": "I thought the \"rewrite\" logic for RETURNING clause is already here, but\napparently it is not.",
          "is_bot": false,
          "headline": "Fix-up 94d5921 for SQLite and MySQL",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-09-05T21:15:07Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "5134534f6c2ad3ce587d025a6850dcf91fe78a01",
          "body": "Refuse to read messaages with body stored in the External Storage\nwhen we have no External Storage configured instead of segfaulting.\n\nThis error can occur pretty often as people will forget to put\nthe path to External Storage when working with DB using imapsql-ctl.",
          "is_bot": false,
          "headline": "Gracefully handle ext body keys in DB without External Storage",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-09-04T20:52:45Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "94d59210fc43d6246d2536f0590ca93631076c98",
          "body": "It also makes it unnecessary to use explicit locking or tx isolation\nbecause a single query is always atomic.\n\nPrevious implementation is left for MySQL and SQLite.",
          "is_bot": false,
          "headline": "Do all counters bookkeeping in one query on PostgreSQL",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-09-04T20:34:38Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "717d50a323df8a452302a2068401c991661c4ab2",
          "body": "The build tag is sqlite_secure_delete, not sqlite3_secure_delete.",
          "is_bot": false,
          "headline": "docs: Fix wrong build tag in secure_delete in README",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-09-03T22:15:26Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "437cca4f4e16947c94c4c4ca773d4275f1b1ee4d",
          "body": "We don't actually test anything with MySQL 8, nobody uses MySQL 8\nanyways.",
          "is_bot": false,
          "headline": "docs: Be more honest about RDBMS support",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-09-03T22:08:51Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7b0ca06319102bf1e0a251bb62e52999c155baa3",
          "body": "This updates SQLite query planner statistics, which can be useful,\nespecially with STAT4 extension enabled.",
          "is_bot": false,
          "headline": "Run SQLite PRAGMA optimize every 5 hours",
          "author_name": "fox.cpp",
          "author_login": "foxcpp",
          "committed_at": "2019-09-03T22:04:59Z",
          "body_truncated": false,
          "is_coding_agent": false
        }
      ],
      "releases_count": 6,
      "commits_last_year": 2,
      "latest_release_at": "2021-08-10T17:09:37Z",
      "latest_release_tag": "v0.5.0",
      "releases_from_tags": false,
      "days_since_last_push": 102,
      "active_weeks_last_year": 1,
      "days_since_latest_release": 1808,
      "mean_days_between_releases": 165.6
    },
    "community": {
      "has_readme": true,
      "has_license": true,
      "has_description": true,
      "has_contributing": false,
      "health_percentage": 42,
      "has_issue_template": false,
      "has_code_of_conduct": false,
      "has_pull_request_template": false
    },
    "ecosystem": {
      "packages": [
        {
          "name": "github.com/foxcpp/go-imap-sql",
          "exists": true,
          "license": null,
          "keywords": [],
          "ecosystem": "go",
          "matches_repo": true,
          "registry_url": "https://pkg.go.dev/github.com/foxcpp/go-imap-sql",
          "is_deprecated": false,
          "latest_version": "v0.5.0",
          "repository_url": "https://github.com/foxcpp/go-imap-sql",
          "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": "2020-08-23T12:43:37Z",
          "latest_version_yanked": null,
          "days_since_latest_publish": 2160
        }
      ]
    },
    "popularity": {
      "forks": 12,
      "stars": 26,
      "watchers": 3,
      "fork_history": {
        "days": [
          {
            "date": "2019-03-10",
            "count": 1
          },
          {
            "date": "2020-05-27",
            "count": 1
          },
          {
            "date": "2021-01-21",
            "count": 1
          },
          {
            "date": "2021-06-08",
            "count": 1
          },
          {
            "date": "2022-03-14",
            "count": 1
          },
          {
            "date": "2022-05-15",
            "count": 1
          },
          {
            "date": "2022-05-20",
            "count": 1
          },
          {
            "date": "2023-01-14",
            "count": 1
          },
          {
            "date": "2024-02-02",
            "count": 1
          },
          {
            "date": "2024-06-08",
            "count": 1
          },
          {
            "date": "2025-02-04",
            "count": 1
          },
          {
            "date": "2026-02-10",
            "count": 1
          }
        ],
        "complete": true,
        "collected": 12,
        "total_forks": 12
      },
      "star_history": null,
      "open_issues_and_prs": 22
    },
    "ai_readiness": {
      "has_nix": false,
      "example_dirs": [],
      "has_llms_txt": false,
      "has_dockerfile": false,
      "has_mcp_signal": false,
      "bootstrap_files": [],
      "api_schema_files": [],
      "has_devcontainer": false,
      "typecheck_configs": [],
      "toolchain_manifests": [
        "go.mod"
      ],
      "largest_source_bytes": 24875,
      "source_files_sampled": 43,
      "oversized_source_files": 0,
      "agent_instruction_files": [],
      "agent_instruction_max_bytes": null
    },
    "dependencies": {
      "manifests": [
        "go.mod"
      ],
      "advisories": {
        "error": null,
        "scope": "repository_graph",
        "source": "osv",
        "findings": [],
        "collected": true,
        "malicious": [],
        "truncated": false,
        "by_severity": {},
        "advisory_count": 0,
        "affected_count": 0,
        "assessed_count": 18,
        "malicious_count": 0,
        "assessed_package": null,
        "unassessed_count": 0,
        "direct_affected_count": 0
      },
      "ecosystems": [
        "go"
      ],
      "dependencies": [
        {
          "name": "github.com/emersion/go-imap",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v1.2.2-0.20220928192137-6fac715be9cf"
        },
        {
          "name": "github.com/emersion/go-imap-sortthread",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v1.2.0"
        },
        {
          "name": "github.com/emersion/go-message",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v0.18.0"
        },
        {
          "name": "github.com/foxcpp/go-imap-backend-tests",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v0.0.0-20220105184719-e80aa29a5e16"
        },
        {
          "name": "github.com/foxcpp/go-imap-mess",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v0.0.0-20230108134257-b7ec3a649613"
        },
        {
          "name": "github.com/foxcpp/go-imap-namespace",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v0.0.0-20200802091432-08496dd8e0ed"
        },
        {
          "name": "github.com/go-sql-driver/mysql",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v1.7.1"
        },
        {
          "name": "github.com/klauspost/compress",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v1.17.4"
        },
        {
          "name": "github.com/lib/pq",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v1.10.9"
        },
        {
          "name": "github.com/mailru/easyjson",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v0.7.7"
        },
        {
          "name": "github.com/mattn/go-sqlite3",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v1.14.19"
        },
        {
          "name": "github.com/pierrec/lz4",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v2.6.1+incompatible"
        },
        {
          "name": "github.com/urfave/cli",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v1.22.14"
        },
        {
          "name": "gotest.tools",
          "manifest": "go.mod",
          "ecosystem": "go",
          "version_constraint": "v2.2.0+incompatible"
        }
      ],
      "all_dependencies": {
        "error": null,
        "source": "github-sbom",
        "packages": [
          {
            "name": "github.com/emersion/go-imap",
            "direct": true,
            "version": "1.2.2-0.20220928192137-6fac715be9cf",
            "ecosystem": "go"
          },
          {
            "name": "github.com/emersion/go-imap-sortthread",
            "direct": true,
            "version": "1.2.0",
            "ecosystem": "go"
          },
          {
            "name": "github.com/emersion/go-message",
            "direct": true,
            "version": "0.18.0",
            "ecosystem": "go"
          },
          {
            "name": "github.com/foxcpp/go-imap-backend-tests",
            "direct": true,
            "version": "0.0.0-20220105184719-e80aa29a5e16",
            "ecosystem": "go"
          },
          {
            "name": "github.com/foxcpp/go-imap-mess",
            "direct": true,
            "version": "0.0.0-20230108134257-b7ec3a649613",
            "ecosystem": "go"
          },
          {
            "name": "github.com/foxcpp/go-imap-namespace",
            "direct": true,
            "version": "0.0.0-20200802091432-08496dd8e0ed",
            "ecosystem": "go"
          },
          {
            "name": "github.com/go-sql-driver/mysql",
            "direct": true,
            "version": "1.7.1",
            "ecosystem": "go"
          },
          {
            "name": "github.com/klauspost/compress",
            "direct": true,
            "version": "1.17.4",
            "ecosystem": "go"
          },
          {
            "name": "github.com/lib/pq",
            "direct": true,
            "version": "1.10.9",
            "ecosystem": "go"
          },
          {
            "name": "github.com/mailru/easyjson",
            "direct": true,
            "version": "0.7.7",
            "ecosystem": "go"
          },
          {
            "name": "github.com/mattn/go-sqlite3",
            "direct": true,
            "version": "1.14.19",
            "ecosystem": "go"
          },
          {
            "name": "github.com/pierrec/lz4",
            "direct": true,
            "version": "2.6.1+incompatible",
            "ecosystem": "go"
          },
          {
            "name": "github.com/urfave/cli",
            "direct": true,
            "version": "1.22.14",
            "ecosystem": "go"
          },
          {
            "name": "gotest.tools",
            "direct": true,
            "version": "2.2.0+incompatible",
            "ecosystem": "go"
          },
          {
            "name": "github.com/cpuguy83/go-md2man/v2",
            "direct": false,
            "version": "2.0.3",
            "ecosystem": "go"
          },
          {
            "name": "github.com/emersion/go-sasl",
            "direct": false,
            "version": "0.0.0-20231106173351-e73c9f7bad43",
            "ecosystem": "go"
          },
          {
            "name": "github.com/frankban/quicktest",
            "direct": false,
            "version": "1.5.0",
            "ecosystem": "go"
          },
          {
            "name": "github.com/google/go-cmp",
            "direct": false,
            "version": "0.5.5",
            "ecosystem": "go"
          }
        ],
        "collected": true,
        "truncated": false,
        "total_count": 18,
        "direct_count": 14,
        "indirect_count": 4
      }
    },
    "maintainership": {
      "issues": {
        "open_prs": 2,
        "merged_prs": 4,
        "open_issues": 20,
        "closed_ratio": 0.512,
        "closed_issues": 21,
        "closed_unmerged_prs": 0
      },
      "bus_factor": 1,
      "bot_contributors": 0,
      "top_contributors": [
        {
          "type": "User",
          "login": "foxcpp",
          "commits": 287,
          "avatar_url": "https://avatars.githubusercontent.com/u/37885127?v=4"
        },
        {
          "type": "User",
          "login": "ptrcnull",
          "commits": 3,
          "avatar_url": "https://avatars.githubusercontent.com/u/26630168?v=4"
        },
        {
          "type": "User",
          "login": "RiadVargas",
          "commits": 2,
          "avatar_url": "https://avatars.githubusercontent.com/u/4274014?v=4"
        },
        {
          "type": "User",
          "login": "wjywbs",
          "commits": 1,
          "avatar_url": "https://avatars.githubusercontent.com/u/6233680?v=4"
        }
      ],
      "contributors_sampled": 4,
      "top_contributor_share": 0.98
    },
    "quality_signals": {
      "has_ci": false,
      "has_tests": true,
      "ci_workflows": [],
      "has_docs_dir": false,
      "linter_configs": [
        ".golangci.yml"
      ],
      "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": 0,
            "reason": "0 out of 3 merged PRs checked by a CI test -- score normalized to 0",
            "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": 1,
            "reason": "Found 3/27 approved changesets -- score normalized to 1",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#code-review"
          },
          {
            "name": "Contributors",
            "score": 3,
            "reason": "project has 1 contributing companies or organizations -- score normalized to 3",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#contributors"
          },
          {
            "name": "Dangerous-Workflow",
            "score": null,
            "reason": "no workflows found",
            "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": "0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0",
            "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": null,
            "reason": "no dependencies found",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#pinned-dependencies"
          },
          {
            "name": "SAST",
            "score": 0,
            "reason": "SAST tool is not run on all commits -- score normalized to 0",
            "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": null,
            "reason": "No tokens found",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#token-permissions"
          },
          {
            "name": "Vulnerabilities",
            "score": 9,
            "reason": "1 existing vulnerabilities detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#vulnerabilities"
          }
        ],
        "commit": "b5e85e90f14d8fecc7082fa9de82f93d47c048c4",
        "ran_at": "2026-07-23T19:31:33Z",
        "aggregate_score": 2.6,
        "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": "2026-04-12T19:09:43Z",
      "oldest_open_prs": [
        {
          "number": 45,
          "created_at": "2023-09-11T01:11:40Z",
          "last_comment_at": "2023-09-11T11:35:08Z",
          "last_comment_author": "ptrcnull"
        },
        {
          "number": 47,
          "created_at": "2024-02-29T04:29:19Z",
          "last_comment_at": null,
          "last_comment_author": null
        }
      ],
      "last_merged_pr_at": "2023-05-04T18:50:13Z",
      "ci_last_conclusion": null,
      "oldest_open_issues": [
        {
          "number": 2,
          "created_at": "2019-03-10T17:02:01Z",
          "last_comment_at": "2019-05-19T12:29:36Z",
          "last_comment_author": "foxcpp"
        },
        {
          "number": 3,
          "created_at": "2019-05-14T21:18:39Z",
          "last_comment_at": "2019-05-14T21:55:01Z",
          "last_comment_author": "foxcpp"
        },
        {
          "number": 5,
          "created_at": "2019-05-25T14:22:02Z",
          "last_comment_at": "2020-10-03T15:04:55Z",
          "last_comment_author": "foxcpp"
        },
        {
          "number": 11,
          "created_at": "2019-09-01T15:34:05Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 13,
          "created_at": "2019-09-01T15:39:27Z",
          "last_comment_at": "2019-09-02T21:45:36Z",
          "last_comment_author": "foxcpp"
        },
        {
          "number": 16,
          "created_at": "2019-09-01T15:46:20Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 17,
          "created_at": "2019-09-01T15:46:50Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 18,
          "created_at": "2019-09-01T15:47:02Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 19,
          "created_at": "2019-09-01T15:47:23Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 20,
          "created_at": "2019-09-01T15:47:53Z",
          "last_comment_at": "2022-01-05T23:49:06Z",
          "last_comment_author": "foxcpp"
        },
        {
          "number": 21,
          "created_at": "2019-09-01T15:49:30Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 23,
          "created_at": "2019-09-01T15:58:39Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 26,
          "created_at": "2019-09-15T16:03:35Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 28,
          "created_at": "2020-01-04T10:34:22Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 33,
          "created_at": "2020-08-13T10:19:58Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 34,
          "created_at": "2020-08-13T10:21:43Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 37,
          "created_at": "2022-01-05T18:19:24Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 44,
          "created_at": "2023-09-11T00:57:56Z",
          "last_comment_at": "2023-09-11T01:08:53Z",
          "last_comment_author": "ptrcnull"
        },
        {
          "number": 46,
          "created_at": "2023-09-11T02:17:24Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 48,
          "created_at": "2024-06-28T19:46:36Z",
          "last_comment_at": null,
          "last_comment_author": null
        }
      ]
    }
  },
  "config": {
    "disabled_metrics": [],
    "disabled_categories": [],
    "disabled_components": {}
  },
  "source": {
    "url": "https://github.com/foxcpp/go-imap-sql",
    "host": "github.com",
    "name": "go-imap-sql",
    "owner": "foxcpp"
  },
  "metrics": {
    "overall": {
      "key": "overall",
      "band": "critical",
      "name": "Overall health",
      "note": "High-Risk Jurisdiction Policy applies a 20% multiplier to weighted overall health and gives it an At risk ceiling of 49.",
      "notes": [
        {
          "code": "jurisdiction_overall_adjustment",
          "params": {
            "cap": 49,
            "pct": 20
          }
        }
      ],
      "value": 8,
      "inputs": {
        "security": 24,
        "vitality": 27,
        "community": 41,
        "governance": 51,
        "engineering": 44,
        "high_risk_jurisdiction_cap": 49,
        "high_risk_jurisdiction_multiplier": 20,
        "weighted_overall_before_jurisdiction": 38,
        "overall_after_jurisdiction_multiplier": 8
      },
      "components": []
    },
    "categories": [
      {
        "key": "vitality",
        "band": "critical",
        "name": "Vitality",
        "value": 27,
        "weight": 0.22,
        "metrics": [
          {
            "key": "development_activity",
            "band": "critical",
            "name": "Development activity",
            "note": null,
            "notes": [],
            "value": 15,
            "inputs": {
              "commits_last_year": 2,
              "human_commit_share": 1,
              "days_since_last_push": 102,
              "active_weeks_last_year": 1
            },
            "components": [
              {
                "key": "push_recency",
                "name": "Push recency",
                "detail": "last push 102 days ago",
                "points": 9.9,
                "status": "partial",
                "details": [
                  {
                    "code": "push_recency",
                    "params": {
                      "days": 102
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "commit_cadence",
                "name": "Commit cadence",
                "detail": "1/52 weeks with commits",
                "points": 0.7,
                "status": "partial",
                "details": [
                  {
                    "code": "commit_cadence_weeks",
                    "params": {
                      "weeks": 1
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "commit_volume",
                "name": "Commit volume",
                "detail": "2 commits in the last year",
                "points": 4.3,
                "status": "partial",
                "details": [
                  {
                    "code": "commits_last_year",
                    "params": {
                      "count": 2
                    }
                  }
                ],
                "max_points": 18
              },
              {
                "key": "openssf_scorecard_maintained",
                "name": "OpenSSF Scorecard: Maintained",
                "detail": "0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "release_discipline",
            "band": "at_risk",
            "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": 44,
            "inputs": {
              "releases_count": 6,
              "latest_release_tag": "v0.5.0",
              "releases_from_tags": false,
              "days_since_latest_release": 1808,
              "mean_days_between_releases": 165.6
            },
            "components": [
              {
                "key": "ships_releases",
                "name": "Ships releases",
                "detail": "6 releases published",
                "points": 27,
                "status": "met",
                "details": [
                  {
                    "code": "releases_published",
                    "params": {
                      "count": 6
                    }
                  }
                ],
                "max_points": 27
              },
              {
                "key": "release_recency",
                "name": "Release recency",
                "detail": "latest release 1808 days ago",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "release_recency",
                    "params": {
                      "days": 1808
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "release_cadence",
                "name": "Release cadence",
                "detail": "a release every ~165.6 days",
                "points": 12.6,
                "status": "partial",
                "details": [
                  {
                    "code": "release_cadence",
                    "params": {
                      "gap": 165.6
                    }
                  }
                ],
                "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": "maintained",
              "guards": [],
              "signals": [],
              "red_flag": false,
              "multiplier_pct": 100,
              "declared_reason": null,
              "unverified_reason": null,
              "unanswered_open_prs": null,
              "unanswered_open_issues": null,
              "days_since_last_merged_pr": null,
              "days_since_last_human_commit": 102,
              "days_since_last_human_commit_is_floor": false
            },
            "components": [
              {
                "key": "project_is_still_maintained",
                "name": "Project is still maintained",
                "detail": "last human commit 102 days ago",
                "points": 100,
                "status": "met",
                "details": [
                  {
                    "code": "abandonment_maintained",
                    "params": {
                      "days": 102
                    }
                  }
                ],
                "max_points": 100
              }
            ]
          }
        ],
        "description": "Is the project alive — is code being written and are releases shipping?"
      },
      {
        "key": "community",
        "band": "at_risk",
        "name": "Community & Adoption",
        "value": 41,
        "weight": 0.18,
        "metrics": [
          {
            "key": "popularity",
            "band": "at_risk",
            "name": "Popularity & adoption",
            "note": null,
            "notes": [],
            "value": 33,
            "inputs": {
              "forks": 12,
              "stars": 26,
              "watchers": 3,
              "growth_state": "unverified",
              "growth_factor_pct": 100,
              "growth_unverified_reason": "no_history"
            },
            "components": [
              {
                "key": "stars",
                "name": "Stars",
                "detail": "26 stars",
                "points": 22.7,
                "status": "partial",
                "details": [
                  {
                    "code": "stars",
                    "params": {
                      "count": 26
                    }
                  }
                ],
                "max_points": 60
              },
              {
                "key": "forks",
                "name": "Forks",
                "detail": "12 forks",
                "points": 8.7,
                "status": "partial",
                "details": [
                  {
                    "code": "forks",
                    "params": {
                      "count": 12
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "watchers",
                "name": "Watchers",
                "detail": "3 watchers",
                "points": 1.7,
                "status": "partial",
                "details": [
                  {
                    "code": "watchers",
                    "params": {
                      "count": 3
                    }
                  }
                ],
                "max_points": 15
              }
            ]
          },
          {
            "key": "community_health",
            "band": "moderate",
            "name": "Community health",
            "note": null,
            "notes": [],
            "value": 50,
            "inputs": {
              "has_readme": true,
              "has_license": true,
              "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": 22.5,
                "status": "met",
                "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": 51,
        "weight": 0.24,
        "metrics": [
          {
            "key": "maintainer_resilience",
            "band": "critical",
            "name": "Maintainer resilience (bus factor)",
            "note": null,
            "notes": [],
            "value": 18,
            "inputs": {
              "bus_factor": 1,
              "contributors_sampled": 4,
              "top_contributor_share": 0.98
            },
            "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 98% of commits",
                "points": 0.5,
                "status": "partial",
                "details": [
                  {
                    "code": "top_contributor_share",
                    "params": {
                      "share": 98
                    }
                  }
                ],
                "max_points": 22.5
              },
              {
                "key": "contributor_breadth",
                "name": "Contributor breadth",
                "detail": "4 contributors",
                "points": 5.4,
                "status": "partial",
                "details": [
                  {
                    "code": "contributors_sampled",
                    "params": {
                      "count": 4
                    }
                  }
                ],
                "max_points": 13.5
              },
              {
                "key": "openssf_scorecard_contributors",
                "name": "OpenSSF Scorecard: Contributors",
                "detail": "project has 1 contributing companies or organizations -- score normalized to 3",
                "points": 3,
                "status": "partial",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "responsiveness",
            "band": "moderate",
            "name": "Issue & PR responsiveness",
            "note": null,
            "notes": [],
            "value": 64,
            "inputs": {
              "merged_prs": 4,
              "open_issues": 20,
              "closed_issues": 21,
              "issue_closed_ratio": 0.512,
              "closed_unmerged_prs": 0
            },
            "components": [
              {
                "key": "issue_resolution",
                "name": "Issue resolution",
                "detail": "51% of issues closed",
                "points": 23.9,
                "status": "partial",
                "details": [
                  {
                    "code": "issues_closed_share",
                    "params": {
                      "share": 51
                    }
                  }
                ],
                "max_points": 46.75
              },
              {
                "key": "pr_acceptance",
                "name": "PR acceptance",
                "detail": "4/4 decided PRs merged",
                "points": 38.2,
                "status": "met",
                "details": [
                  {
                    "code": "decided_prs_merged",
                    "params": {
                      "merged": 4,
                      "decided": 4
                    }
                  }
                ],
                "max_points": 38.25
              },
              {
                "key": "openssf_scorecard_code_review",
                "name": "OpenSSF Scorecard: Code-Review",
                "detail": "Found 3/27 approved changesets -- score normalized to 1",
                "points": 1.5,
                "status": "partial",
                "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": 65,
            "inputs": {
              "followers": 221,
              "owner_type": "User",
              "is_verified": null,
              "owner_login": "foxcpp",
              "public_repos": 72,
              "account_age_days": 3038
            },
            "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": "221 followers of foxcpp",
                "points": 16.9,
                "status": "partial",
                "details": [
                  {
                    "code": "owner_followers",
                    "params": {
                      "count": 221,
                      "login": "foxcpp"
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "track_record",
                "name": "Track record",
                "detail": "72 public repos, account ~8 yr old",
                "points": 25,
                "status": "met",
                "details": [
                  {
                    "code": "public_repos",
                    "params": {
                      "count": 72
                    }
                  },
                  {
                    "code": "account_age_years",
                    "params": {
                      "years": 8
                    }
                  }
                ],
                "max_points": 25
              }
            ]
          },
          {
            "key": "package_maintenance",
            "band": "moderate",
            "name": "Package maintenance",
            "note": null,
            "notes": [],
            "value": 69,
            "inputs": {
              "packages": [
                "github.com/foxcpp/go-imap-sql"
              ],
              "ecosystems": "go",
              "any_deprecated": false,
              "min_days_since_publish": 2160
            },
            "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 2160 days ago",
                "points": 4,
                "status": "partial",
                "details": [
                  {
                    "code": "publish_recency",
                    "params": {
                      "days": 2160
                    }
                  }
                ],
                "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": "at_risk",
        "name": "Engineering Quality",
        "value": 44,
        "weight": 0.2,
        "metrics": [
          {
            "key": "engineering_practices",
            "band": "at_risk",
            "name": "Engineering practices",
            "note": null,
            "notes": [],
            "value": 40,
            "inputs": {
              "has_ci": false,
              "has_tests": true,
              "has_editorconfig": false,
              "has_linter_config": true,
              "has_precommit_config": false
            },
            "components": [
              {
                "key": "ci_workflows",
                "name": "CI workflows",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "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.yml",
                "points": 16,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": ".golangci.yml"
                    }
                  }
                ],
                "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": "0 out of 3 merged PRs checked by a CI test -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 20
              }
            ]
          },
          {
            "key": "documentation",
            "band": "moderate",
            "name": "Documentation",
            "note": null,
            "notes": [],
            "value": 50,
            "inputs": {
              "topics": [
                "imap",
                "imap-server",
                "mail"
              ],
              "has_wiki": false,
              "homepage": null,
              "has_readme": true,
              "has_docs_dir": false,
              "has_description": true
            },
            "components": [
              {
                "key": "readme",
                "name": "README",
                "detail": null,
                "points": 30,
                "status": "met",
                "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": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              },
              {
                "key": "topics",
                "name": "Topics",
                "detail": "3 topics",
                "points": 10,
                "status": "met",
                "details": [
                  {
                    "code": "topics_count",
                    "params": {
                      "count": 3
                    }
                  }
                ],
                "max_points": 10
              },
              {
                "key": "wiki",
                "name": "Wiki",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 10
              }
            ]
          }
        ],
        "description": "Are baseline engineering and documentation practices in place?"
      },
      {
        "key": "security",
        "band": "critical",
        "name": "Security",
        "value": 24,
        "weight": 0.16,
        "metrics": [
          {
            "key": "security_posture",
            "band": "critical",
            "name": "Security posture",
            "note": "Excluded from scoring (no data or not applicable): Dangerous-Workflow, Packaging, Pinned-Dependencies, Signed-Releases, Token-Permissions. Remaining weights renormalized. High-Risk Jurisdiction Policy applies a 20% multiplier to Security posture and gives it an At risk ceiling of 49.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "dangerous_workflow",
                    "packaging",
                    "pinned_dependencies",
                    "signed_releases",
                    "token_permissions"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              },
              {
                "code": "jurisdiction_posture_adjustment",
                "params": {
                  "cap": 49,
                  "pct": 20
                }
              }
            ],
            "value": 5,
            "inputs": {
              "source": "openssf_scorecard",
              "checks_evaluated": 13,
              "scorecard_version": "v5.5.0",
              "checks_inconclusive": 5,
              "scorecard_aggregate": 2.6,
              "high_risk_jurisdiction_cap": 49,
              "high_risk_jurisdiction_multiplier": 20,
              "security_posture_after_multiplier": 5,
              "security_posture_before_jurisdiction": 26
            },
            "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": "0 out of 3 merged PRs checked by a CI test -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "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 3/27 approved changesets -- score normalized to 1",
                "points": 0.8,
                "status": "partial",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "contributors",
                "name": "Contributors",
                "detail": "project has 1 contributing companies or organizations -- score normalized to 3",
                "points": 0.8,
                "status": "partial",
                "details": [],
                "max_points": 2.5
              },
              {
                "key": "dangerous_workflow",
                "name": "Dangerous-Workflow",
                "detail": "no workflows found",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "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": "0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0",
                "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": "no dependencies found",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "max_points": 5
              },
              {
                "key": "sast",
                "name": "SAST",
                "detail": "SAST tool is not run on all commits -- score normalized to 0",
                "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": "No tokens found",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "max_points": 7.5
              },
              {
                "key": "vulnerabilities",
                "name": "Vulnerabilities",
                "detail": "1 existing vulnerabilities detected",
                "points": 6.8,
                "status": "partial",
                "details": [],
                "max_points": 7.5
              }
            ]
          },
          {
            "key": "dependency_advisories",
            "band": "excellent",
            "name": "Dependency advisories",
            "note": "Excluded from scoring (no data or not applicable): Indirect dependencies free of known advisories, No advisories left outstanding. Remaining weights renormalized. Matched 18 resolved dependencies against OSV. This repository publishes no package the index resolves, so the repository dependency graph was assessed instead. That graph mixes development and test pins with shipped dependencies, so only the declared runtime dependencies are scored; transitive findings are reported as context and excluded from the score. Reachability is not analyzed.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "indirect_dependencies_free_of_known_advisories",
                    "no_advisories_left_outstanding"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              },
              {
                "code": "advisories_scope_repository",
                "params": {
                  "assessed": 18
                }
              },
              {
                "code": "advisories_repo_graph_caveat",
                "params": {}
              },
              {
                "code": "advisories_reachability",
                "params": {}
              }
            ],
            "value": 100,
            "inputs": {
              "source": "osv",
              "advisories": 0,
              "affected_packages": 0,
              "assessed_packages": 18,
              "unassessed_packages": 0,
              "affected_by_severity": "none",
              "direct_affected_packages": 0
            },
            "components": [
              {
                "key": "direct_dependencies_free_of_known_advisories",
                "name": "Direct dependencies free of known advisories",
                "detail": "no direct dependency carries a known advisory",
                "points": 35,
                "status": "met",
                "details": [
                  {
                    "code": "no_direct_advisories",
                    "params": {}
                  }
                ],
                "max_points": 35
              },
              {
                "key": "indirect_dependencies_free_of_known_advisories",
                "name": "Indirect dependencies free of known advisories",
                "detail": "transitive set not separable from development and test dependencies in this scope",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "advisories_scope_not_separable",
                    "params": {}
                  }
                ],
                "max_points": 25
              },
              {
                "key": "no_advisories_left_outstanding",
                "name": "No advisories left outstanding",
                "detail": "no advisory carries a publication date",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "advisories_no_publication_date",
                    "params": {}
                  }
                ],
                "max_points": 40
              }
            ]
          },
          {
            "key": "malicious_dependencies",
            "band": "excellent",
            "name": "Malicious dependencies",
            "note": null,
            "notes": [],
            "value": 100,
            "inputs": {
              "source": "osv",
              "meaning": "reported as a malicious package by the OpenSSF corpus; the remedy is removal or moving off the compromised name, never an upgrade of the same artifact. Versions the registry has since pulled are listed but not scored",
              "packages": [],
              "red_flag": false,
              "assessed_packages": 18,
              "malicious_packages": 0,
              "direct_malicious_packages": 0,
              "withdrawn_malicious_packages": 0,
              "installable_malicious_packages": 0
            },
            "components": [
              {
                "key": "no_dependency_reported_as_a_malicious_package",
                "name": "No dependency reported as a malicious package",
                "detail": "no dependency is reported as a malicious package",
                "points": 100,
                "status": "met",
                "details": [
                  {
                    "code": "no_malicious_dependencies",
                    "params": {}
                  }
                ],
                "max_points": 100
              }
            ]
          },
          {
            "key": "high_risk_jurisdiction_exposure",
            "band": "critical",
            "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": 20,
            "inputs": {
              "meaning": "self-published location evidence; not nationality or citizenship",
              "red_flag": true,
              "exposures": [
                {
                  "role": "owner",
                  "count": 1,
                  "country": "Russia"
                },
                {
                  "role": "top_contributor",
                  "count": 1,
                  "country": "Russia"
                }
              ],
              "policy_countries": [
                "Russia",
                "Iran",
                "North Korea"
              ],
              "review_only_matches": 0,
              "assessed_self_published_locations": 4
            },
            "components": [
              {
                "key": "policy_exposure_multiplier",
                "name": "Policy exposure multiplier",
                "detail": "Russia: owner (1); Russia: top_contributor (1)",
                "points": 20,
                "status": "partial",
                "details": [
                  {
                    "code": "jurisdiction_exposure",
                    "params": {
                      "role": "owner",
                      "count": 1,
                      "country": "Russia"
                    }
                  },
                  {
                    "code": "jurisdiction_exposure_next",
                    "params": {
                      "role": "top_contributor",
                      "count": 1,
                      "country": "Russia"
                    }
                  }
                ],
                "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": 56,
        "weight": 0,
        "metrics": [
          {
            "key": "ai_agent_context",
            "band": "critical",
            "name": "Agent context & guidance",
            "note": null,
            "notes": [],
            "value": 10,
            "inputs": {
              "has_llms_txt": false,
              "legible_history_share": 0.18,
              "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": "18 of 100 human commits state their intent (structured subject or explanatory body)",
                "points": 9.6,
                "status": "partial",
                "details": [
                  {
                    "code": "legible_history",
                    "params": {
                      "legible": 18,
                      "sampled": 100
                    }
                  }
                ],
                "max_points": 40
              }
            ]
          },
          {
            "key": "ai_verify_loop",
            "band": "good",
            "name": "Verify loop (build / test / typecheck)",
            "note": "Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Pinned-Dependencies. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "openssf_scorecard_pinned_dependencies"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 74,
            "inputs": {
              "has_nix": false,
              "has_tests": true,
              "lockfiles": [
                "go.sum"
              ],
              "has_dockerfile": false,
              "typed_language": true,
              "bootstrap_files": [],
              "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": "go.mod (toolchain convention, no task runner)",
                "points": 12.6,
                "status": "partial",
                "details": [
                  {
                    "code": "toolchain_convention",
                    "params": {
                      "files": "go.mod"
                    }
                  }
                ],
                "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.yml",
                "points": 11,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": ".golangci.yml"
                    }
                  }
                ],
                "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": "lockfile",
                "points": 10,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "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": "no dependencies found",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "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": 24875,
              "source_files_sampled": 43,
              "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/43 source files over 60KB",
                "points": 55,
                "status": "met",
                "details": [
                  {
                    "code": "oversized_source_files",
                    "params": {
                      "kb": 60,
                      "sampled": 43,
                      "oversized": 0
                    }
                  }
                ],
                "max_points": 55
              }
            ]
          }
        ],
        "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"
  ],
  "report_type": "repository",
  "generated_at": "2026-07-23T19:31:41.762807Z",
  "schema_version": "0.27.0",
  "badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/f/foxcpp/go-imap-sql.svg",
  "full_name": "foxcpp/go-imap-sql",
  "license_state": "standard",
  "license_spdx": "MIT"
}

Scores are signals, not warranties. They reflect publicly visible practices on GitHub — not a code audit, and not a security guarantee.

Missing data is excluded and weights renormalized, never scored as zero. Methodology is versioned and open: metrics v1.13.0, schema v0.27.0 — full methodology · metrics wiki.

How one result sits in the wider record: aggregate statisticsGo.