Публічний реєстр
Звіт про здоров'я програмного забезпеченнясхема 0.27.0 · метрики 1.13.0 · 2026-07-23 19:31 UTC

foxcpp / go-imap-sql

SQL-based storage backend for go-imap v2

GoMIT★ 26 зірок⑂ 12 форківз лют. 2019 р.Переглянути на GitHub ↗

foxcpp/go-imap-sql має індекс здоров’я 8 зі 100, що відповідає смузі «Критичний». Найвищий показник — AI Readiness (56/100), найнижчий — Security (24/100). Останнє оновлення було 102 дні тому. Більшість нещодавньої роботи виконує один учасник.

8
загалом / 100
Критичний

Індекс здоров'я програмного забезпечення

Метрики згруповано у зважені категорії на шкалі 1–100. Загальна оцінка починається як їхнє середнє; коли публічні дані активують Політику юрисдикцій високого ризику, рейтинг коригується й отримує верхню межу 49 («Під ризиком»). Готовність до ШІ не входить до індексу.

8
Відмінний85-100Зразковий; відповідає практично всім перевіреним критеріям
Добрий70-84Здоровий; незначні прогалини
Помірний50-69Прийнятний, але з помітними прогалинами; рекомендовано перевірку
У зоні ризику30-49Суттєві слабкі місця; впровадження потребує обережності
Критичний1-29Серйозні проблеми (покинутий, єдиний мейнтейнер, без базової гігієни)
ЖиттєздатністьСпільнота тавпровадженняСталість таврядуванняІнженернаякістьБезпекаГотовність доШІ

Профіль оцінок

Кожна вісь — окрема категорія. Форма важить більше, ніж середнє: здоровий об'єкт заповнює всю фігуру, тоді як профіль із піками та провалами означає, що сила в одному вимірі маскує ризик в іншому.

Політика юрисдикцій високого ризику застосовує множник 20% до зваженого загального індексу здоров’я і встановлює для нього межу «У зоні ризику» на рівні 49.

Власність

Max MazurovОсобистий обліковий запис
221 підписник72 публічні репозиторіїз бер. 2018 р.VK Tech

Цей репозиторій належить особистому обліковому запису. Проєкт з єдиним власником несе більший ризик безперервності, ніж підтримуваний організацією.

Пакетні екосистеми

РеєстрПакетВерсіяЗавантажень / місВерсіїОстання публікація
Gogithub.com/foxcpp/go-imap-sqlv0.5.0-62160 днів тому

Метрики за категоріями

Життєздатність

Чи живий проєкт — чи пишеться код і чи виходять релізи?

27Критичний · 22% загального індексу
Як обчислюється оцінка
9.9/36Свіжість push — останній push 102 дн. тому
0.7/36Ритм комітів — 1/52 тижнів із комітами
4.3/18Обсяг комітів — 2 комітів за останній рік
0/10OpenSSF Scorecard: Maintained — 0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0
Використані вхідні дані
commits_last_year2
human_commit_share1
days_since_last_push102
active_weeks_last_year1

Дисципліна релізів

44У зоні ризику
Як обчислюється оцінка
27/27Випускає релізи — опубліковано 6 релізів
0/36Свіжість релізів — останній реліз 1 808 дн. тому
12.6/27Ритм релізів — реліз кожні ~165,6 дн.
0/10OpenSSF Scorecard: Signed-Releases — немає даних
Використані вхідні дані
releases_count6
latest_release_tagv0.5.0
releases_from_tagsні
days_since_latest_release1 808
mean_days_between_releases165,6
Виключено з оцінювання (немає даних або не застосовно): OpenSSF Scorecard: Signed-Releases. Залишкові ваги перенормовано.

Спільнота та впровадження

Чи має проєкт користувачів, завантаження, увагу та влаштовані умови для контриб’юторів?

