PorchlampFind the projects that leave the light on.2026-10-17

What happens to a stranger's pull request here, in the Porchlamp snapshot of 17 October 2026.

For xo/usql, the reply time and the share with no reply within 14 days both have too small a sample to measure (0 and 5 pull requests counted; 10 needed). It ranks 2,960 of 3,219 overall. For first-time contributors it ranks 1,525 of 1,525 (the bottom 1%).

Key facts
Rank2,960 of 3,219
Score34.93
TierD
Median first reply—
14-day no-reply share—
First-timer rank1,525 of 1,525
EcosystemGo
Window—

Composite

Rank
2,960 of 3,219
Score
34.93
Tier
D
Coverage
78% · Ceiling B
Quadrant
Crucible

Coordinates: leverage 51.1 (coverage 100%), friction 79.1 (coverage 57%)

Five pillars

Score out of 100, and how much of the pillar was measured
PillarScoreCoverage
Responsiveness0.020%
Criticality52.9100%
Governance50.5100%
Rigor48.5100%
Accessibility28.885%

The measured parameters

Responsiveness

ParameterValueScoreCountWindowSource
Decision Rate (90d)Share of outside pull requests that were merged or closed within 90 days.Not shown: Insufficient sample size
PR Ghost Rate (14d)Share of outside pull requests with no maintainer response, merge or close within 14 days.Not shown: Insufficient sample size
First-timer Merge RateShare of first-time outside authors' decided pull requests that were merged.0.0%0.06—primaryraw/author_history/xo__usql.json
Time to First ResponseMedian hours from an outside pull request opening to its first substantive human reply.Not shown: Insufficient sample size
Time to Merge (p90)Hours within which 90% of merged outside pull requests were merged.Not shown: Insufficient sample size

Criticality

ParameterValueScoreCountWindowSource
DependentsPackages in the registry that depend on this project, counted once each.3864.5——primaryraw/dependents/xo__usql.json
Monthly DownloadsDownloads from the package registry in a month.Not shown: Not applicable
OpenSSF CriticalityOpenSSF criticality score from 0 to 1, computed from the project's public activity signals.0.397239.7——primaryraw/github_meta/xo__usql.json

Governance

ParameterValueScoreCountWindowSource
Elephant FactorThe fewest organisations that account for half of the last year's commits.125.080—primaryraw/commits_365d/xo__usql.json
Legal IP RegimeThe contributor licence regime: DCO, none, a foundation CLA or a corporate CLA.No CLA or sign-off found85.0——primaryraw/governance/xo__usql.json
Promotion LadderHow openly a contributor can become a maintainer, from closed to verified.No written path to becoming a maintainer40.0——primaryraw/governance/xo__usql.json

Rigor

ParameterValueScoreCountWindowSource
AI Policy PostureWhether the project has a written policy on AI-assisted contributions.Written AI policy95.0——primaryraw/governance/xo__usql.json
Pipeline DefensesHow well the project's build and review pipeline defends against bad changes, 0 to 100.5050.0——primaryraw/scorecard/xo__usql.json
Substantive Review RateShare of decided pull requests that received a substantive review.0.0%0.01018 April to 15 October 2026primaryraw/pr_window/xo__usql.json

Accessibility

ParameterValueScoreCountWindowSource
Developer ExperienceDeveloper experience, 0 to 100: half CI run time, half setup signals.7070.011—primaryraw/actions_runs/xo__usql.json
Newcomer ConversionShare of first-time authors whose first pull request merged within 180 days.0.0%0.05—primaryraw/author_history/xo__usql.json
Newcomer Issue SupplyOpen, unassigned, up-to-date issues marked for newcomers.440.0——primaryraw/gfi/xo__usql.json
Newcomer Return RateShare of those merged first-time authors who sent a second pull request within 90 days.Not shown: Insufficient sample size

Persona view

PersonaRankScoreTierStatus
Balanced2,960 of 3,21934.93DRated
First-timer1,525 of 1,52526.36DRated
Career capitalThis repository's production-criticality signal is not yet high enough for career-capital ranking.
Senior systemsFewer than 3 organizations account for most commits (not multi-vendor).
AI-assisted3,259 of 3,69638.02DRated

Integrity

Snapshot
2026-10-17
Raw hash
e5ae75aa96578a4dad02afcefa369b445ac9b55e3850de7067b9d26519865478

closed_unread

The full record is in data/2026-10-17/repos/7e.json, under the key xo/usql.

How every number is measured: Porchlamp methodology.

Open an issue about this record and say what looks wrong.

Porchlamp (2026). xo/usql. Snapshot 2026-10-17. https://porchlamp.org/projects/xo/usql/. CC BY 4.0.

Similar projects

The ranked projects nearest this one in the same ecosystem.