Öffentliches RegisterMittel
Software-GesundheitsberichtSchema 0.26.0 · Metriken 1.13.0 · 2026-07-22 17:44 UTC
iamcal / SQLParser
Parse MySQL schemas in PHP, fast
iamcal/SQLParser erreicht einen Gesundheitsindex von 50 von 100 und liegt damit im Bereich Mittel. Am stärksten schneidet es bei Sustainability & Governance (68/100) ab, am schwächsten bei Security (30/100). Zuletzt vor 174 Tagen aktualisiert. Ein einzelner Mitwirkender trägt den Großteil der jüngsten Arbeit.
50
gesamt / 100Software-Gesundheitsindex
Metriken werden auf einer Skala von 1–100 in gewichtete Kategorien gruppiert. Der Gesamtwert beginnt als ihr Mittel; sobald öffentliche Evidenz die Richtlinie für Hochrisikojurisdiktionen auslöst, wird die Bewertung angepasst und erhält die Obergrenze 49 (Gefährdet). AI Readiness liegt außerhalb.
50
Exzellent85-100Vorbildlich; erfüllt im Wesentlichen alle geprüften Kriterien
Gut70-84Gesund; geringfügige Lücken
Mittel50-69Akzeptabel mit deutlichen Lücken; Überprüfung empfohlen
Gefährdet30-49Erhebliche Schwächen; eine Übernahme erfordert Vorsicht
Kritisch1-29Schwerwiegende Probleme (aufgegeben, nur ein Maintainer, keine Hygiene)
Bewertungsprofil
Jede Achse ist eine Kategorie. Die Form zählt mehr als der Durchschnitt — ein gesundes Projekt füllt die gesamte Fläche, während ein Profil aus Spitzen und Kratern bedeutet, dass Stärke in einer Dimension Risiken in einer anderen verdeckt.
Eigentümerschaft
Cal HendersonPersönliches Konto
1.025 Follower193 öffentliche Reposseit Dez. 2009Slack
Dieses Repository gehört einem persönlichen Konto. Ein Projekt mit nur einem Eigentümer trägt ein höheres Kontinuitätsrisiko als ein organisationsgetragenes.
Paket-Ökosysteme
| Registry | Paket | Version | Downloads / Monat | Versionen | Zuletzt veröffentlicht |
|---|---|---|---|---|---|
| Packagist | iamcal/sql-parser | v0.7 | 4.742.890 | 7 | vor 174 Tagen |
Metriken nach Kategorie
Vitalität
Lebt das Projekt — wird Code geschrieben und werden Releases ausgeliefert?
37
Entwicklungsaktivität
18Kritisch
Wie die Bewertung erfolgt
| 9.9/36 | Push-Aktualität — letzter Push vor 174 Tagen |
| 0.7/36 | Commit-Rhythmus — 1/52 Wochen mit Commits |
| 7.6/18 | Commit-Volumen — 6 Commits im letzten Jahr |
| 0/10 | OpenSSF Scorecard: Maintained — 0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0 |
Verwendete Eingangsdaten
| commits_last_year | 6 |
| human_commit_share | 1 |
| days_since_last_push | 174 |
| active_weeks_last_year | 1 |
Release-Disziplin
66Mittel
Wie die Bewertung erfolgt
| 27/27 | Liefert Releases aus — 2 Releases veröffentlicht |
| 27/36 | Release-Aktualität — letztes Release vor 174 Tagen |
| 5.4/27 | Release-Rhythmus — ein Release etwa alle 3.062,7 Tage |
| 0/10 | OpenSSF Scorecard: Signed-Releases — keine Daten |
Verwendete Eingangsdaten
| releases_count | 2 |
| latest_release_tag | v0.7 |
| releases_from_tags | nein |
| days_since_latest_release | 174 |
| mean_days_between_releases | 3.062,7 |
Von der Bewertung ausgeschlossen (keine Daten oder nicht anwendbar): OpenSSF Scorecard: Signed-Releases. Die verbleibenden Gewichte wurden renormalisiert.
Community & Verbreitung
Hat das Projekt Nutzer, Downloads, Aufmerksamkeit und ein einladendes Umfeld für Beitragende?
56
Popularität & Verbreitung
43Gefährdet
Wie die Bewertung erfolgt
| 30.5/60 | Stars — 77 Stars |
| 10.7/25 | Forks — 20 Forks |
| 1.7/15 | Watcher — 3 Watcher |
Verwendete Eingangsdaten
| forks | 20 |
| stars | 77 |
| watchers | 3 |
| growth_state | unverified |
| growth_factor_pct | 100 |
| growth_unverified_reason | no_history |
Community-Gesundheit
50Mittel
Wie die Bewertung erfolgt
| 22.5/22.5 | README |
| 22.5/22.5 | Lizenz — anerkannte Lizenz (MIT) |
| 0/18 | CONTRIBUTING-Leitfaden |
| 0/13.5 | Verhaltenskodex |
| 0/7.2 | Issue-Vorlage |
| 0/6.3 | PR-Vorlage |
Verwendete Eingangsdaten
| has_readme | ja |
| has_license | ja |
| has_contributing | nein |
| has_issue_template | nein |
| has_code_of_conduct | nein |
| has_pull_request_template | nein |
Ökosystem-Verbreitung (Downloads)
87Exzellent
Wie die Bewertung erfolgt
| 80/80 | Downloads pro Monat — 4.742.890 Downloads/Monat über packagist |
| 6.9/20 | Abhängige in der Registry — 10 Pakete hängen davon ab |
Verwendete Eingangsdaten
| packages | iamcal/sql-parser |
| dependents | 10 |
| ecosystems | packagist |
| total_downloads | 38.486.535 |
| monthly_downloads | 4.742.890 |
Nachhaltigkeit & Governance
Überdauert das Projekt die Menschen, die es tragen — Bus-Faktor, Reaktionsfähigkeit, Trägerschaft und Paketpflege?
68
Maintainer-Resilienz (Bus-Faktor)
29Kritisch
Wie die Bewertung erfolgt
| 9/54 | Bus-Faktor — 1 Beitragende decken die Hälfte aller Commits ab |
| 2.9/22.5 | Commit-Verteilung — wichtigste beitragende Person verfasste 87 % der Commits |
| 10.8/13.5 | Breite der Beitragenden — 8 Beitragende |
| 6/10 | OpenSSF Scorecard: Contributors — project has 2 contributing companies or organizations -- score normalized to 6 |
Verwendete Eingangsdaten
| bus_factor | 1 |
| contributors_sampled | 8 |
| top_contributor_share | 0,872 |
Reaktionsfähigkeit bei Issues & PRs
86Exzellent
Wie die Bewertung erfolgt
| 46.8/46.8 | Issue-Lösungsquote — 100 % der Issues geschlossen |
| 34.9/38.3 | PR-Annahme — 21/23 entschiedene PRs gemergt |
| 4.5/15 | OpenSSF Scorecard: Code-Review — Found 8/22 approved changesets -- score normalized to 3 |
Verwendete Eingangsdaten
| merged_prs | 21 |
| open_issues | 0 |
| closed_issues | 8 |
| issue_closed_ratio | 1 |
| closed_unmerged_prs | 2 |
Wie die Bewertung erfolgt
| 10/30 | Organisatorische Trägerschaft — persönliches (Nutzer-)Konto |
| 0/20 | Verifizierte Domain — für Nutzerkonten nicht anwendbar |
| 21.6/25 | Reichweite des Inhabers — 1.025 Follower von iamcal |
| 25/25 | Kontohistorie — 193 öffentliche Repos, Kontoalter ca. 16 Jahre |
Verwendete Eingangsdaten
| followers | 1.025 |
| owner_type | User |
| is_verified | — |
| owner_login | iamcal |
| public_repos | 193 |
| account_age_days | 6.048 |
Von der Bewertung ausgeschlossen (keine Daten oder nicht anwendbar): Verifizierte Domain. Die verbleibenden Gewichte wurden renormalisiert.
Paketpflege
100Exzellent
Wie die Bewertung erfolgt
| 25/25 | Veröffentlicht & auflösbar — 1 Paket(e) auf packagist |
| 35/35 | Veröffentlichungsaktualität — letzte Veröffentlichung vor 174 Tagen |
| 20/20 | Versionshistorie — 7 veröffentlichte Versionen |
| 20/20 | Nicht veraltet — aktiv, nicht veraltet oder zurückgezogen |
Verwendete Eingangsdaten
| packages | iamcal/sql-parser |
| ecosystems | packagist |
| any_deprecated | nein |
| min_days_since_publish | 174 |
Engineering-Qualität
Sind grundlegende Engineering- und Dokumentationspraktiken vorhanden?
53
Engineering-Praktiken
48Gefährdet
Wie die Bewertung erfolgt
| 24/24 | CI-Workflows — 1 Workflow(s) |
| 24/24 | Tests vorhanden |
| 0/16 | Linter-Konfiguration |
| 0/9.6 | Pre-Commit-Hooks |
| 0/6.4 | .editorconfig |
| 0/20 | OpenSSF Scorecard: CI-Tests — 1 out of 16 merged PRs checked by a CI test -- score normalized to 0 |
Verwendete Eingangsdaten
| has_ci | ja |
| has_tests | ja |
| has_editorconfig | nein |
| has_linter_config | nein |
| has_precommit_config | nein |
Dokumentation
60Mittel
Wie die Bewertung erfolgt
| 30/30 | README |
| 0/25 | Dokumentationsverzeichnis |
| 0/15 | Dokumentations-/Homepage-Site |
| 10/10 | Repository-Beschreibung |
| 10/10 | Topics — 6 Topics |
| 10/10 | Wiki |
Verwendete Eingangsdaten
| topics | php, sql-parser, lex, composer, database, autoloader |
| has_wiki | ja |
| homepage | — |
| has_readme | ja |
| has_docs_dir | nein |
| has_description | ja |
Sicherheit
Sind die sichtbaren Sicherheits- und Lieferkettenpraktiken belastbar, ohne ungeklärte Exposition gegenüber Hochrisikojurisdiktionen?
30
Sicherheitslage
30Gefährdet
Wie die Bewertung erfolgt
| 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 — 1 out of 16 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 |
| 2.2/7.5 | Code-Review — Found 8/22 approved changesets -- score normalized to 3 |
| 1.5/2.5 | Contributors — project has 2 contributing companies or organizations -- score normalized to 6 |
| 0/10 | Dangerous-Workflow — keine Daten |
| 0/7.5 | Dependency-Update-Tool — no update tool detected |
| 0/5 | Fuzzing — project is not fuzzed |
| 2.5/2.5 | Lizenz — license file detected |
| 0/7.5 | Maintained — 0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0 |
| 0/5 | Packaging — keine Daten |
| 0/5 | Pinned-Dependencies — keine Daten |
| 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 — keine Daten |
| 0/7.5 | Token-Permissions — keine Daten |
| 7.5/7.5 | Vulnerabilities — 0 existing vulnerabilities detected |
Verwendete Eingangsdaten
| source | openssf_scorecard |
| checks_evaluated | 13 |
| scorecard_version | v5.5.0 |
| checks_inconclusive | 5 |
| scorecard_aggregate | 3 |
Von der Bewertung ausgeschlossen (keine Daten oder nicht anwendbar): dangerous_workflow, packaging, pinned_dependencies, signed_releases, token_permissions. Die verbleibenden Gewichte wurden renormalisiert.
AI Readiness
Wie gut ist das Repository dafür ausgestattet, mit KI-Coding-Agenten entwickelt und gepflegt zu werden? Ein unabhängiges, experimentelles Badge — Gewicht 0,0, es wird eigenständig ausgewiesen und verändert den Gesamt-Gesundheitswert nicht.
33
AI-Agentenkontext & Leitlinien
6Kritisch
Wie die Bewertung erfolgt
| 0/45 | Agentenanweisungen — keine CLAUDE.md / AGENTS.md / Editor-Regeln |
| 0/15 | Maschinenlesbare Doku (llms.txt) |
| 6.4/40 | Lesbare Commit-Historie — 12 von 100 menschlichen Commits benennen ihre Absicht (strukturierter Betreff oder erläuternder Text) |
Verwendete Eingangsdaten
| has_llms_txt | nein |
| legible_history_share | 0,12 |
| agent_instruction_files | — |
| agent_instruction_max_bytes | — |
AI-Verify-Loop (Build / Test / Typprüfung)
44Gefährdet
Wie die Bewertung erfolgt
| 18/18 | Bootstrap mit einem Befehl — Makefile |
| 22/22 | Automatisierte Tests |
| 0/11 | Lint-/Format-Konfiguration |
| 0/11 | Statische Typprüfung |
| 0/10 | Reproduzierbare Umgebung |
| 0/10 | Belegte Agentenpraxis — keine von Agenten verfassten Commits unter den letzten 100 |
| 0/8 | Automatisierte Wartung — keine automatisierten Abhängigkeits-Updates beobachtet |
| 0/10 | OpenSSF Scorecard: Pinned-Dependencies — keine Daten |
Verwendete Eingangsdaten
| has_nix | nein |
| has_tests | ja |
| lockfiles | — |
| has_dockerfile | nein |
| typed_language | nein |
| bootstrap_files | Makefile |
| has_devcontainer | nein |
| has_linter_config | nein |
| typecheck_configs | — |
| agent_commit_share | 0 |
| toolchain_manifests | — |
| dependency_bot_commit_share | 0 |
Von der Bewertung ausgeschlossen (keine Daten oder nicht anwendbar): OpenSSF Scorecard: Pinned-Dependencies. Die verbleibenden Gewichte wurden renormalisiert.
AI-Code-Lesbarkeit für Modelle
55Mittel
Wie die Bewertung erfolgt
| 0/45 | Typprüfbarer Code — PHP ohne Typprüfungs-Konfiguration |
| 55/55 | Handhabbare Dateigrößen — 0/12 Quelldateien über 60 KB |
Verwendete Eingangsdaten
| primary_language | PHP |
| largest_source_bytes | 27.313 |
| source_files_sampled | 12 |
| oversized_source_files | 0 |
Eckdaten
77GitHub-Sterne
8Mitwirkende
6Commits, letzte 12 Monate
174Tage seit letztem Push
2Releases
1Bus-Faktor
0offene Issues
PackagistPaket-Ökosysteme
Warnungen zur Datenerhebung
- Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token
- No resolved dependencies carried a version and a supported ecosystem
Weitere Details
Stern- und Fork-Verlauf 0 ★ / 20 ⇿
0Sterne
20Forks
1Releases
Wann jeder Stern und Fork hinzugefügt wurde, von GitHub erfasst und nach Tagen gruppiert. Das kumulierte Wachstum steht direkt über den täglichen Zugängen, aus denen es besteht, sodass beide gegeneinander lesbar sind: stetiger organischer Zuwachs sieht ganz anders aus als ein abrupter, kurzlebiger Ausschlag. Wo dieser Unterschied messbar ist, wird er als Wachstumsauthentizität ausgewiesen.
Major 0Minor 0Patch 0
Jeder Punkt umfasst 9 Tage.
OpenSSF Scorecard 3.0 / 10
3.0Gesamtwert
Unabhängige, werkzeugneutrale Sicherheitsbewertung durch das quelloffene OpenSSF Scorecard. Jede Prüfung honoriert eine Sicherheits-Praxis, nicht das Werkzeug eines bestimmten Anbieters. Prüfungen, die Scorecard nicht ermitteln konnte, sind mit k. A. markiert und vom Sicherheitswert ausgeschlossen (nie als null gezählt).
| 10 | Binary-Artifacts | no binaries found in the repo |
| 0 | Branch-Protection | branch protection not enabled on development/release branches |
| 0 | CI-Tests | 1 out of 16 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 |
| 3 | Code-Review | Found 8/22 approved changesets -- score normalized to 3 |
| 6 | Contributors | project has 2 contributing companies or organizations -- score normalized to 6 |
| k. A. | 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 | 0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0 |
| k. A. | Packaging | packaging workflow not detected |
| k. A. | 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 |
| k. A. | Signed-Releases | no releases found |
| k. A. | Token-Permissions | No tokens found |
| 10 | Vulnerabilities | 0 existing vulnerabilities detected |
Alle Abhängigkeiten 2
Vollständig aufgelöster Abhängigkeitssatz aus dem GitHub-Abhängigkeitsgraphen: 0 direkte und 2 indirekte (transitive) Pakete. Die transitive Hülle ist vollständig, wenn das Repository eine Lockfile eincheckt.
| Registry | Paket | Version | Beziehung |
|---|---|---|---|
| Packagist | php-coveralls/php-coveralls | — | indirekt |
| Packagist | phpunit/phpunit | — | indirekt |
Abhängigkeits-Advisories nicht bewertet
Der Advisory-Abgleich konnte für diesen Bericht nicht ausgeführt werden: No resolved dependencies carried a version and a supported ecosystem
JSON-Rohbericht maschinenlesbar
{
"data": {
"repo": {
"topics": [
"php",
"sql-parser",
"lex",
"composer",
"database",
"autoloader"
],
"is_fork": false,
"size_kb": 183,
"has_wiki": true,
"homepage": null,
"languages": {
"PHP": 66319,
"Makefile": 73
},
"pushed_at": "2026-01-28T22:23:25Z",
"created_at": "2013-01-04T23:49:17Z",
"owner_type": "User",
"updated_at": "2026-05-28T19:50:24Z",
"description": "Parse MySQL schemas in PHP, fast",
"is_archived": false,
"is_disabled": false,
"license_spdx": "MIT",
"default_branch": "master",
"license_spdx_raw": "MIT",
"primary_language": "PHP",
"significant_languages": [
"PHP"
]
},
"owner": {
"blog": "http://www.iamcal.com/",
"name": "Cal Henderson",
"type": "User",
"login": "iamcal",
"company": "Slack",
"location": "San Francisco, CA",
"followers": 1025,
"avatar_url": "https://avatars.githubusercontent.com/u/173750?v=4",
"created_at": "2009-12-29T17:57:48Z",
"is_verified": null,
"public_repos": 193,
"account_age_days": 6048
},
"license": {
"state": "standard",
"spdx_id": "MIT",
"raw_spdx": "MIT",
"file_present": true,
"scorecard_found": true,
"profile_has_license": true
},
"activity": {
"releases": [
{
"tag": "v0.7",
"kind": "other",
"published_at": "2026-01-28T22:23:25Z"
},
{
"tag": "0.1",
"kind": "other",
"published_at": "2017-09-10T05:04:30Z"
}
],
"recent_commits": [
{
"oid": "610392f38de49a44dab08dc1659960a29874c4b8",
"body": null,
"is_bot": false,
"headline": "Fix quote doubling decoding",
"author_name": "Yuta Nagamiya",
"author_login": "ngmy",
"committed_at": "2026-01-28T22:20:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "47edc41c929b33266e3affc151281f0361667c99",
"body": null,
"is_bot": false,
"headline": "Add tests for quote doubling decoding",
"author_name": "Yuta Nagamiya",
"author_login": "ngmy",
"committed_at": "2026-01-28T22:20:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "02f623f2f3f425d5c9bbef342a3d17db2dc1aebf",
"body": null,
"is_bot": false,
"headline": "Fix quote doubling lexing",
"author_name": "Yuta Nagamiya",
"author_login": "ngmy",
"committed_at": "2026-01-28T22:20:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ec94c056723d37bfeb14316b0f29b8b67373e0a5",
"body": null,
"is_bot": false,
"headline": "Add tests for quote doubling lexing",
"author_name": "Yuta Nagamiya",
"author_login": "ngmy",
"committed_at": "2026-01-28T22:20:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a8106d8925cb33792819e1ebbdfb2dbfcc4fbcee",
"body": null,
"is_bot": false,
"headline": "Fix escaped quote decoding",
"author_name": "Yuta Nagamiya",
"author_login": "ngmy",
"committed_at": "2026-01-28T22:20:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a831815c183aa572f0a9743a50e723fe869aa8cf",
"body": null,
"is_bot": false,
"headline": "Add tests for escaped quote decoding",
"author_name": "Yuta Nagamiya",
"author_login": "ngmy",
"committed_at": "2026-01-28T22:20:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "947083e2dca211a6f12fb1beb67a01e387de9b62",
"body": null,
"is_bot": false,
"headline": "feat: add `.gitattributes`",
"author_name": "Owen Voke",
"author_login": "owenvoke",
"committed_at": "2025-03-17T16:59:46Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0262cfb8bc1d04e91b8f927e7105037c440e4ccc",
"body": null,
"is_bot": false,
"headline": "throw exception instead of die",
"author_name": "DirtyRacer1337",
"author_login": "DirtyRacer1337",
"committed_at": "2025-03-16T16:28:39Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "52f3c952969148d6d25073911e6c369dbdf51cc0",
"body": null,
"is_bot": false,
"headline": "Merge branch 'zzycad-master'",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2024-12-13T18:47:48Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a670a900cae83cd9f019711aa7e8d296235fcb5a",
"body": null,
"is_bot": false,
"headline": "added tests for field comments",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2024-12-13T18:46:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7308b62557ffd8662f36904f8e059238d38ef1f3",
"body": "…ers too)",
"is_bot": false,
"headline": "added test for negative default values (generally tests negative numb…",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2024-12-13T18:44:47Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "37f43534dbffd77281f8f876aef6e69a784c3f54",
"body": "…le field comments.",
"is_bot": false,
"headline": "Fix the bug with default negative values, and add the ability to hand…",
"author_name": "zzy",
"author_login": null,
"committed_at": "2024-12-13T09:32:32Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "644fd994de3b54e5d833aecf406150aa3b66ca88",
"body": "Start testing there...",
"is_bot": false,
"headline": "PHP 8.3 support",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2024-03-22T22:46:32Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a9f3f74d1d390665868b64404cbe7faaed558f8c",
"body": null,
"is_bot": false,
"headline": "supports [5.6,...,8.2]",
"author_name": "Rodolfo Berrios",
"author_login": "rodber",
"committed_at": "2023-09-27T23:25:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "1fe57fa39d6de91fc7a2988a7d0c205becbcf341",
"body": null,
"is_bot": false,
"headline": "removed dynamic property",
"author_name": "Rodolfo Berrios",
"author_login": "rodber",
"committed_at": "2023-09-27T23:25:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3356bcd528aa98b8a8c3e655c17baadcdf1c9dcf",
"body": null,
"is_bot": false,
"headline": "add code blocks",
"author_name": "Rodolfo Berrios",
"author_login": "rodber",
"committed_at": "2023-09-27T23:25:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9b56b6b42006e167a8f37c2cc84cbbb08515dae7",
"body": null,
"is_bot": false,
"headline": "ignore cache, vendor, build",
"author_name": "Rodolfo Berrios",
"author_login": "rodber",
"committed_at": "2023-09-27T23:25:38Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2c5eb8b229d4937a16a1bd17c5e2b137ce3b4597",
"body": "* detect when we've reached the end of input when lexing an unterminated string\r\n* added a mode where we throw exceptions for invalid syntax\r\n* added tests for invalid syntax, in both default and exception mode\r\n* documented `$parser->throw_on_bad_syntax`\r\n* get tests running again on php 8.1 (broken by https://github.com/sebastianbergmann/phpunit/issues/4740)",
"is_bot": false,
"headline": "Throw on bad syntax (#23)",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2022-03-05T00:19:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4080544b2df11132eecdb57fbe91c07dbbe5bc41",
"body": null,
"is_bot": false,
"headline": "added an alernatives section to the readme",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2022-03-04T23:44:34Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5ae12b79b0192d84b8ebc29541c55703104064e6",
"body": null,
"is_bot": false,
"headline": "how to publish changes",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2022-03-04T23:40:58Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3ceec1bdb7c0cfe0c10afdd1493889a0f2a484d9",
"body": "* name the build sensibly\r\n* updated the badge images",
"is_bot": false,
"headline": "Show a build bade for Github Actions (#21)",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2021-05-04T19:39:42Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4f897e91f98cf0be4602822b2fd08197e47ffa40",
"body": "* JSON is a type with no params\r\n* spatial types are all param-less too\r\n* added some missing field type aliases\r\n* added boolean type (plus alias)\r\n* updated the list of \"unsupported\", to cover all the 5.7 field types i've found\r\n* normalize whitespace",
"is_bot": false,
"headline": "Full support for 5.7 field types (#16)",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2021-05-04T19:34:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "de2497155b098a23ae58a56aba2fe0867885b40a",
"body": null,
"is_bot": false,
"headline": "Upgrade to Ubuntu 20 for all CI (#20)",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2021-05-04T19:31:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "aebd40a35c51bd08a2e4e09a5b8bf3cdcfb68e91",
"body": null,
"is_bot": false,
"headline": "add php 8.1 to build matrix (#19)",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2021-05-04T19:25:10Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0da94942aecc15fbda275dffd6e420726ac00f8c",
"body": "* added PHP 5.3 to the build matrix\r\n* php 5.3 compat in code and tests: `[] -> array()`",
"is_bot": false,
"headline": "Support for PHP 5.3",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2021-05-04T19:19:10Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0f853a6f0ff736bf5836589cafabe9636e87ad6f",
"body": "Switch from Travis to Github Actions as our test runner",
"is_bot": false,
"headline": "Using github actions (#17)",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2021-05-04T18:33:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9bf1bfdf69655c69bc5e5368a2bc034dcc632fe8",
"body": null,
"is_bot": false,
"headline": "JSON case",
"author_name": "William Peter Falci",
"author_login": "WilliamFalci",
"committed_at": "2020-12-29T00:00:37Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e2d6e9e186c347cc3f00733bf6c7799ec4b3c624",
"body": null,
"is_bot": false,
"headline": "Fix undefined offset exception",
"author_name": "richardudovich",
"author_login": "richardudovich",
"committed_at": "2019-03-01T17:16:51Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a3a40469722f28506c0c000e8b42c6854d0e11bd",
"body": null,
"is_bot": false,
"headline": "support database",
"author_name": "Alexey Solodkiy",
"author_login": null,
"committed_at": "2019-03-01T01:31:24Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f3fa038fd07ca30c0b3be4726f7693ecafe45c8b",
"body": null,
"is_bot": false,
"headline": "the commits will continue until morale improves",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2019-03-01T01:26:12Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "02351ce150b86007c3bc6268bd1aeae9687906fd",
"body": null,
"is_bot": false,
"headline": "try this?",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2019-03-01T01:20:34Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ce4625d0cf9036f28c37a69648decc9536b7499a",
"body": "peg to 7.4 which was the last one that worked",
"is_bot": false,
"headline": "nightly is now 8.0, which wont work (dependencies broken)",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2019-03-01T00:45:39Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8bfd265f24d29b898353f75c218be24d5436bb29",
"body": "no longer test nightly - composer is not supported",
"is_bot": false,
"headline": "pin version of hhvm we're testing",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2019-03-01T00:33:42Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a0aed3b89fe0c3a4e4edca6b6489db4f4619b869",
"body": null,
"is_bot": false,
"headline": "this version worked, i swear",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2019-01-25T21:37:25Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8fbb5e6fbfa1ca98fdf1f202ac084eddfc9c2d5e",
"body": null,
"is_bot": false,
"headline": "phpunit 6.5 is the last one to work with hhvm",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2019-01-25T21:27:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "dcb614bae8151ed9db79f56cb2cf369b9749f21b",
"body": null,
"is_bot": false,
"headline": "Set `null` to `true` for fields that default to `NULL`",
"author_name": "Michael Hahn",
"author_login": null,
"committed_at": "2018-01-09T21:19:45Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c5412e7563bd41783e10d31584eef7e653117f4d",
"body": "when lexing, set the source SQL as a prop",
"is_bot": false,
"headline": "document the public API.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-16T05:30:50Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "404c1ecdd3e8b8cbacb54f16a7591ba8acf3c223",
"body": null,
"is_bot": false,
"headline": "split general table tests into their own file",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-16T05:08:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a0b565e7ff20847dab18d5e665471eeffd9006e5",
"body": null,
"is_bot": false,
"headline": "some more TODOs",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-16T05:04:02Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f7ae33a0df581771a70db5a5e00bd8df10aa8ba1",
"body": "better field test helper\nimplemented binary flag parser\nadded binary support for CHAR/VARCHAR (new in MySQL 5.7)\ndecode charset and collation entities",
"is_bot": false,
"headline": "tests for BIT, CHAR/VARCHAR/etc fields",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-16T05:02:11Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d5cfb1dfe8e9f4b95f4a115fc0de68919df8a44e",
"body": null,
"is_bot": false,
"headline": "supprot and tests for fractional seconds precision on time types",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-16T04:48:31Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e8db894cbff6c7c7d0cc5f5aafbc3dff05c0e906",
"body": null,
"is_bot": false,
"headline": "added tests for float and numeric types",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-16T04:45:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c86b77ef50d78da3a18cb0d0562282a2dca0cffb",
"body": null,
"is_bot": false,
"headline": "test foreign key with a name",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-16T04:35:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3e087f05c6afb234fcda2ad6eb3e9507936e6136",
"body": null,
"is_bot": false,
"headline": "better explain what the library is for. history moved down lower",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-15T21:05:47Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "926d452469606624305f8e0a7bdd16162dd92519",
"body": "avoid some out of band reads",
"is_bot": false,
"headline": "full support for CHECK and FORIEGN KEY index conditions.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-15T20:56:51Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "482601cde261f6957b8e8bb1cb5da40a20e96a4b",
"body": null,
"is_bot": false,
"headline": "added a test for find_single_table mode",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T20:54:19Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "adf87288c6d6ea0d21bae8bb4f6fadfb52fc2dad",
"body": null,
"is_bot": false,
"headline": "started to write tests for field types",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T20:51:20Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b510bc3b2fa7ef68dfea0f41c0ed9e0d31b79d05",
"body": "added tests for constraints",
"is_bot": false,
"headline": "actually include constraint information in the index (duh).",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T20:31:41Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "103ef2b6856087587c3bf5f5141f1a868a9f5c71",
"body": null,
"is_bot": false,
"headline": "support for multiple index options, with tests",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T20:21:23Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "df86dc72b9e99cb33e454a8e081589c3be2e2ea2",
"body": "…of index.\n\nadded support for index comments (mysql 5.7)\nadded tests for all idnex options",
"is_bot": false,
"headline": "fixed index mode parser to not overflow for btree mode as last token …",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T20:17:10Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "30501a9d5ca0941f9197b53934c924b4f287921c",
"body": "change index.col.direction to upper case to match everything else",
"is_bot": false,
"headline": "added tests for index columns.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T20:10:15Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8cde164fa0813ddfb670e1a6a053b774cabd19da",
"body": null,
"is_bot": false,
"headline": "tests for indexes",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T19:57:54Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2d64c0840481f2c3eef33fe1364f9dd44382f8f5",
"body": "… bar`",
"is_bot": false,
"headline": "tests for `CREATE TABLE IF NOT EXISTS foo` and `CREATE TABLE foo LIKE…",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T19:57:25Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "713011e67b634f442f972451b497a2b7d8a4a0d1",
"body": "return mode in upper case, to match .type",
"is_bot": false,
"headline": "since the returned prop is called mode, call the function that too.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T19:57:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "dc2997b9a23c13cb7d72961faec3196f89c88dcc",
"body": null,
"is_bot": false,
"headline": "don't mess with any globals",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T05:38:54Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7b23d247fae3e4d8eafd0bd8601fa54b7dbbd249",
"body": null,
"is_bot": false,
"headline": "test some simple table props end-to-end",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T05:31:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9dde6404b5efebd76bb3c617e821aeea8beb2912",
"body": "renamed temporary table prop to `temporary`",
"is_bot": false,
"headline": "fixed two bounds error cases.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T05:30:35Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "924e51c850a5c40836b9baf4fa2a8c6cc40c7b4c",
"body": null,
"is_bot": false,
"headline": "added lexer tests for multiline comments that don't end",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T05:11:15Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fa00ac7d0aa71734f0b180a70fa579ff580b2954",
"body": "added composer installation instructions",
"is_bot": false,
"headline": "added travis and coveralls badges",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T05:09:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "11343214b7fb95d70f0d789db8ff3be1c4477564",
"body": null,
"is_bot": false,
"headline": "more lexer tests",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T04:54:44Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2595b267396abff0a842db0da36b38a1842ce106",
"body": null,
"is_bot": false,
"headline": "towards coverage logs",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T04:34:59Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "03cabc08dd07a394562d4e6152927b138ca2558e",
"body": null,
"is_bot": false,
"headline": "get travis running the phpunit tests",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T04:20:34Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f7f2e2fdc151fdec7bc91d6ee10d3bd31aae1aa3",
"body": null,
"is_bot": false,
"headline": "moved the example files over to the new layout/naming",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T04:01:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2fc077ef4613a1fe5f90926c7bbe87b8bb0e4c07",
"body": null,
"is_bot": false,
"headline": "moving to phpunit",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T03:59:52Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b37968357e8bb6dde09b3c1c670a04a3e3b756e4",
"body": null,
"is_bot": false,
"headline": "what an adventure",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T03:36:48Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5510c4e2fe4b31e7bdc7728c612c478d66cfba65",
"body": null,
"is_bot": false,
"headline": "composer documentation and tooling is *really* bad",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T03:35:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "341410239e24f75b4d045b08f237134cfad8223d",
"body": null,
"is_bot": false,
"headline": "packagist package names have to be lowercase",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T03:34:02Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "872e481fc0b1f842b70639eb4758558af6970adb",
"body": null,
"is_bot": false,
"headline": "updated tests for path and namespace changes",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T03:33:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a924287adefd4862370f9488b6327e2cca8938ea",
"body": "moved src into a subdir in the composer style",
"is_bot": false,
"headline": "added composer json",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-10T03:33:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "be254456c8faa5f5f7fadac2fe922fc16c187686",
"body": "still needs some more work",
"is_bot": false,
"headline": "replace some/most of the array shifting with a cursor instead.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-09T20:49:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "841e09a6c4694a6666a46d8e19abc8bf148b5224",
"body": "fixed a typo in function call name",
"is_bot": false,
"headline": "added some more checks to avoid php warnings.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-09T20:49:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c2a258a8d2657e69977124d5810de2a66b7e4b79",
"body": null,
"is_bot": false,
"headline": "silence all php warnings/notices",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-09-09T20:49:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9084e471a12478ff9c637beb3bf3cb9b24f2a141",
"body": null,
"is_bot": false,
"headline": "Create LICENSE",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2017-06-09T20:48:07Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0902af528efe28245c9278a120fac2f9d99d0f32",
"body": "In order to have the original CREATE TABLE text from the schema\navailable when using the parsed structure, rework the lexer so that\ninstead of extracting the substring tokens, it extracts tuples of\n[position, length] and maintains these associations when collapsing\nthe token sequences.\n\nThis means we can include the original source text in a `sql` field\nof the resulting parsed structure.",
"is_bot": false,
"headline": "rework the lexer to keep track of source locations for each token",
"author_name": "Michael Demmer",
"author_login": "demmer",
"committed_at": "2017-02-16T22:01:50Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b944a2a63f86e2f3ee26f0b929454885e4dc5247",
"body": null,
"is_bot": false,
"headline": "support LONGBLOB types",
"author_name": "Michael Demmer",
"author_login": "demmer",
"committed_at": "2017-02-14T04:45:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ad246f58ad2a4f3be5e9defdcbee85c0fa25a2ef",
"body": null,
"is_bot": false,
"headline": "simple test file while i add capabilities",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-15T18:14:28Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f61aa253adf37b9743b4856abcf4708dfadcebd2",
"body": null,
"is_bot": false,
"headline": "support for value lists in enum & set field defs",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-15T00:29:35Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "76a23accffa4c334759603411f1112e4cd48c543",
"body": null,
"is_bot": false,
"headline": "auto_increment support",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-15T00:23:23Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7a9f01a2d52df18120275c00be609730087cb26b",
"body": null,
"is_bot": false,
"headline": "decode identifiers for column names in indexes",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-15T00:21:16Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "795e5c421ae06da799517a0c49478f7cbd4207ea",
"body": "decode them too",
"is_bot": false,
"headline": "actually return index names instead of discarding them.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-15T00:20:01Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "04117a09d5db179e23e723b07609d520bf1e8926",
"body": "added decoding for values.\nrefactored decoding for identifiers.",
"is_bot": false,
"headline": "added support for default field values.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-15T00:17:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a93a2203fa9cdcce00c9a7bc168759f11440c81b",
"body": null,
"is_bot": false,
"headline": "handle single and double quoted strings",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-15T00:06:30Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d2cee4caddfd01122f61d26622990254510fac1f",
"body": null,
"is_bot": false,
"headline": "correctly parse index columns, taking into account length and asc/desc",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-14T05:03:43Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2cf04353680e1f5d6a3b3b3840d3e6e269f3c6c9",
"body": null,
"is_bot": false,
"headline": "support for index options",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-14T04:53:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f4c91622bdb4556b52d8abe3bb74d6e7c601cd8c",
"body": null,
"is_bot": false,
"headline": "when an index is USING HASH, it means the index type is ... hash. duh",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-14T04:51:42Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "13c51b9a300bd998a75e7111d3c4db653fe57100",
"body": null,
"is_bot": false,
"headline": "only add the 'more' array is there are extra, unparsed tokens",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-14T04:39:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ca6cf8a4fda37f8e762eb37a57571c0fa95c7f9e",
"body": null,
"is_bot": false,
"headline": "parse character set and collations",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-14T04:36:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "1da164c1c056ce3ec8c9ac06f7b6fd505fc8a412",
"body": "support for unsigned and zerofill field props.\nsupport for null/not-null field props.",
"is_bot": false,
"headline": "support for fields lengths.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-13T02:45:37Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e67dee42779d46e3c5359aaea0c2aa308288a90c",
"body": null,
"is_bot": false,
"headline": "recognize the <unsigned numeric literal> token when lexing",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-13T02:45:31Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f5dbb8fbea72821ca9e14d683671876e07f7d4af",
"body": null,
"is_bot": false,
"headline": "renamed test files to .php to avoid confusion",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-11T19:47:45Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b32f1387cf88adcad2bef45b6bf772f3ecf65bec",
"body": null,
"is_bot": false,
"headline": "updated the readme to reflect what the library's purpose is now",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-11T19:45:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "dc27f3a9eecc4a822a7bea52760ac7f019aa6dab",
"body": null,
"is_bot": false,
"headline": "the old glitch schema, for testing",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-11T19:39:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d58439c8699a00fe88d007eb1601d49acff8ad99",
"body": null,
"is_bot": false,
"headline": "point the tests to the new file & classname",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-11T19:38:45Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "bf7aede91ed4757caa2207bcf963ccd37b423a95",
"body": null,
"is_bot": false,
"headline": "renamed main file and the class inside it",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-11T19:36:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e4bd20b03349a3dd38f2a32b19891e9ca056d71f",
"body": "…rser now",
"is_bot": false,
"headline": "removed the old compare script - this repo is just going to be the pa…",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2015-06-11T19:05:53Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a32a7af0068c2de0392c33329865ff7be0890369",
"body": "stubbed out all of the supported fields types (non complete yet)",
"is_bot": false,
"headline": "changed field parsing to use a switch.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2013-06-14T18:08:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "8efc1bb7c883081a833c1d8819b11a52412610b0",
"body": null,
"is_bot": false,
"headline": "the first end-to-end test",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2013-06-14T17:50:19Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6132eec6b8e0d46b6cce895db496ab453ecc588e",
"body": "…() method caqn be fully tested.",
"is_bot": false,
"headline": "added a global option for debugging a single table, so that the parse…",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2013-06-14T17:49:50Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "efc92572519fca4cf0cef846e78ab2ba26091bab",
"body": "avoids having to use StrToUpper in the field parser.",
"is_bot": false,
"headline": "some more single-token keywords that need uppercasing.",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2013-06-12T20:35:34Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fb1460b076b9296ea91251071846f9e55e49d23c",
"body": "added support for FULLTEXT and SPATIAL indexes.",
"is_bot": false,
"headline": "switch the index parser to use a switch().",
"author_name": "Cal Henderson",
"author_login": "iamcal",
"committed_at": "2013-06-12T20:33:40Z",
"body_truncated": false,
"is_coding_agent": false
}
],
"releases_count": 2,
"commits_last_year": 6,
"latest_release_at": "2026-01-28T22:23:25Z",
"latest_release_tag": "v0.7",
"releases_from_tags": false,
"days_since_last_push": 174,
"active_weeks_last_year": 1,
"days_since_latest_release": 174,
"mean_days_between_releases": 3062.7
},
"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": "iamcal/sql-parser",
"exists": true,
"license": "MIT",
"keywords": [],
"ecosystem": "packagist",
"matches_repo": true,
"registry_url": "https://packagist.org/packages/iamcal/sql-parser",
"is_deprecated": false,
"latest_version": "v0.7",
"repository_url": "https://github.com/iamcal/SQLParser",
"versions_count": 7,
"total_downloads": 38486535,
"dependents_count": 10,
"deprecation_note": null,
"maintainers_count": null,
"monthly_downloads": 4742890,
"first_published_at": null,
"latest_published_at": "2026-01-28T22:20:33Z",
"latest_version_yanked": null,
"days_since_latest_publish": 174
}
]
},
"popularity": {
"forks": 20,
"stars": 77,
"watchers": 3,
"fork_history": {
"days": [
{
"date": "2017-02-14",
"count": 1
},
{
"date": "2018-01-08",
"count": 1
},
{
"date": "2018-08-29",
"count": 1
},
{
"date": "2018-11-29",
"count": 1
},
{
"date": "2019-02-06",
"count": 1
},
{
"date": "2019-06-10",
"count": 1
},
{
"date": "2019-06-20",
"count": 1
},
{
"date": "2019-08-13",
"count": 1
},
{
"date": "2019-08-16",
"count": 1
},
{
"date": "2019-09-22",
"count": 1
},
{
"date": "2020-04-30",
"count": 1
},
{
"date": "2020-12-16",
"count": 1
},
{
"date": "2021-09-21",
"count": 1
},
{
"date": "2021-10-14",
"count": 1
},
{
"date": "2022-03-03",
"count": 1
},
{
"date": "2022-04-24",
"count": 1
},
{
"date": "2022-05-25",
"count": 1
},
{
"date": "2024-01-12",
"count": 1
},
{
"date": "2024-12-13",
"count": 1
},
{
"date": "2026-01-24",
"count": 1
}
],
"complete": true,
"collected": 20,
"total_forks": 20
},
"star_history": null,
"open_issues_and_prs": 1
},
"ai_readiness": {
"has_nix": false,
"example_dirs": [],
"has_llms_txt": false,
"has_dockerfile": false,
"has_mcp_signal": false,
"bootstrap_files": [
"Makefile"
],
"api_schema_files": [],
"has_devcontainer": false,
"typecheck_configs": [],
"toolchain_manifests": [],
"largest_source_bytes": 27313,
"source_files_sampled": 12,
"oversized_source_files": 0,
"agent_instruction_files": [],
"agent_instruction_max_bytes": null
},
"dependencies": {
"manifests": [
"composer.json"
],
"advisories": {
"error": "No resolved dependencies carried a version and a supported ecosystem",
"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": 2,
"direct_affected_count": 0
},
"ecosystems": [
"packagist"
],
"dependencies": [],
"all_dependencies": {
"error": null,
"source": "github-sbom",
"packages": [
{
"name": "php-coveralls/php-coveralls",
"direct": false,
"version": null,
"ecosystem": "packagist"
},
{
"name": "phpunit/phpunit",
"direct": false,
"version": null,
"ecosystem": "packagist"
}
],
"collected": true,
"truncated": false,
"total_count": 2,
"direct_count": 0,
"indirect_count": 2
}
},
"maintainership": {
"issues": {
"open_prs": 1,
"merged_prs": 21,
"open_issues": 0,
"closed_ratio": 1,
"closed_issues": 8,
"closed_unmerged_prs": 2
},
"bus_factor": 1,
"bot_contributors": 0,
"top_contributors": [
{
"type": "User",
"login": "iamcal",
"commits": 109,
"avatar_url": "https://avatars.githubusercontent.com/u/173750?v=4"
},
{
"type": "User",
"login": "ngmy",
"commits": 6,
"avatar_url": "https://avatars.githubusercontent.com/u/864041?v=4"
},
{
"type": "User",
"login": "rodber",
"commits": 4,
"avatar_url": "https://avatars.githubusercontent.com/u/20590102?v=4"
},
{
"type": "User",
"login": "demmer",
"commits": 2,
"avatar_url": "https://avatars.githubusercontent.com/u/3308504?v=4"
},
{
"type": "User",
"login": "DirtyRacer1337",
"commits": 1,
"avatar_url": "https://avatars.githubusercontent.com/u/17379553?v=4"
},
{
"type": "User",
"login": "owenvoke",
"commits": 1,
"avatar_url": "https://avatars.githubusercontent.com/u/1899334?v=4"
},
{
"type": "User",
"login": "WilliamFalci",
"commits": 1,
"avatar_url": "https://avatars.githubusercontent.com/u/36926081?v=4"
},
{
"type": "User",
"login": "richardudovich",
"commits": 1,
"avatar_url": "https://avatars.githubusercontent.com/u/828730?v=4"
}
],
"contributors_sampled": 8,
"top_contributor_share": 0.872
},
"quality_signals": {
"has_ci": true,
"has_tests": true,
"ci_workflows": [
"php.yml"
],
"has_docs_dir": false,
"linter_configs": [],
"has_editorconfig": false,
"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": "1 out of 16 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": 3,
"reason": "Found 8/22 approved changesets -- score normalized to 3",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#code-review"
},
{
"name": "Contributors",
"score": 6,
"reason": "project has 2 contributing companies or organizations -- score normalized to 6",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#contributors"
},
{
"name": "Dangerous-Workflow",
"score": 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": 10,
"reason": "0 existing vulnerabilities detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#vulnerabilities"
}
],
"commit": "610392f38de49a44dab08dc1659960a29874c4b8",
"ran_at": "2026-07-22T17:43:47Z",
"aggregate_score": 3,
"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-19T06:21:28Z",
"oldest_open_prs": [
{
"number": 5,
"created_at": "2017-09-10T05:34:31Z",
"last_comment_at": "2017-09-10T05:39:04Z",
"last_comment_author": "coveralls"
}
],
"last_merged_pr_at": "2026-01-28T22:20:33Z",
"ci_last_conclusion": "FAILURE",
"oldest_open_issues": []
}
},
"config": {
"disabled_metrics": [],
"disabled_categories": [],
"disabled_components": {}
},
"source": {
"url": "https://github.com/iamcal/SQLParser",
"host": "github.com",
"name": "SQLParser",
"owner": "iamcal"
},
"metrics": {
"overall": {
"key": "overall",
"band": "moderate",
"name": "Overall health",
"note": null,
"notes": [],
"value": 50,
"inputs": {
"security": 30,
"vitality": 37,
"community": 56,
"governance": 68,
"engineering": 53
},
"components": []
},
"categories": [
{
"key": "vitality",
"band": "at_risk",
"name": "Vitality",
"value": 37,
"weight": 0.22,
"metrics": [
{
"key": "development_activity",
"band": "critical",
"name": "Development activity",
"note": null,
"notes": [],
"value": 18,
"inputs": {
"commits_last_year": 6,
"human_commit_share": 1,
"days_since_last_push": 174,
"active_weeks_last_year": 1
},
"components": [
{
"key": "push_recency",
"name": "Push recency",
"detail": "last push 174 days ago",
"points": 9.9,
"status": "partial",
"details": [
{
"code": "push_recency",
"params": {
"days": 174
}
}
],
"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": "6 commits in the last year",
"points": 7.6,
"status": "partial",
"details": [
{
"code": "commits_last_year",
"params": {
"count": 6
}
}
],
"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": "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": 66,
"inputs": {
"releases_count": 2,
"latest_release_tag": "v0.7",
"releases_from_tags": false,
"days_since_latest_release": 174,
"mean_days_between_releases": 3062.7
},
"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 174 days ago",
"points": 27,
"status": "partial",
"details": [
{
"code": "release_recency",
"params": {
"days": 174
}
}
],
"max_points": 36
},
{
"key": "release_cadence",
"name": "Release cadence",
"detail": "a release every ~3062.7 days",
"points": 5.4,
"status": "partial",
"details": [
{
"code": "release_cadence",
"params": {
"gap": 3062.7
}
}
],
"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": 174,
"days_since_last_human_commit_is_floor": false
},
"components": [
{
"key": "project_is_still_maintained",
"name": "Project is still maintained",
"detail": "last human commit 174 days ago",
"points": 100,
"status": "met",
"details": [
{
"code": "abandonment_maintained",
"params": {
"days": 174
}
}
],
"max_points": 100
}
]
}
],
"description": "Is the project alive — is code being written and are releases shipping?"
},
{
"key": "community",
"band": "moderate",
"name": "Community & Adoption",
"value": 56,
"weight": 0.18,
"metrics": [
{
"key": "popularity",
"band": "at_risk",
"name": "Popularity & adoption",
"note": null,
"notes": [],
"value": 43,
"inputs": {
"forks": 20,
"stars": 77,
"watchers": 3,
"growth_state": "unverified",
"growth_factor_pct": 100,
"growth_unverified_reason": "no_history"
},
"components": [
{
"key": "stars",
"name": "Stars",
"detail": "77 stars",
"points": 30.5,
"status": "partial",
"details": [
{
"code": "stars",
"params": {
"count": 77
}
}
],
"max_points": 60
},
{
"key": "forks",
"name": "Forks",
"detail": "20 forks",
"points": 10.7,
"status": "partial",
"details": [
{
"code": "forks",
"params": {
"count": 20
}
}
],
"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
}
]
},
{
"key": "ecosystem_adoption",
"band": "excellent",
"name": "Ecosystem adoption (downloads)",
"note": null,
"notes": [],
"value": 87,
"inputs": {
"packages": [
"iamcal/sql-parser"
],
"dependents": 10,
"ecosystems": "packagist",
"total_downloads": 38486535,
"monthly_downloads": 4742890
},
"components": [
{
"key": "monthly_downloads",
"name": "Monthly downloads",
"detail": "4,742,890 downloads/month across packagist",
"points": 80,
"status": "met",
"details": [
{
"code": "downloads_monthly",
"params": {
"count": 4742890,
"ecosystems": "packagist"
}
}
],
"max_points": 80
},
{
"key": "registry_dependents",
"name": "Registry dependents",
"detail": "10 packages depend on it",
"points": 6.9,
"status": "partial",
"details": [
{
"code": "registry_dependents",
"params": {
"count": 10
}
}
],
"max_points": 20
}
]
}
],
"description": "Does the project have users, downloads, attention, and a welcoming setup for contributors?"
},
{
"key": "governance",
"band": "moderate",
"name": "Sustainability & Governance",
"value": 68,
"weight": 0.24,
"metrics": [
{
"key": "maintainer_resilience",
"band": "critical",
"name": "Maintainer resilience (bus factor)",
"note": null,
"notes": [],
"value": 29,
"inputs": {
"bus_factor": 1,
"contributors_sampled": 8,
"top_contributor_share": 0.872
},
"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 87% of commits",
"points": 2.9,
"status": "partial",
"details": [
{
"code": "top_contributor_share",
"params": {
"share": 87
}
}
],
"max_points": 22.5
},
{
"key": "contributor_breadth",
"name": "Contributor breadth",
"detail": "8 contributors",
"points": 10.8,
"status": "partial",
"details": [
{
"code": "contributors_sampled",
"params": {
"count": 8
}
}
],
"max_points": 13.5
},
{
"key": "openssf_scorecard_contributors",
"name": "OpenSSF Scorecard: Contributors",
"detail": "project has 2 contributing companies or organizations -- score normalized to 6",
"points": 6,
"status": "partial",
"details": [],
"max_points": 10
}
]
},
{
"key": "responsiveness",
"band": "excellent",
"name": "Issue & PR responsiveness",
"note": null,
"notes": [],
"value": 86,
"inputs": {
"merged_prs": 21,
"open_issues": 0,
"closed_issues": 8,
"issue_closed_ratio": 1,
"closed_unmerged_prs": 2
},
"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": "21/23 decided PRs merged",
"points": 34.9,
"status": "partial",
"details": [
{
"code": "decided_prs_merged",
"params": {
"merged": 21,
"decided": 23
}
}
],
"max_points": 38.25
},
{
"key": "openssf_scorecard_code_review",
"name": "OpenSSF Scorecard: Code-Review",
"detail": "Found 8/22 approved changesets -- score normalized to 3",
"points": 4.5,
"status": "partial",
"details": [],
"max_points": 15
}
]
},
{
"key": "stewardship",
"band": "good",
"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": 71,
"inputs": {
"followers": 1025,
"owner_type": "User",
"is_verified": null,
"owner_login": "iamcal",
"public_repos": 193,
"account_age_days": 6048
},
"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": "1,025 followers of iamcal",
"points": 21.6,
"status": "partial",
"details": [
{
"code": "owner_followers",
"params": {
"count": 1025,
"login": "iamcal"
}
}
],
"max_points": 25
},
{
"key": "track_record",
"name": "Track record",
"detail": "193 public repos, account ~16 yr old",
"points": 25,
"status": "met",
"details": [
{
"code": "public_repos",
"params": {
"count": 193
}
},
{
"code": "account_age_years",
"params": {
"years": 16
}
}
],
"max_points": 25
}
]
},
{
"key": "package_maintenance",
"band": "excellent",
"name": "Package maintenance",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"packages": [
"iamcal/sql-parser"
],
"ecosystems": "packagist",
"any_deprecated": false,
"min_days_since_publish": 174
},
"components": [
{
"key": "published_resolvable",
"name": "Published & resolvable",
"detail": "1 package(s) on packagist",
"points": 25,
"status": "met",
"details": [
{
"code": "packages_published",
"params": {
"count": 1,
"ecosystems": "packagist"
}
}
],
"max_points": 25
},
{
"key": "publish_recency",
"name": "Publish recency",
"detail": "latest publish 174 days ago",
"points": 35,
"status": "met",
"details": [
{
"code": "publish_recency",
"params": {
"days": 174
}
}
],
"max_points": 35
},
{
"key": "version_history",
"name": "Version history",
"detail": "7 published versions",
"points": 20,
"status": "met",
"details": [
{
"code": "published_versions",
"params": {
"count": 7
}
}
],
"max_points": 20
},
{
"key": "not_deprecated",
"name": "Not deprecated",
"detail": "active, not deprecated or yanked",
"points": 20,
"status": "met",
"details": [
{
"code": "package_not_deprecated",
"params": {}
}
],
"max_points": 20
}
]
}
],
"description": "Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep?"
},
{
"key": "engineering",
"band": "moderate",
"name": "Engineering Quality",
"value": 53,
"weight": 0.2,
"metrics": [
{
"key": "engineering_practices",
"band": "at_risk",
"name": "Engineering practices",
"note": null,
"notes": [],
"value": 48,
"inputs": {
"has_ci": true,
"has_tests": true,
"has_editorconfig": false,
"has_linter_config": false,
"has_precommit_config": false
},
"components": [
{
"key": "ci_workflows",
"name": "CI workflows",
"detail": "1 workflow(s)",
"points": 24,
"status": "met",
"details": [
{
"code": "ci_workflows",
"params": {
"count": 1
}
}
],
"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": 0,
"status": "missed",
"details": [],
"max_points": 6.4
},
{
"key": "openssf_scorecard_ci_tests",
"name": "OpenSSF Scorecard: CI-Tests",
"detail": "1 out of 16 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": 60,
"inputs": {
"topics": [
"php",
"sql-parser",
"lex",
"composer",
"database",
"autoloader"
],
"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": "6 topics",
"points": 10,
"status": "met",
"details": [
{
"code": "topics_count",
"params": {
"count": 6
}
}
],
"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": 30,
"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": 30,
"inputs": {
"source": "openssf_scorecard",
"checks_evaluated": 13,
"scorecard_version": "v5.5.0",
"checks_inconclusive": 5,
"scorecard_aggregate": 3
},
"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": "1 out of 16 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 8/22 approved changesets -- score normalized to 3",
"points": 2.2,
"status": "partial",
"details": [],
"max_points": 7.5
},
{
"key": "contributors",
"name": "Contributors",
"detail": "project has 2 contributing companies or organizations -- score normalized to 6",
"points": 1.5,
"status": "partial",
"details": [],
"max_points": 2.5
},
{
"key": "dangerous_workflow",
"name": "Dangerous-Workflow",
"detail": "no 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": "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": 9
},
"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": "at_risk",
"name": "AI Readiness",
"value": 33,
"weight": 0,
"metrics": [
{
"key": "ai_agent_context",
"band": "critical",
"name": "Agent context & guidance",
"note": null,
"notes": [],
"value": 6,
"inputs": {
"has_llms_txt": false,
"legible_history_share": 0.12,
"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": "12 of 100 human commits state their intent (structured subject or explanatory body)",
"points": 6.4,
"status": "partial",
"details": [
{
"code": "legible_history",
"params": {
"legible": 12,
"sampled": 100
}
}
],
"max_points": 40
}
]
},
{
"key": "ai_verify_loop",
"band": "at_risk",
"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": 44,
"inputs": {
"has_nix": false,
"has_tests": true,
"lockfiles": [],
"has_dockerfile": false,
"typed_language": false,
"bootstrap_files": [
"Makefile"
],
"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": "Makefile",
"points": 18,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "Makefile"
}
}
],
"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": "moderate",
"name": "Code legibility for models",
"note": null,
"notes": [],
"value": 55,
"inputs": {
"primary_language": "PHP",
"largest_source_bytes": 27313,
"source_files_sampled": 12,
"oversized_source_files": 0
},
"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": "0/12 source files over 60KB",
"points": 55,
"status": "met",
"details": [
{
"code": "oversized_source_files",
"params": {
"kb": 60,
"sampled": 12,
"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",
"No resolved dependencies carried a version and a supported ecosystem"
],
"report_type": "repository",
"generated_at": "2026-07-22T17:44:03.883045Z",
"schema_version": "0.26.0",
"badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/i/iamcal/SQLParser.svg",
"full_name": "iamcal/SQLParser",
"license_state": "standard",
"license_spdx": "MIT"
}Bewertungen sind Signale, keine Garantien. Sie spiegeln öffentlich sichtbare Praxis auf GitHub wider — kein Code-Audit und keine Sicherheitsgarantie.
Fehlende Daten werden ausgeschlossen und die Gewichte neu normiert, nie als null bewertet. Die Methodik ist versioniert und offen: Metriken v1.13.0, Schema v0.26.0 — vollständige Methodik · Metriken-Wiki.
Wie ein einzelnes Ergebnis im Gesamtregister steht: aggregierte Statistiken — Packagist.