41У зоні ризику · 18% загального індексу
Як обчислюється оцінка
22.7/60Зірки — 26 зірок
8.7/25Форки — 12 форків
1.7/15Спостерігачі — 3 спостерігачів
Використані вхідні дані
forks12
stars26
watchers3
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history
Як обчислюється оцінка
22.5/22.5README
22.5/22.5Ліцензія — визнана ліцензія (MIT)
0/18Настанови CONTRIBUTING
0/13.5Кодекс поведінки
0/7.2Шаблон issue
0/6.3Шаблон PR
Використані вхідні дані
has_readmeтак
has_licenseтак
has_contributingні
has_issue_templateні
has_code_of_conductні
has_pull_request_templateні

Сталість та врядування

Чи переживе проєкт своїх людей — бас-фактор, реактивність, хто за ним стоїть і як супроводжуються пакети?

51Помірний · 24% загального індексу
Як обчислюється оцінка
9/54Бас-фактор — на 1 контриб’ютор(ів) припадає половина всіх комітів
0.5/22.5Розподіл комітів — головний контриб’ютор — автор 98% комітів
5.4/13.5Широта контриб’юторів — 4 контриб’юторів
3/10OpenSSF Scorecard: Contributors — project has 1 contributing companies or organizations -- score normalized to 3
Використані вхідні дані
bus_factor1
contributors_sampled4
top_contributor_share0,98
Як обчислюється оцінка
23.9/46.8Вирішення issue — закрито 51% issue
38.2/38.3Прийняття PR — злито 4/4 вирішених PR
1.5/15OpenSSF Scorecard: Code-Review — Found 3/27 approved changesets -- score normalized to 1
Використані вхідні дані
merged_prs4
open_issues20
closed_issues21
issue_closed_ratio0,512
closed_unmerged_prs0
Як обчислюється оцінка
10/30Підтримка власника — особистий (користувацький) обліковий запис
0/20Верифікований домен — не застосовно до користувацьких облікових записів
16.9/25Охоплення власника — 221 підписників у foxcpp
25/25Послужний список — 72 публічних репозиторіїв, вік облікового запису ~8 р.
Використані вхідні дані
followers221
owner_typeUser
is_verified
owner_loginfoxcpp
public_repos72
account_age_days3 038
Виключено з оцінювання (немає даних або не застосовно): Верифікований домен. Залишкові ваги перенормовано.
Як обчислюється оцінка
25/25Опубліковано й доступно — 1 пакет(ів) у go
4/35Свіжість публікацій — остання публікація 2 160 дн. тому
20/20Історія версій — 6 опублікованих версій
20/20Не застарілий — активний, не deprecated і не yanked
Використані вхідні дані
packagesgithub.com/foxcpp/go-imap-sql
ecosystemsgo
any_deprecatedні
min_days_since_publish2 160

Інженерна якість

Чи наявні базові інженерні практики та документація?

44У зоні ризику · 20% загального індексу

Інженерні практики

40У зоні ризику
Як обчислюється оцінка
0/24Процеси CI
24/24Наявні тести
16/16Конфігурація лінтера — .golangci.yml
0/9.6Pre-commit-хуки
0/6.4.editorconfig
0/20OpenSSF Scorecard: CI-Tests — 0 out of 3 merged PRs checked by a CI test -- score normalized to 0
Використані вхідні дані
has_ciні
has_testsтак
has_editorconfigні
has_linter_configтак
has_precommit_configні

Документація

50Помірний
Як обчислюється оцінка
30/30README
0/25Каталог документації
0/15Сайт документації / домашня сторінка
10/10Опис репозиторію
10/10Теми — 3 тем
0/10Wiki
Використані вхідні дані
topicsimap, imap-server, mail
has_wikiні
homepage
has_readmeтак
has_docs_dirні
has_descriptionтак

Безпека

Чи міцні видимі практики безпеки й ланцюга постачання, без непослабленої пов’язаності з юрисдикціями високого ризику?

24Критичний · 16% загального індексу

Стан безпеки

