Публічний реєстрКритичний
Звіт про здоров'я програмного забезпеченнясхема 0.27.0 · метрики 1.13.0 · 2026-07-25 08:58 UTC
Automattic / sqlite-database-integration
A fork of https://github.com/WordPress/sqlite-database-integration/.
Automattic/sqlite-database-integration має індекс здоров’я 18 зі 100, що відповідає смузі «Критичний». Найвищий показник — Sustainability & Governance (76/100), найнижчий — AI Readiness (23/100). Репозиторій заархівовано, тож подальшої підтримки не очікується.
18
загалом / 100Індекс здоров'я програмного забезпечення
Метрики згруповано у зважені категорії на шкалі 1–100. Загальна оцінка починається як їхнє середнє; коли публічні дані активують Політику юрисдикцій високого ризику, рейтинг коригується й отримує верхню межу 49 («Під ризиком»). Готовність до ШІ не входить до індексу.
18
Відмінний85-100Зразковий; відповідає практично всім перевіреним критеріям
Добрий70-84Здоровий; незначні прогалини
Помірний50-69Прийнятний, але з помітними прогалинами; рекомендовано перевірку
У зоні ризику30-49Суттєві слабкі місця; впровадження потребує обережності
Критичний1-29Серйозні проблеми (покинутий, єдиний мейнтейнер, без базової гігієни)
Профіль оцінок
Кожна вісь — окрема категорія. Форма важить більше, ніж середнє: здоровий об'єкт заповнює всю фігуру, тоді як профіль із піками та провалами означає, що сила в одному вимірі маскує ризик в іншому.
Abandonment Policy applies a 40% multiplier to weighted overall health and gives it a ceiling of 29.
Власність
AutomatticОрганізація
3 236 підписників1 376 публічних репозиторіївз лип. 2011 р.
За цим репозиторієм стоїть організація — спільна, підзвітна опіка, здатна пережити будь-якого окремого мейнтейнера.
Метрики за категоріями
Життєздатність
Чи живий проєкт — чи пишеться код і чи виходять релізи?
28
Активність розробки
1Критичний
Ознака покинутості
Робота надійшла, і нею ніхто не зайнявся
мейнтейнери архівували репозиторій на GitHubЗагальна оцінка: стеля «Критичний»
Сама лише тиша ніколи не є підставою — невеликій завершеній бібліотеці коміти можуть бути не потрібні роками. Ця ознака вимагає двох умов водночас: тривалої відсутності людських комітів і зобов'язань, які проєкт очевидно не виконує. Автоматичні коміти супроводженням не вважаються.
Як оцінюється покинутістьЯк обчислюється оцінка
| 0/36 | Свіжість push — останній push 417 дн. тому |
| 0/36 | Ритм комітів — 0/52 тижнів із комітами |
| 0/18 | Обсяг комітів — 0 комітів за останній рік |
| 0/10 | OpenSSF Scorecard: Maintained — project is archived |
Використані вхідні дані
| commits_last_year | 0 |
| human_commit_share | 1 |
| days_since_last_push | 417 |
| active_weeks_last_year | 0 |
Дисципліна релізів
68Помірний
Як обчислюється оцінка
| 27/27 | Випускає релізи — опубліковано 2 релізів |
| 7.2/36 | Свіжість релізів — останній реліз 481 дн. тому |
| 27/27 | Ритм релізів — реліз кожні ~39,1 дн. |
| 0/10 | OpenSSF Scorecard: Signed-Releases — немає даних |
Використані вхідні дані
| releases_count | 2 |
| latest_release_tag | v2.1.17-alpha.1 |
| releases_from_tags | ні |
| days_since_latest_release | 481 |
| mean_days_between_releases | 39,1 |
Виключено з оцінювання (немає даних або не застосовно): OpenSSF Scorecard: Signed-Releases. Залишкові ваги перенормовано.
Спільнота та впровадження
Чи має проєкт користувачів, завантаження, увагу та влаштовані умови для контриб’юторів?
28
Популярність і впровадження
9Критичний
Як обчислюється оцінка
| 4.9/60 | Зірки — 3 зірок |
| 2.5/25 | Форки — 3 форків |
| 1.7/15 | Спостерігачі — 3 спостерігачів |
Використані вхідні дані
| forks | 3 |
| stars | 3 |
| watchers | 3 |
| growth_state | unverified |
| growth_factor_pct | 100 |
| growth_unverified_reason | no_history |
Здоров'я спільноти
50Помірний
Як обчислюється оцінка
| 22.5/22.5 | README |
| 22.5/22.5 | Ліцензія — визнана ліцензія (GPL-2.0) |
| 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 | ні |
Сталість та врядування
Чи переживе проєкт своїх людей — бас-фактор, реактивність, хто за ним стоїть і як супроводжуються пакети?
76
Стійкість мейнтейнерів (бас-фактор)
62Помірний
Як обчислюється оцінка
| 25.2/54 | Бас-фактор — на 2 контриб’ютор(ів) припадає половина всіх комітів |
| 13.5/22.5 | Розподіл комітів — головний контриб’ютор — автор 40% комітів |
| 13.5/13.5 | Широта контриб’юторів — 19 контриб’юторів |
| 10/10 | OpenSSF Scorecard: Contributors — project has 8 contributing companies or organizations |
Використані вхідні дані
| bus_factor | 2 |
| contributors_sampled | 19 |
| top_contributor_share | 0,4 |
Реактивність на issue та PR
88Відмінний
Як обчислюється оцінка
| 46.8/46.8 | Вирішення issue — закрито 100% issue |
| 29/38.3 | Прийняття PR — злито 22/29 вирішених PR |
| 12/15 | OpenSSF Scorecard: Code-Review — Found 7/8 approved changesets -- score normalized to 8 |
Використані вхідні дані
| merged_prs | 22 |
| open_issues | 0 |
| closed_issues | 21 |
| issue_closed_ratio | 1 |
| closed_unmerged_prs | 7 |
Власність та опіка
80Добрий
Як обчислюється оцінка
| 30/30 | Підтримка власника — у власності організації |
| 0/20 | Верифікований домен |
| 25/25 | Охоплення власника — 3 236 підписників у Automattic |
| 25/25 | Послужний список — 1 376 публічних репозиторіїв, вік облікового запису ~15 р. |
Використані вхідні дані
| followers | 3 236 |
| owner_type | Organization |
| is_verified | — |
| owner_login | Automattic |
| public_repos | 1 376 |
| account_age_days | 5 503 |
Інженерна якість
Чи наявні базові інженерні практики та документація?
52
Інженерні практики
54Помірний
Як обчислюється оцінка
| 24/24 | Процеси CI — 5 процес(ів) CI |
| 24/24 | Наявні тести |
| 0/16 | Конфігурація лінтера |
| 0/9.6 | Pre-commit-хуки |
| 6.4/6.4 | .editorconfig |
| 0/20 | OpenSSF Scorecard: CI-Tests — 0 out of 7 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/30 | README |
| 0/25 | Каталог документації |
| 0/15 | Сайт документації / домашня сторінка |
| 10/10 | Опис репозиторію |
| 0/10 | Теми |
| 10/10 | Wiki |
Використані вхідні дані
| topics | — |
| has_wiki | так |
| homepage | — |
| has_readme | так |
| has_docs_dir | ні |
| has_description | так |
Безпека
Чи міцні видимі практики безпеки й ланцюга постачання, без непослабленої пов’язаності з юрисдикціями високого ризику?
37
Стан безпеки
37У зоні ризику
Як обчислюється оцінка
| 7.5/7.5 | Binary-Artifacts — no binaries found in the repo |
| 0/7.5 | Branch-Protection — branch protection not enabled on development/release branches |
| 0/2.5 | CI-Tests — 0 out of 7 merged PRs checked by a CI test -- score normalized to 0 |
| 0/2.5 | CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected |
| 6/7.5 | Code-Review — Found 7/8 approved changesets -- score normalized to 8 |
| 2.5/2.5 | Contributors — project has 8 contributing companies or organizations |
| 0/10 | Dangerous-Workflow — немає даних |
| 0/7.5 | Dependency-Update-Tool — no update tool detected |
| 0/5 | Fuzzing — project is not fuzzed |
| 2.5/2.5 | Ліцензія — license file detected |
| 0/7.5 | Maintained — project is archived |
| 0/5 | Packaging — немає даних |
| 0/5 | Pinned-Dependencies — немає даних |
| 0/5 | SAST — SAST tool is not run on all commits -- score normalized to 0 |
| 0/5 | Security-Policy — security policy file not detected |
| 0/7.5 | Signed-Releases — немає даних |
| 0/7.5 | Token-Permissions — немає даних |
| 7.5/7.5 | Vulnerabilities — 0 existing vulnerabilities detected |
Використані вхідні дані
| source | openssf_scorecard |
| checks_evaluated | 13 |
| scorecard_version | v5.5.0 |
| checks_inconclusive | 5 |
| scorecard_aggregate | 3,7 |
Виключено з оцінювання (немає даних або не застосовно): dangerous_workflow, packaging, pinned_dependencies, signed_releases, token_permissions. Залишкові ваги перенормовано.
Готовність до ШІ
Наскільки репозиторій оснащений для розробки та супроводу за участі ШІ-агентів? Незалежний, експериментальний бейдж — вага 0.0, тож він подається окремо і не впливає на загальний індекс здоров'я.
23
Контекст і настанови для агентів
9Критичний
Як обчислюється оцінка
| 0/45 | Інструкції для агентів — немає CLAUDE.md / AGENTS.md / правил редактора |
| 0/15 | Машиночитана документація (llms.txt) |
| 9.1/40 | Читабельна історія комітів — намір зазначено у 17 з 100 людських комітів (структурований заголовок або пояснювальний текст) |
Використані вхідні дані
| has_llms_txt | ні |
| legible_history_share | 0,17 |
| agent_instruction_files | — |
| agent_instruction_max_bytes | — |
Як обчислюється оцінка
| 0/18 | Розгортання однією командою |
| 22/22 | Автоматизовані тести |
| 0/11 | Конфігурація лінтера / форматера |
| 0/11 | Статична перевірка типів |
| 0/10 | Відтворюване середовище |
| 0/10 | Підтверджена практика роботи з агентами — серед останніх 100 комітів немає створених агентом |
| 0/8 | Автоматизоване супроводження — автоматичних оновлень залежностей не виявлено |
| 0/10 | OpenSSF Scorecard: Pinned-Dependencies — немає даних |
Використані вхідні дані
| has_nix | ні |
| has_tests | так |
| lockfiles | — |
| has_dockerfile | ні |
| typed_language | ні |
| bootstrap_files | — |
| has_devcontainer | ні |
| has_linter_config | ні |
| typecheck_configs | — |
| agent_commit_share | 0 |
| toolchain_manifests | — |
| dependency_bot_commit_share | 0 |
Виключено з оцінювання (немає даних або не застосовно): OpenSSF Scorecard: Pinned-Dependencies. Залишкові ваги перенормовано.
Читабельність коду для моделей
46У зоні ризику
Як обчислюється оцінка
| 0/45 | Типізований код — PHP без конфігурації перевірки типів |
| 46.2/55 | Керовані розміри файлів — 9/56 файлів вихідного коду понад 60 КБ |
Використані вхідні дані
| primary_language | PHP |
| largest_source_bytes | 178 927 |
| source_files_sampled | 56 |
| oversized_source_files | 9 |
Ключові факти
3зірок GitHub
19контриб'юторів
0комітів за останні 12 місяців
417днів від останнього пушу
2релізів
2бас-фактор
0відкритих issue
Packagistпакетних екосистем
Попередження щодо збору даних
- Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token
- Could not fetch packagist package 'wordpress/sqlite-database-integration' from its registry
Докладніше
Історія зірок і форків 0 ★ / 3 ⇿
0Зірки
3Форки
1Релізи
Коли додано кожну зірку й форк — зібрано з GitHub і згруповано за днями. Кумулятивне зростання розміщено просто над денними додаваннями, з яких воно складається, тож їх видно одне проти одного: рівномірне органічне накопичення виглядає зовсім інакше, ніж різкий короткочасний сплеск. Там, де цю різницю можна виміряти, її подано як автентичність росту.
Мажорні 0Мінорні 0Патчі 0
OpenSSF Scorecard 3.7 / 10
3.7сукупно
Незалежна, не прив'язана до інструментів оцінка безпеки від відкритого проєкту OpenSSF Scorecard. Кожна перевірка винагороджує практику безпеки, а не інструмент конкретного постачальника. Перевірки, які Scorecard не зміг визначити, позначено н/д і виключено з оцінки безпеки (вони ніколи не зараховуються як нуль).
| 10 | Binary-Artifacts | no binaries found in the repo |
| 0 | Branch-Protection | branch protection not enabled on development/release branches |
| 0 | CI-Tests | 0 out of 7 merged PRs checked by a CI test -- score normalized to 0 |
| 0 | CII-Best-Practices | no effort to earn an OpenSSF best practices badge detected |
| 8 | Code-Review | Found 7/8 approved changesets -- score normalized to 8 |
| 10 | Contributors | project has 8 contributing companies or organizations |
| н/д | Dangerous-Workflow | no workflows found |
| 0 | Dependency-Update-Tool | no update tool detected |
| 0 | Fuzzing | project is not fuzzed |
| 10 | License | license file detected |
| 0 | Maintained | project is archived |
| н/д | Packaging | packaging workflow not detected |
| н/д | Pinned-Dependencies | no dependencies found |
| 0 | SAST | SAST tool is not run on all commits -- score normalized to 0 |
| 0 | Security-Policy | security policy file not detected |
| н/д | Signed-Releases | no releases found |
| н/д | Token-Permissions | No tokens found |
| 10 | Vulnerabilities | 0 existing vulnerabilities detected |
Усі залежності 0
Повний розв'язаний набір залежностей із графа залежностей GitHub: 0 прямих і 0 непрямих (транзитивних) пакетів. Транзитивне замикання є повним, коли в репозиторії закомічено lockfile.
| Реєстр | Пакет | Версія | Зв'язок |
|---|
Сповіщення про залежності не оцінено
Звірка сповіщень не відбулася для цього звіту: No resolved dependencies to assess
Звіт у форматі JSON машиночитний
{
"data": {
"repo": {
"topics": [],
"is_fork": false,
"size_kb": 6279,
"has_wiki": true,
"homepage": null,
"languages": {
"PHP": 1374442,
"ANTLR": 173712,
"Shell": 3487
},
"pushed_at": "2025-06-02T13:24:46Z",
"created_at": "2025-01-13T09:39:28Z",
"owner_type": "Organization",
"updated_at": "2025-06-02T13:25:46Z",
"description": "A fork of https://github.com/WordPress/sqlite-database-integration/.",
"is_archived": true,
"is_disabled": false,
"license_spdx": "GPL-2.0",
"default_branch": "develop",
"license_spdx_raw": "GPL-2.0",
"primary_language": "PHP",
"significant_languages": [
"PHP",
"ANTLR"
]
},
"owner": {
"blog": "https://automattic.com",
"name": "Automattic",
"type": "Organization",
"login": "Automattic",
"company": null,
"location": "Worldwide",
"followers": 3236,
"avatar_url": "https://avatars.githubusercontent.com/u/887802?v=4",
"created_at": "2011-07-01T02:45:15Z",
"is_verified": null,
"public_repos": 1376,
"account_age_days": 5503
},
"license": {
"state": "standard",
"spdx_id": "GPL-2.0",
"raw_spdx": "GPL-2.0",
"file_present": true,
"scorecard_found": true,
"profile_has_license": true
},
"activity": {
"releases": [
{
"tag": "v2.1.17-alpha.1",
"kind": "prerelease",
"published_at": "2025-03-31T08:35:35Z"
},
{
"tag": "v2.1.17-alpha",
"kind": "prerelease",
"published_at": "2025-02-20T06:40:47Z"
}
],
"recent_commits": [
{
"oid": "a7918e8cf4684894aa4a5a1c63e4c9ac66c54355",
"body": null,
"is_bot": false,
"headline": "Archive the fork",
"author_name": "Jan Jakeš",
"author_login": "JanJakes",
"committed_at": "2025-06-02T13:24:46Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a6a760e4bb40d4f78439607666df377927fe1d5b",
"body": "**List of discovered issues:**\n\n- [x] Data types from `_mysql_data_types_cache` are sometimes not\ncorrectly fetched, as they can be saved in multiple formates (lowercase,\nuppercase, with or without backticks).\n- [x] MySQL applies type casting when saving data in non-strict mode,\nresulting in things \n[…]\n but\nSQLite requires it to be `2025-03-07 09:05:02`.)\n- [x] In multi-process environments (php-fpm), concurrent writes can\ncause \"SQLSTATE[HY000]: General error: 5 database is locked\"\n(`SQLITE_BUSY`).",
"is_bot": false,
"headline": "New driver fixes from manual testing (#51)",
"author_name": "Jan Jakeš",
"author_login": "JanJakes",
"committed_at": "2025-05-30T13:00:17Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "a2ea9f810a0132fcaccc98952baaa2a5901aea22",
"body": "The information schema builder requires a few small touches for the new\ndriver release:\n\n- [X] It creates some tables that we don't support yet — let's remove\nthose queries.\n- [X] It doesn't maintain the `table_constraints` table. This table will\nbe needed in the future, and since it also store some\n[…]\nX] Make sure identifiers are case-insensitive\n- [X] Verify index and constraint naming — e.g., what happens when both\nconstraint name and index name are specified, and how duplicate names\nare handled.",
"is_bot": false,
"headline": "Information schema cleanup and improvements (#49)",
"author_name": "Jan Jakeš",
"author_login": "JanJakes",
"committed_at": "2025-05-26T13:07:19Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "5652edb9d42fbc375c48118b8030088830d43515",
"body": "The new SQLite driver already uses some features from PHP 7.2.\n\nWordPress [recommends](https://wordpress.org/about/requirements/) PHP\n7.4+ and requires PHP 7.2.24+.\n\nCloses\nhttps://github.com/Automattic/sqlite-database-integration/issues/12.",
"is_bot": false,
"headline": "Update minimum required PHP version to 7.2 (#48)",
"author_name": "Jan Jakeš",
"author_login": "JanJakes",
"committed_at": "2025-05-12T11:16:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "278d41c9b6c56950f9faa9c4f53f9a4d90609dcb",
"body": null,
"is_bot": false,
"headline": "Fix identifier (un)escaping (#47)",
"author_name": "Jan Jakeš",
"author_login": "JanJakes",
"committed_at": "2025-05-07T22:23:50Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "82eed09592c3de74cf6216048960a204650f23e1",
"body": "Database configuration and migration",
"is_bot": false,
"headline": "Merge pull request #42 from Automattic/driver-migration",
"author_name": "Jan Jakeš",
"author_login": "JanJakes",
"committed_at": "2025-05-05T07:19:37Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2a1330451bad4e08f1445ca857e2470aae53932b",
"body": null,
"is_bot": false,
"headline": "Improve test readability",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-05-02T08:02:46Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fcd666910cf590cf0618303e9e2c3a78163ad75a",
"body": null,
"is_bot": false,
"headline": "Add unique constraints to information schema tables",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-05-02T08:02:45Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5004c07c4f14fd7f2ed50311e49b03889d407a73",
"body": null,
"is_bot": false,
"headline": "Fix and improve default value formatting",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-30T09:09:11Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4a327fb1e830e06e29673789900b61068d4761ad",
"body": "Add PHP 8.4 unit tests to CI",
"is_bot": false,
"headline": "Merge pull request #45 from Automattic/php-8.4",
"author_name": "Jan Jakeš",
"author_login": "JanJakes",
"committed_at": "2025-04-30T07:58:23Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b27339ca0b2065a403823890e8be7e5e4aa0d7de",
"body": "Fix deprecation of implicitly marking parameter as nullable in PHP 8.4",
"is_bot": false,
"headline": "Merge pull request #43 from Automattic/fixes",
"author_name": "Jan Jakeš",
"author_login": "JanJakes",
"committed_at": "2025-04-30T07:58:03Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9b21ab3ac52515b42456be57bba3703a0c7608ef",
"body": "…:query()",
"is_bot": false,
"headline": "Fix parser API, explicitly disable multi-queries in WP_SQLite_Driver:…",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-29T15:31:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c745a66a96d92385cdd629397bc59126cedbc4af",
"body": null,
"is_bot": false,
"headline": "Unify quoting also for $wpdb->blogs table name",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-29T14:36:37Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "838967ac2ebd2b6d9c7c9a38ab9e020305100aa5",
"body": null,
"is_bot": false,
"headline": "Always quote identifiers in information schema builder",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-29T14:18:45Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4df273e6f962cee4861ba97fcc053e43a7e05048",
"body": null,
"is_bot": false,
"headline": "Fix and refactor test setup",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-29T14:18:45Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "1d284e6eacc1557d8afb3c5a8cab48573c55b37d",
"body": "…ve docs",
"is_bot": false,
"headline": "Consolidate SQLite identifier escaping in WP_SQLite_Connection, impro…",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-29T14:18:45Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b0009d6ecf4bc3bae0775ec4c5350c85f000fa8c",
"body": null,
"is_bot": false,
"headline": "Extract SQLite connection management to WP_SQLite_Connection",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-29T07:32:36Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "94e582cf508a1ffc0775e2179ae438dade2d89ad",
"body": null,
"is_bot": false,
"headline": "Always quote identifiers in driver and reconstructor",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-28T18:16:31Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "859fb9f76ea3a2e93795e79ed247b9e89be28a25",
"body": "Co-authored-by: Adam Zieliński <adam@adamziel.com>",
"is_bot": false,
"headline": "Improve CI job name",
"author_name": "Jan Jakeš",
"author_login": "JanJakes",
"committed_at": "2025-04-28T18:16:31Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d1dfd2c863fdc7bb8a01b7b6d758435ef76b5394",
"body": null,
"is_bot": false,
"headline": "Fix removing schema records for non-existent tables",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-28T18:16:31Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "959505ee184eb2b7c60978ceb66c4edf9d19b5de",
"body": null,
"is_bot": false,
"headline": "Fix schema inference for WordPress tables",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-28T18:16:30Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "35950e73780e738e73dfe8b998e3fd6600ed2e88",
"body": null,
"is_bot": false,
"headline": "Add PHP 8.4 unit tests to CI",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-25T12:29:54Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "747ee356fad2db41b100c3f169d888c21e22e9ca",
"body": null,
"is_bot": false,
"headline": "Fix deprecation of implicitly marking parameter as nullable in PHP 8.4",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-25T11:40:23Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c67f6c4e57ab5f0b89bf2d4f3e8d6685092e72f1",
"body": null,
"is_bot": false,
"headline": "Refactor default value handling, add escaping and tests",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-25T11:29:47Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "baa22c3fb607ddb8c395d28ec48f480f9491d9bb",
"body": null,
"is_bot": false,
"headline": "For multisite installs, reconstruct WP schema for all sites",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-25T10:56:06Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fd55809fe0dacde60028446f85a90ae45c6ebe75",
"body": null,
"is_bot": false,
"headline": "Extract WP schema to a method, improve naming and docs",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-25T10:55:24Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "be2841d1d7462dce21b7cabbf4218db476ff25b4",
"body": null,
"is_bot": false,
"headline": "Improve and document default column value detection",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-24T16:09:01Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "231bab22e3428922832bab5b40b375e3ac531338",
"body": null,
"is_bot": false,
"headline": "Refactor and document key definition inference",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-24T15:42:42Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "1121fccfd6dac98ed261e642503dc2ac9d82b122",
"body": null,
"is_bot": false,
"headline": "Refactor and document key column definition inference",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-24T08:57:54Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6a3b370b2406defeb5cc6f8ebb0197a31b2caa7c",
"body": null,
"is_bot": false,
"headline": "Return parser instance rather than a generator",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-23T14:30:53Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "30c82125e4fd0c0adec431593bca75a0626e6c03",
"body": null,
"is_bot": false,
"headline": "Move multi-query parsing to WP_MySQL_Parser, improve naming and docs",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-23T14:10:57Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e657ad0e8367bb980d43191e135d028258f1956e",
"body": null,
"is_bot": false,
"headline": "Pass input in tokens and get token values lazily",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-23T13:37:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "02838843cb813e5b4b3f5f653313fa420eff6fa5",
"body": null,
"is_bot": false,
"headline": "Parse queries from \"wp_get_db_schema()\"",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-23T09:36:10Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "cde7da8641a39ce937684459ed899b37a205e3f8",
"body": null,
"is_bot": false,
"headline": "Store and expose byte start and length in tokens and nodes",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-23T09:35:16Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "69381d8c75f35ee67ca989828640e9c1668889c4",
"body": null,
"is_bot": false,
"headline": "Add support for multi-query parsing",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-23T09:34:41Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d9040642417e10bd999dd6cdcd470cc122fa4f0f",
"body": null,
"is_bot": false,
"headline": "Fix $wpdb dependency loop when using schema reconstructor in WP",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-23T08:29:50Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "51b22fa12669e78a6403e08c54da0e8823df0bc8",
"body": "…onfiguration",
"is_bot": false,
"headline": "Do not acquire an exclusive lock for every version check, lock only c…",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-22T13:41:23Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "95b1a198e74252768332052385e43b914cb5ada9",
"body": null,
"is_bot": false,
"headline": "Document SQLite column affinity inline",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-22T13:37:21Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5dddd50e7376bf94e3eade631a7945f9bdee535a",
"body": null,
"is_bot": false,
"headline": "Improve the clarity of primary key reconstruction",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-22T12:05:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5edd7f72aebfcd1c0aac43589aa1eb0d2b64b71b",
"body": null,
"is_bot": false,
"headline": "Filter out reserved tables using LIKE",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-22T11:59:52Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b178b9709d0d3b7f89f771039066cba93506dcae",
"body": null,
"is_bot": false,
"headline": "In WordPress, make sure the \"wp_get_db_schema()\" function is defined",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-22T08:35:04Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "907be69765fc6e91b396f577c425c0804bc4836d",
"body": null,
"is_bot": false,
"headline": "Fix identifier unquoting",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-22T08:19:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "287f4f43fc995cf4b69586e33a24f6783a11edb1",
"body": null,
"is_bot": false,
"headline": "Improve docs",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-22T08:13:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ed959fb299654f7455a4b11d565f7ae48f63e568",
"body": null,
"is_bot": false,
"headline": "Avoid race conditions when configuring the SQLite database",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-17T14:35:07Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "23331b36c3b0753478318968fbf9c80b382475d1",
"body": null,
"is_bot": false,
"headline": "Reconstruct WordPress tables using \"wp_get_db_schema\" function",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-17T14:35:07Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7727cfa3ade2de7de27c69fe0be6893155d441b9",
"body": null,
"is_bot": false,
"headline": "Implement information schema reconstructor",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-17T14:35:07Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9a6da9d9627aa91cb17951de32cd5e42f06a4428",
"body": null,
"is_bot": false,
"headline": "Load AST classes for tests in test bootstrap",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-16T07:27:01Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "12d30633016489bcebec88b9f64b92c6fbd8fcdf",
"body": null,
"is_bot": false,
"headline": "Implement more robust plugin version definition and CI check",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-15T15:26:07Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6a641f970419430b1c83ab9d439cdf7ed2b8562c",
"body": "…igration",
"is_bot": false,
"headline": "Implement a database configurator service for DB initialization and m…",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-04-15T14:19:42Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "767d246522691c62f3e8ee316092e0cd781cede2",
"body": null,
"is_bot": false,
"headline": "Check if $_ENV['WP_SQLITE_AST_DRIVER'] is defined (#37)",
"author_name": "Bero",
"author_login": "bgrgicak",
"committed_at": "2025-03-31T07:56:21Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "64526019a175abc193274bb72e9d5f3a68c1cac3",
"body": "Fix warnings on site health screen",
"is_bot": false,
"headline": "Merge pull request #34 from Automattic/fix-site-health-warnings",
"author_name": "Jan Jakeš",
"author_login": "JanJakes",
"committed_at": "2025-03-26T14:46:12Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3faa5533f5ad1b9299430d54a263c3383cce011d",
"body": null,
"is_bot": false,
"headline": "Add a comment explaining why \"WHERE true\" clause is used",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-26T09:53:59Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6e83c1963e322fd2b570892f175f9cb74d690fd4",
"body": "Information schema subqueries need to provide the actual database name,\nso that parent queries that compare against it return some data.\n\nFixes:\n\nWarning: Undefined array key \"wp_comments\" in /var/www/html/wp-admin/includes/class-wp-site-health.php on line 3586\nWarning: Attempt to read property \"row\n[…]\nsers\" in /var/www/html/wp-admin/includes/class-wp-site-health.php on line 3586\nWarning: Attempt to read property \"rows\" on null in /var/www/html/wp-admin/includes/class-wp-site-health.php on line 3586",
"is_bot": false,
"headline": "Fix warnings on site health screen",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-25T16:02:42Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "4074c5290521f9fbd38228b3a456ccee8feb64fb",
"body": "Respect strict/non-strict MySQL modes",
"is_bot": false,
"headline": "Merge pull request #29 from Automattic/strict-sql-mode",
"author_name": "Jan Jakeš",
"author_login": "JanJakes",
"committed_at": "2025-03-25T15:51:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "69493b1dc02d1a4083ee3aa9ed66a31f27499dca",
"body": "Co-authored-by: Adam Zieliński <adam@adamziel.com>",
"is_bot": false,
"headline": "Fix typo",
"author_name": "Jan Jakeš",
"author_login": "JanJakes",
"committed_at": "2025-03-25T14:47:37Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "079166da9e6600f366a95d7e0834b7e9af1e4a8b",
"body": "…t mode",
"is_bot": false,
"headline": "Add a test to ensure ON DUPLICATE KEY UPDATE clause ignores non-stric…",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-25T14:11:28Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d39df538d3aa042f8b8b922199dc4d920b70dd9f",
"body": null,
"is_bot": false,
"headline": "Add a test for REPLACE statement in non-strict mode",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-25T13:24:39Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f922251617388a2d7626cfed6e3235a056478395",
"body": null,
"is_bot": false,
"headline": "Improve non-strict mode method docs",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-25T13:24:39Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d6f6b6d93c94d0e181a89677b75c8a2284c790aa",
"body": null,
"is_bot": false,
"headline": "Bail out with error for unsupported SET statements",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-25T13:24:39Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ad474afd906e8afdc0ef32b6cfc413d5d120942f",
"body": null,
"is_bot": false,
"headline": "Add more non-strict mode tests",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-25T13:24:39Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "1acd61144a027980f194c00d52a0d9af160f481e",
"body": null,
"is_bot": false,
"headline": "Remove now passing tests from exclusion lists",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-25T13:24:32Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2fe31e6bc7a28cffb8268fae4290fdb92a0221e4",
"body": null,
"is_bot": false,
"headline": "Do not pre-create WP schema for metadata tests",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-25T13:10:24Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "71de197cd1de7eb18f9762f4da8d77c0b7b5eef0",
"body": null,
"is_bot": false,
"headline": "Make an optional parameter required",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-25T13:10:24Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "038736122e1671e30a7bf4f0d0057f8a98192e7a",
"body": null,
"is_bot": false,
"headline": "Fix TRUNCATE in a database with no sequences",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-25T13:10:23Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ad8256a71dd83e8e7c9367874bd02bbf65c163cb",
"body": null,
"is_bot": false,
"headline": "Preserve ordinal position when changing column",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-25T13:10:23Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b48a8add6be9aa487c04cbb4335dddb279d230a3",
"body": null,
"is_bot": false,
"headline": "Implement WPDB's set_sql_mode() method for SQLite",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-25T13:10:23Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "172fd7245b8617f275a1bda66f0760da8d65ec3a",
"body": null,
"is_bot": false,
"headline": "Implement reading session SQL modes",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-25T13:10:23Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "73132a64fdf03746b3286e6d1470176fd0bc2796",
"body": null,
"is_bot": false,
"headline": "Implement setting session SQL modes",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-25T13:10:23Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "257e916951c1caec9dbb5172a1441ad8f9418bab",
"body": null,
"is_bot": false,
"headline": "Implement emulation of MySQL non-strict mode for UPDATE queries",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-25T13:10:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "52769f0e21425355a4346ad30f46c69ef80b2b63",
"body": null,
"is_bot": false,
"headline": "Implement emulation of MySQL non-strict mode for INSERT queries",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-25T13:10:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c9b443b5bb918dd828a0dd1c322697bfd92272bb",
"body": "Fix some WP unit test errors",
"is_bot": false,
"headline": "Merge pull request #32 from Automattic/fix-reflection-exception",
"author_name": "Jan Jakeš",
"author_login": "JanJakes",
"committed_at": "2025-03-25T11:44:47Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ad3beb840a52421ea327c76bb4cf8ba7bce00e57",
"body": null,
"is_bot": false,
"headline": "Pass $dbname into WP_SQLite_DB",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-24T14:47:09Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "91ca58f7c6397b96e4035e78ef6c483b33762fc6",
"body": "Fixes \"ReflectionException: Property WP_SQLite_DB::$allow_unsafe_unquoted_parameters does not exist\"\nin WordPress PHPUnit tests.",
"is_bot": false,
"headline": "Fix ReflectionException in PHPUnit tests",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-24T14:30:01Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a0568764ff8c357e1542b36c431748fe4e97c4aa",
"body": "Temporary table support",
"is_bot": false,
"headline": "Merge pull request #27 from Automattic/temporary-table-support",
"author_name": "Jan Jakeš",
"author_login": "JanJakes",
"committed_at": "2025-03-13T09:27:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b865620bed1b0a6688499e5f3d7c6ab9146d874c",
"body": null,
"is_bot": false,
"headline": "Create temporary information schema tables at most once per session",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-12T16:43:08Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "40cef5b538d5342520341ff382554952c7732e99",
"body": "This can fall through to the default case.",
"is_bot": false,
"headline": "Remove a forgotten call to a non-existent method",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-12T12:59:55Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "dfee2ddbf838cad23bbfbc846fb524819bed143b",
"body": null,
"is_bot": false,
"headline": "Move IF NOT EXISTS tests to driver tests",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-12T12:57:08Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0d0349e086ae44c126fa64439fd02c7b1303dfed",
"body": null,
"is_bot": false,
"headline": "Explicitly disable CREATE TABLE ... [AS] SELECT statements",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-12T12:57:08Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "bdc12f3a8beaa21f7bbd3cca86befe5ffbdf68e7",
"body": null,
"is_bot": false,
"headline": "Correctly support temp tables by using temp information schema",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-12T12:57:08Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "545f95a6bcf47882cd57b5516e3f354caaf046c2",
"body": "WordPress unit tests",
"is_bot": false,
"headline": "Merge pull request #26 from Automattic/wp-unit-tests",
"author_name": "Jan Jakeš",
"author_login": "JanJakes",
"committed_at": "2025-03-11T15:53:43Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2d0e59db104755280117b25ac24cf435502cdd84",
"body": null,
"is_bot": false,
"headline": "Fix _real_escape() implementation as per WPDB",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-10T16:42:12Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "11576c5bc1a4950db59405d49d84e930f28f8bcb",
"body": null,
"is_bot": false,
"headline": "Do not bypass esc_like for the new driver",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-10T16:42:12Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "368e39538e79f30234a88be0561585710ea6abf8",
"body": null,
"is_bot": false,
"headline": "Fix _real_escape behavior for non-scalar values",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-10T15:53:35Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a68b358b9161b0043cd90e60769c09e228ca28ea",
"body": null,
"is_bot": false,
"headline": "Setup and run WordPress PHPUnit tests",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-10T15:51:59Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4b5f383327944af5a5348b2d32e3f95d302b178e",
"body": null,
"is_bot": false,
"headline": "Allow using the new driver for initial database creation",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-10T15:36:04Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fac05067e9e2977fb91fdeac9a43003be09aa3de",
"body": "Driver parity",
"is_bot": false,
"headline": "Merge pull request #21 from Automattic/driver-parity",
"author_name": "Jan Jakeš",
"author_login": "JanJakes",
"committed_at": "2025-03-10T14:45:51Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c6bc3cb27d47f4008ce55778a9b108520dd802d5",
"body": null,
"is_bot": false,
"headline": "Improve TODO comment",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-05T09:52:03Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "abdd93e308c42ba7fc05bc4d25e2273f03f83c0c",
"body": null,
"is_bot": false,
"headline": "Add comments explaining <prefix> placeholder",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-05T09:50:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ca775d25627026f7579e54b0395e70a6d43cf4f0",
"body": "Fix undefined method call",
"is_bot": false,
"headline": "Merge pull request #22 from Automattic/fix-undefined-method-crash",
"author_name": "Jan Jakeš",
"author_login": "JanJakes",
"committed_at": "2025-03-05T09:27:54Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "bb0e22f4ea7ea8a41a777f49d1aab22a5d86e8f9",
"body": null,
"is_bot": false,
"headline": "Fix undefined method call",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-04T15:05:03Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b48f21084f7746a3e6b0d13c5160f3d151748bfe",
"body": null,
"is_bot": false,
"headline": "Make infromation schema tables readonly",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-04T08:51:35Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "99c0350196c4c13e0efd56cb2ae4c9d63565d9a4",
"body": null,
"is_bot": false,
"headline": "Disallow accessing object with reserved prefix",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-03T20:18:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0690f4487a233153fb7557bd9dc5a2d4eba7633f",
"body": null,
"is_bot": false,
"headline": "Check for auto increment edge case, add test",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-03T17:20:03Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4dae813f377623faa1ed4764056f4604f1e81685",
"body": null,
"is_bot": false,
"headline": "Add some more TODO comments",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-03T17:20:02Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "aa659c7ac75b09d0d1f549ccbb3b7b1c63d4b5b4",
"body": null,
"is_bot": false,
"headline": "Unify temp schema quotes, add DROP TEMPORARY TABLE test",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-03T17:20:02Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "08043bc152ab2ee925d403ad629a0c93112bee35",
"body": null,
"is_bot": false,
"headline": "Add test for skiping index hints",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-03T17:20:02Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3502b1f5ee0303f48ff263b65ac0bcbdd78a600f",
"body": null,
"is_bot": false,
"headline": "Port metadata test suite to the new driver",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-03T17:20:02Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "bc6189f06c361e514d3564b33f156f1c9f57012c",
"body": null,
"is_bot": false,
"headline": "Use correct PDO exception and code when table not found",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-03T17:20:02Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "00db9655f06f4c24fe78cbd5e43f08d41010fc92",
"body": null,
"is_bot": false,
"headline": "Implement OPTIMIZE TABLE and REPAIR TABLE statements",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-03T14:28:15Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b38106e9d502ec1a10c1d99126c5c0fbf2f029bb",
"body": null,
"is_bot": false,
"headline": "Implement CHECK TABLE statement",
"author_name": "Jan Jakes",
"author_login": "JanJakes",
"committed_at": "2025-03-03T14:28:15Z",
"body_truncated": false,
"is_coding_agent": false
}
],
"releases_count": 2,
"commits_last_year": 0,
"latest_release_at": "2025-03-31T08:35:35Z",
"latest_release_tag": "v2.1.17-alpha.1",
"releases_from_tags": false,
"days_since_last_push": 417,
"active_weeks_last_year": 0,
"days_since_latest_release": 481,
"mean_days_between_releases": 39.1
},
"community": {
"has_readme": true,
"has_license": true,
"has_description": true,
"has_contributing": false,
"health_percentage": 37,
"has_issue_template": false,
"has_code_of_conduct": false,
"has_pull_request_template": false
},
"ecosystem": {
"packages": []
},
"popularity": {
"forks": 3,
"stars": 3,
"watchers": 3,
"fork_history": {
"days": [
{
"date": "2025-01-30",
"count": 1
},
{
"date": "2025-03-05",
"count": 1
},
{
"date": "2025-03-31",
"count": 1
}
],
"complete": true,
"collected": 3,
"total_forks": 3
},
"star_history": null,
"open_issues_and_prs": 0
},
"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": [],
"largest_source_bytes": 178927,
"source_files_sampled": 56,
"oversized_source_files": 9,
"agent_instruction_files": [],
"agent_instruction_max_bytes": null
},
"dependencies": {
"manifests": [
"composer.json"
],
"advisories": {
"error": "No resolved dependencies to assess",
"scope": "repository_graph",
"source": null,
"findings": [],
"collected": false,
"malicious": [],
"truncated": false,
"by_severity": {},
"advisory_count": 0,
"affected_count": 0,
"assessed_count": 0,
"malicious_count": 0,
"assessed_package": null,
"unassessed_count": 0,
"direct_affected_count": 0
},
"ecosystems": [
"packagist"
],
"dependencies": [],
"all_dependencies": {
"error": null,
"source": "github-sbom",
"packages": [],
"collected": true,
"truncated": false,
"total_count": 0,
"direct_count": 0,
"indirect_count": 0
}
},
"maintainership": {
"issues": {
"open_prs": 0,
"merged_prs": 22,
"open_issues": 0,
"closed_ratio": 1,
"closed_issues": 21,
"closed_unmerged_prs": 7
},
"bus_factor": 2,
"bot_contributors": 0,
"top_contributors": [
{
"type": "User",
"login": "JanJakes",
"commits": 249,
"avatar_url": "https://avatars.githubusercontent.com/u/141436?v=4"
},
{
"type": "User",
"login": "aristath",
"commits": 190,
"avatar_url": "https://avatars.githubusercontent.com/u/588688?v=4"
},
{
"type": "User",
"login": "adamziel",
"commits": 100,
"avatar_url": "https://avatars.githubusercontent.com/u/205419?v=4"
},
{
"type": "User",
"login": "bgrgicak",
"commits": 33,
"avatar_url": "https://avatars.githubusercontent.com/u/1199991?v=4"
},
{
"type": "User",
"login": "OllieJones",
"commits": 17,
"avatar_url": "https://avatars.githubusercontent.com/u/9804013?v=4"
},
{
"type": "User",
"login": "wojtekn",
"commits": 8,
"avatar_url": "https://avatars.githubusercontent.com/u/727413?v=4"
},
{
"type": "User",
"login": "jeroenpf",
"commits": 6,
"avatar_url": "https://avatars.githubusercontent.com/u/10244734?v=4"
},
{
"type": "User",
"login": "swissspidy",
"commits": 6,
"avatar_url": "https://avatars.githubusercontent.com/u/841956?v=4"
},
{
"type": "User",
"login": "akirk",
"commits": 2,
"avatar_url": "https://avatars.githubusercontent.com/u/203408?v=4"
},
{
"type": "User",
"login": "kozer",
"commits": 2,
"avatar_url": "https://avatars.githubusercontent.com/u/497103?v=4"
}
],
"contributors_sampled": 19,
"top_contributor_share": 0.4
},
"quality_signals": {
"has_ci": true,
"has_tests": true,
"ci_workflows": [
"cs.yml",
"phpunit-tests-run.yml",
"phpunit-tests.yml",
"verify-version.yml",
"wp-tests-phpunit.yml"
],
"has_docs_dir": false,
"linter_configs": [],
"has_editorconfig": true,
"has_linter_config": false,
"has_precommit_config": false
},
"security_signals": {
"lockfiles": [],
"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 7 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": 8,
"reason": "Found 7/8 approved changesets -- score normalized to 8",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#code-review"
},
{
"name": "Contributors",
"score": 10,
"reason": "project has 8 contributing companies or organizations",
"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": "project is archived",
"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": 10,
"reason": "0 existing vulnerabilities detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#vulnerabilities"
}
],
"commit": "a7918e8cf4684894aa4a5a1c63e4c9ac66c54355",
"ran_at": "2026-07-25T08:58:05Z",
"aggregate_score": 3.7,
"scorecard_version": "v5.5.0"
},
"has_codeql_workflow": false,
"has_security_policy": false,
"has_dependabot_config": false
},
"contribution_flow": {
"collected": true,
"ci_last_run_at": null,
"oldest_open_prs": [],
"last_merged_pr_at": "2025-05-30T13:00:17Z",
"ci_last_conclusion": null,
"oldest_open_issues": []
}
},
"config": {
"disabled_metrics": [],
"disabled_categories": [],
"disabled_components": {}
},
"source": {
"url": "https://github.com/Automattic/sqlite-database-integration",
"host": "github.com",
"name": "sqlite-database-integration",
"owner": "Automattic"
},
"metrics": {
"overall": {
"key": "overall",
"band": "critical",
"name": "Overall health",
"note": "Abandonment Policy applies a 40% multiplier to weighted overall health and gives it a ceiling of 29.",
"notes": [
{
"code": "abandonment_overall_adjustment",
"params": {
"cap": 29,
"pct": 40
}
}
],
"value": 18,
"inputs": {
"security": 37,
"vitality": 28,
"community": 28,
"governance": 76,
"engineering": 52,
"abandonment_cap": 29,
"abandonment_state": "declared",
"abandonment_multiplier": 40,
"weighted_overall_before_abandonment": 46,
"overall_after_abandonment_multiplier": 18
},
"components": []
},
"categories": [
{
"key": "vitality",
"band": "critical",
"name": "Vitality",
"value": 28,
"weight": 0.22,
"metrics": [
{
"key": "development_activity",
"band": "critical",
"name": "Development activity",
"note": null,
"notes": [],
"value": 1,
"inputs": {
"commits_last_year": 0,
"human_commit_share": 1,
"days_since_last_push": 417,
"active_weeks_last_year": 0
},
"components": [
{
"key": "push_recency",
"name": "Push recency",
"detail": "last push 417 days ago",
"points": 0,
"status": "missed",
"details": [
{
"code": "push_recency",
"params": {
"days": 417
}
}
],
"max_points": 36
},
{
"key": "commit_cadence",
"name": "Commit cadence",
"detail": "0/52 weeks with commits",
"points": 0,
"status": "missed",
"details": [
{
"code": "commit_cadence_weeks",
"params": {
"weeks": 0
}
}
],
"max_points": 36
},
{
"key": "commit_volume",
"name": "Commit volume",
"detail": "0 commits in the last year",
"points": 0,
"status": "missed",
"details": [
{
"code": "commits_last_year",
"params": {
"count": 0
}
}
],
"max_points": 18
},
{
"key": "openssf_scorecard_maintained",
"name": "OpenSSF Scorecard: Maintained",
"detail": "project is archived",
"points": 0,
"status": "missed",
"details": [],
"max_points": 10
}
]
},
{
"key": "release_discipline",
"band": "moderate",
"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": 68,
"inputs": {
"releases_count": 2,
"latest_release_tag": "v2.1.17-alpha.1",
"releases_from_tags": false,
"days_since_latest_release": 481,
"mean_days_between_releases": 39.1
},
"components": [
{
"key": "ships_releases",
"name": "Ships releases",
"detail": "2 releases published",
"points": 27,
"status": "met",
"details": [
{
"code": "releases_published",
"params": {
"count": 2
}
}
],
"max_points": 27
},
{
"key": "release_recency",
"name": "Release recency",
"detail": "latest release 481 days ago",
"points": 7.2,
"status": "partial",
"details": [
{
"code": "release_recency",
"params": {
"days": 481
}
}
],
"max_points": 36
},
{
"key": "release_cadence",
"name": "Release cadence",
"detail": "a release every ~39.1 days",
"points": 27,
"status": "met",
"details": [
{
"code": "release_cadence",
"params": {
"gap": 39.1
}
}
],
"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": "at_risk",
"name": "Abandonment",
"note": null,
"notes": [],
"value": 40,
"inputs": {
"cap": 29,
"state": "declared",
"guards": [],
"signals": [],
"red_flag": true,
"multiplier_pct": 40,
"declared_reason": "archived",
"unverified_reason": null,
"unanswered_open_prs": null,
"unanswered_open_issues": null,
"days_since_last_merged_pr": null,
"days_since_last_human_commit": null,
"days_since_last_human_commit_is_floor": false
},
"components": [
{
"key": "project_is_still_maintained",
"name": "Project is still maintained",
"detail": "the repository is archived on GitHub",
"points": 40,
"status": "partial",
"details": [
{
"code": "abandonment_archived",
"params": {}
}
],
"max_points": 100
}
]
}
],
"description": "Is the project alive — is code being written and are releases shipping?"
},
{
"key": "community",
"band": "critical",
"name": "Community & Adoption",
"value": 28,
"weight": 0.18,
"metrics": [
{
"key": "popularity",
"band": "critical",
"name": "Popularity & adoption",
"note": null,
"notes": [],
"value": 9,
"inputs": {
"forks": 3,
"stars": 3,
"watchers": 3,
"growth_state": "unverified",
"growth_factor_pct": 100,
"growth_unverified_reason": "no_history"
},
"components": [
{
"key": "stars",
"name": "Stars",
"detail": "3 stars",
"points": 4.9,
"status": "partial",
"details": [
{
"code": "stars",
"params": {
"count": 3
}
}
],
"max_points": 60
},
{
"key": "forks",
"name": "Forks",
"detail": "3 forks",
"points": 2.5,
"status": "partial",
"details": [
{
"code": "forks",
"params": {
"count": 3
}
}
],
"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 (GPL-2.0)",
"points": 22.5,
"status": "met",
"details": [
{
"code": "license_standard",
"params": {}
},
{
"code": "license_spdx",
"params": {
"spdx": "GPL-2.0"
}
}
],
"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": "good",
"name": "Sustainability & Governance",
"value": 76,
"weight": 0.24,
"metrics": [
{
"key": "maintainer_resilience",
"band": "moderate",
"name": "Maintainer resilience (bus factor)",
"note": null,
"notes": [],
"value": 62,
"inputs": {
"bus_factor": 2,
"contributors_sampled": 19,
"top_contributor_share": 0.4
},
"components": [
{
"key": "bus_factor",
"name": "Bus factor",
"detail": "2 contributor(s) cover half of all commits",
"points": 25.2,
"status": "partial",
"details": [
{
"code": "bus_factor",
"params": {
"count": 2
}
}
],
"max_points": 54
},
{
"key": "commit_distribution",
"name": "Commit distribution",
"detail": "top contributor authored 40% of commits",
"points": 13.5,
"status": "partial",
"details": [
{
"code": "top_contributor_share",
"params": {
"share": 40
}
}
],
"max_points": 22.5
},
{
"key": "contributor_breadth",
"name": "Contributor breadth",
"detail": "19 contributors",
"points": 13.5,
"status": "met",
"details": [
{
"code": "contributors_sampled",
"params": {
"count": 19
}
}
],
"max_points": 13.5
},
{
"key": "openssf_scorecard_contributors",
"name": "OpenSSF Scorecard: Contributors",
"detail": "project has 8 contributing companies or organizations",
"points": 10,
"status": "met",
"details": [],
"max_points": 10
}
]
},
{
"key": "responsiveness",
"band": "excellent",
"name": "Issue & PR responsiveness",
"note": null,
"notes": [],
"value": 88,
"inputs": {
"merged_prs": 22,
"open_issues": 0,
"closed_issues": 21,
"issue_closed_ratio": 1,
"closed_unmerged_prs": 7
},
"components": [
{
"key": "issue_resolution",
"name": "Issue resolution",
"detail": "100% of issues closed",
"points": 46.8,
"status": "met",
"details": [
{
"code": "issues_closed_share",
"params": {
"share": 100
}
}
],
"max_points": 46.75
},
{
"key": "pr_acceptance",
"name": "PR acceptance",
"detail": "22/29 decided PRs merged",
"points": 29,
"status": "partial",
"details": [
{
"code": "decided_prs_merged",
"params": {
"merged": 22,
"decided": 29
}
}
],
"max_points": 38.25
},
{
"key": "openssf_scorecard_code_review",
"name": "OpenSSF Scorecard: Code-Review",
"detail": "Found 7/8 approved changesets -- score normalized to 8",
"points": 12,
"status": "partial",
"details": [],
"max_points": 15
}
]
},
{
"key": "stewardship",
"band": "good",
"name": "Ownership & stewardship",
"note": null,
"notes": [],
"value": 80,
"inputs": {
"followers": 3236,
"owner_type": "Organization",
"is_verified": null,
"owner_login": "Automattic",
"public_repos": 1376,
"account_age_days": 5503
},
"components": [
{
"key": "ownership_backing",
"name": "Ownership backing",
"detail": "organization-owned",
"points": 30,
"status": "met",
"details": [
{
"code": "owner_organization",
"params": {}
}
],
"max_points": 30
},
{
"key": "verified_domain",
"name": "Verified domain",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 20
},
{
"key": "owner_reach",
"name": "Owner reach",
"detail": "3,236 followers of Automattic",
"points": 25,
"status": "met",
"details": [
{
"code": "owner_followers",
"params": {
"count": 3236,
"login": "Automattic"
}
}
],
"max_points": 25
},
{
"key": "track_record",
"name": "Track record",
"detail": "1376 public repos, account ~15 yr old",
"points": 25,
"status": "met",
"details": [
{
"code": "public_repos",
"params": {
"count": 1376
}
},
{
"code": "account_age_years",
"params": {
"years": 15
}
}
],
"max_points": 25
}
]
}
],
"description": "Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep?"
},
{
"key": "engineering",
"band": "moderate",
"name": "Engineering Quality",
"value": 52,
"weight": 0.2,
"metrics": [
{
"key": "engineering_practices",
"band": "moderate",
"name": "Engineering practices",
"note": null,
"notes": [],
"value": 54,
"inputs": {
"has_ci": true,
"has_tests": true,
"has_editorconfig": true,
"has_linter_config": false,
"has_precommit_config": false
},
"components": [
{
"key": "ci_workflows",
"name": "CI workflows",
"detail": "5 workflow(s)",
"points": 24,
"status": "met",
"details": [
{
"code": "ci_workflows",
"params": {
"count": 5
}
}
],
"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": null,
"points": 0,
"status": "missed",
"details": [],
"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": 6.4,
"status": "met",
"details": [],
"max_points": 6.4
},
{
"key": "openssf_scorecard_ci_tests",
"name": "OpenSSF Scorecard: CI-Tests",
"detail": "0 out of 7 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": [],
"has_wiki": true,
"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": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 10
},
{
"key": "wiki",
"name": "Wiki",
"detail": null,
"points": 10,
"status": "met",
"details": [],
"max_points": 10
}
]
}
],
"description": "Are baseline engineering and documentation practices in place?"
},
{
"key": "security",
"band": "at_risk",
"name": "Security",
"value": 37,
"weight": 0.16,
"metrics": [
{
"key": "security_posture",
"band": "at_risk",
"name": "Security posture",
"note": "Excluded from scoring (no data or not applicable): Dangerous-Workflow, Packaging, Pinned-Dependencies, Signed-Releases, Token-Permissions. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"dangerous_workflow",
"packaging",
"pinned_dependencies",
"signed_releases",
"token_permissions"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 37,
"inputs": {
"source": "openssf_scorecard",
"checks_evaluated": 13,
"scorecard_version": "v5.5.0",
"checks_inconclusive": 5,
"scorecard_aggregate": 3.7
},
"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 7 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 7/8 approved changesets -- score normalized to 8",
"points": 6,
"status": "partial",
"details": [],
"max_points": 7.5
},
{
"key": "contributors",
"name": "Contributors",
"detail": "project has 8 contributing companies or organizations",
"points": 2.5,
"status": "met",
"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": "project is archived",
"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": "0 existing vulnerabilities detected",
"points": 7.5,
"status": "met",
"details": [],
"max_points": 7.5
}
]
},
{
"key": "high_risk_jurisdiction_exposure",
"band": "excellent",
"name": "High-Risk Jurisdiction Exposure",
"note": "Only high-confidence self-published location evidence affects this multiplier. Ambiguous matches are review-only; country evidence is not proof of nationality, citizenship, legal registration, malicious intent, or sanctions status.",
"notes": [
{
"code": "jurisdiction_evidence_limits",
"params": {}
}
],
"value": 100,
"inputs": {
"meaning": "self-published location evidence; not nationality or citizenship",
"red_flag": false,
"exposures": [],
"policy_countries": [
"Russia",
"Iran",
"North Korea"
],
"review_only_matches": 0,
"assessed_self_published_locations": 12
},
"components": [
{
"key": "policy_exposure_multiplier",
"name": "Policy exposure multiplier",
"detail": "no confirmed policy-scope location match",
"points": 100,
"status": "met",
"details": [
{
"code": "jurisdiction_no_match",
"params": {}
}
],
"max_points": 100
}
]
}
],
"description": "Are visible security and supply-chain practices strong, with no malicious dependency and no unresolved high-risk jurisdiction exposure?"
},
{
"key": "ai_readiness",
"band": "critical",
"name": "AI Readiness",
"value": 23,
"weight": 0,
"metrics": [
{
"key": "ai_agent_context",
"band": "critical",
"name": "Agent context & guidance",
"note": null,
"notes": [],
"value": 9,
"inputs": {
"has_llms_txt": false,
"legible_history_share": 0.17,
"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": "17 of 100 human commits state their intent (structured subject or explanatory body)",
"points": 9.1,
"status": "partial",
"details": [
{
"code": "legible_history",
"params": {
"legible": 17,
"sampled": 100
}
}
],
"max_points": 40
}
]
},
{
"key": "ai_verify_loop",
"band": "critical",
"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": 24,
"inputs": {
"has_nix": false,
"has_tests": true,
"lockfiles": [],
"has_dockerfile": false,
"typed_language": false,
"bootstrap_files": [],
"has_devcontainer": false,
"has_linter_config": false,
"typecheck_configs": [],
"agent_commit_share": 0,
"toolchain_manifests": [],
"dependency_bot_commit_share": 0
},
"components": [
{
"key": "one_command_bootstrap",
"name": "One-command bootstrap",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"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": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 11
},
{
"key": "static_type_checking",
"name": "Static type checking",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 11
},
{
"key": "reproducible_environment",
"name": "Reproducible environment",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"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": "at_risk",
"name": "Code legibility for models",
"note": null,
"notes": [],
"value": 46,
"inputs": {
"primary_language": "PHP",
"largest_source_bytes": 178927,
"source_files_sampled": 56,
"oversized_source_files": 9
},
"components": [
{
"key": "type_checkable_code",
"name": "Type-checkable code",
"detail": "PHP without a type-check config",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_typecheck_config_language",
"params": {
"language": "PHP"
}
}
],
"max_points": 45
},
{
"key": "manageable_file_sizes",
"name": "Manageable file sizes",
"detail": "9/56 source files over 60KB",
"points": 46.2,
"status": "partial",
"details": [
{
"code": "oversized_source_files",
"params": {
"kb": 60,
"sampled": 56,
"oversized": 9
}
}
],
"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",
"Could not fetch packagist package 'wordpress/sqlite-database-integration' from its registry"
],
"report_type": "repository",
"generated_at": "2026-07-25T08:58:28.540949Z",
"schema_version": "0.27.0",
"badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/a/Automattic/sqlite-database-integration.svg",
"full_name": "Automattic/sqlite-database-integration",
"license_state": "standard",
"license_spdx": "GPL-2.0"
}Оцінки — це сигнали, а не гарантії. Вони відображають публічно видимі практики на GitHub — це не аудит коду й не гарантія безпеки.
Відсутні дані виключаються, а ваги перенормовуються — нуль за відсутність ніколи не ставиться. Методологія версіонована й відкрита: метрики v1.13.0, схема v0.27.0 — повна методологія · вікі метрик.
Як окремий результат виглядає на тлі всього реєстру: сукупна статистика.