5Критичний
Як обчислюється оцінка
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 — немає даних
0/7.5Dependency-Update-Tool — no update tool detected
0/5Fuzzing — project is not fuzzed
2.5/2.5Ліцензія — 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 — немає даних
0/5Pinned-Dependencies — немає даних
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 — немає даних
0/7.5Token-Permissions — немає даних
6.8/7.5Vulnerabilities — 1 existing vulnerabilities detected
Використані вхідні дані
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
Виключено з оцінювання (немає даних або не застосовно): dangerous_workflow, packaging, pinned_dependencies, signed_releases, token_permissions. Залишкові ваги перенормовано. Політика юрисдикцій високого ризику застосовує множник 20% і встановлює для стану безпеки межу «У зоні ризику» на рівні 49.
Як обчислюється оцінка
35/35Прямі залежності без відомих сповіщень — жодна пряма залежність не має відомих сповіщень
0/25Непрямі залежності без відомих сповіщень — транзитивний набір не відокремлюється від залежностей розробки й тестування в цьому обсязі
0/40Немає задавнених сповіщень — жодне сповіщення не має дати публікації
Використані вхідні дані
sourceosv
advisories0
affected_packages0
assessed_packages18
unassessed_packages0
affected_by_severitynone
direct_affected_packages0
Виключено з оцінювання (немає даних або не застосовно): Непрямі залежності без відомих сповіщень, Немає задавнених сповіщень. Залишкові ваги перенормовано. Звірено 18 резолвлених залежностей із OSV. Цей репозиторій не публікує пакета, який резолвить індекс, тож натомість оцінено граф залежностей репозиторію. Цей граф змішує закріплені версії для розробки й тестування зі справді постачаними залежностями, тож оцінюються лише задекларовані runtime-залежності; транзитивні знахідки подаються як контекст і в оцінку не входять. Досяжність не аналізується.

Готовність до ШІ

Наскільки репозиторій оснащений для розробки та супроводу за участі ШІ-агентів? Незалежний, експериментальний бейдж — вага 0.0, тож він подається окремо і не впливає на загальний індекс здоров'я.

56Помірний · 0% загального індексу
Як обчислюється оцінка
0/45Інструкції для агентів — немає CLAUDE.md / AGENTS.md / правил редактора
0/15Машиночитана документація (llms.txt)
9.6/40Читабельна історія комітів — намір зазначено у 18 з 100 людських комітів (структурований заголовок або пояснювальний текст)
Використані вхідні дані
has_llms_txtні
legible_history_share0,18
agent_instruction_files
agent_instruction_max_bytes
Як обчислюється оцінка
12.6/18Розгортання однією командою — go.mod (домовленість інструментарію, без раннера задач)
22/22Автоматизовані тести
11/11Конфігурація лінтера / форматера — .golangci.yml
11/11Статична перевірка типів — Go (статично типізована)
10/10Відтворюване середовище — lockfile
0/10Підтверджена практика роботи з агентами — серед останніх 100 комітів немає створених агентом
0/8Автоматизоване супроводження — автоматичних оновлень залежностей не виявлено
0/10OpenSSF Scorecard: Pinned-Dependencies — немає даних
Використані вхідні дані
has_nixні
has_testsтак
lockfilesgo.sum
has_dockerfileні
typed_languageтак
bootstrap_files
has_devcontainerні
has_linter_configтак
typecheck_configs
agent_commit_share0
toolchain_manifestsgo.mod
dependency_bot_commit_share0
Виключено з оцінювання (немає даних або не застосовно): OpenSSF Scorecard: Pinned-Dependencies. Залишкові ваги перенормовано.
Як обчислюється оцінка
45/45Типізований код — Go (статично типізована)
55/55Керовані розміри файлів — 0/43 файлів вихідного коду понад 60 КБ
Використані вхідні дані
primary_languageGo
largest_source_bytes24 875
source_files_sampled43
oversized_source_files0

Ключові факти

26зірок GitHub
4контриб'юторів
2комітів за останні 12 місяців
102днів від останнього пушу
6релізів
1бас-фактор
20відкритих issue
Goпакетних екосистем

Попередження щодо збору даних

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

Докладніше

Історія зірок і форків 0 ★ / 12 ⇿
0Зірки
12Форки
6Релізи

Коли додано кожну зірку й форк — зібрано з GitHub і згруповано за днями. Кумулятивне зростання розміщено просто над денними додаваннями, з яких воно складається, тож їх видно одне проти одного: рівномірне органічне накопичення виглядає зовсім інакше, ніж різкий короткочасний сплеск. Там, де цю різницю можна виміряти, її подано як автентичність росту.

0246810121222019-032022-082026-02
Мажорні 0Мінорні 5Патчі 1

Кожна точка охоплює 7 днів.

OpenSSF Scorecard 2.6 / 10
2.6сукупно

Незалежна, не прив'язана до інструментів оцінка безпеки від відкритого проєкту OpenSSF Scorecard. Кожна перевірка винагороджує практику безпеки, а не інструмент конкретного постачальника. Перевірки, які Scorecard не зміг визначити, позначено н/д і виключено з оцінки безпеки (вони ніколи не зараховуються як нуль).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
н/дDangerous-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
н/дPackagingpackaging workflow not detected
н/дPinned-Dependenciesno dependencies found
0SASTSAST tool is not run on all commits -- score normalized to 0
0Security-Policysecurity policy file not detected
н/дSigned-Releasesno releases found
н/дToken-PermissionsNo tokens found
9Vulnerabilities1 existing vulnerabilities detected
Прямі залежності 14
РеєстрПакетОбмеження версіїМаніфест
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
Усі залежності 18

Повний розв'язаний набір залежностей із графа залежностей GitHub: 14 прямих і 4 непрямих (транзитивних) пакетів. Транзитивне замикання є повним, коли в репозиторії закомічено lockfile.

РеєстрПакетВерсіяЗв'язок
Gogithub.com/emersion/go-imap1.2.2-0.20220928192137-6fac715be9cfпряма
Gogithub.com/emersion/go-imap-sortthread1.2.0пряма
Gogithub.com/emersion/go-message0.18.0пряма
Gogithub.com/foxcpp/go-imap-backend-tests0.0.0-20220105184719-e80aa29a5e16пряма
Gogithub.com/foxcpp/go-imap-mess0.0.0-20230108134257-b7ec3a649613пряма
Gogithub.com/foxcpp/go-imap-namespace0.0.0-20200802091432-08496dd8e0edпряма
Gogithub.com/go-sql-driver/mysql1.7.1пряма
Gogithub.com/klauspost/compress1.17.4пряма
Gogithub.com/lib/pq1.10.9пряма
Gogithub.com/mailru/easyjson0.7.7пряма
Gogithub.com/mattn/go-sqlite31.14.19пряма
Gogithub.com/pierrec/lz42.6.1+incompatibleпряма
Gogithub.com/urfave/cli1.22.14пряма
Gogotest.tools2.2.0+incompatibleпряма
Gogithub.com/cpuguy83/go-md2man/v22.0.3непряма
Gogithub.com/emersion/go-sasl0.0.0-20231106173351-e73c9f7bad43непряма
Gogithub.com/frankban/quicktest1.5.0непряма
Gogithub.com/google/go-cmp0.5.5непряма
Сповіщення про залежності 0

Цей репозиторій не публікує пакета, який розпізнає індекс, тож оцінено його власний граф залежностей — 18 пакетів, серед яких є й піниї розробки та тестування, що ніколи не постачаються: 0 мають відомі сповіщення, з них 0 прямі.

Жодне відоме сповіщення не стосується оцінених залежностей.

Сповіщення означає, що версія, записана в графі залежностей, потрапляє в уражений діапазон. Досяжність не аналізується, а граф містить піниї розробки й тестування — знахідка може стосуватися інструментів, а не поставленого коду.

Звіт у форматі JSON машиночитний
{
  "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"
}

Оцінки — це сигнали, а не гарантії. Вони відображають публічно видимі практики на GitHub — це не аудит коду й не гарантія безпеки.

Відсутні дані виключаються, а ваги перенормовуються — нуль за відсутність ніколи не ставиться. Методологія версіонована й відкрита: метрики v1.13.0, схема v0.27.0 — повна методологія · вікі метрик.

Як окремий результат виглядає на тлі всього реєстру: сукупна статистикаGo.