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.

Outside pull requests to fastapi/sqlmodel got a first human reply in a median of 7.2 hours (24 pull requests, 10 April to 7 October 2026); 55% got none within 14 days. It ranks 987 of 3,219 overall. It is not ranked for first-time contributors: this repository does not show a low enough barrier for a first-time contributor.

Key facts
Rank987 of 3,219
Score55.47
TierB
Median first reply7.2 hours
14-day no-reply share55%
First-timer rankThis repository does not show a low enough barrier for a first-time contributor.
EcosystemPython
Window10 April to 7 October 2026

Composite

Rank
987 of 3,219
Score
55.47
Tier
B
Coverage
100% · Full
Quadrant
Sweet Spot

Coordinates: leverage 54.7 (coverage 100%), friction 43.0 (coverage 100%)

Five pillars

Score out of 100, and how much of the pillar was measured
PillarScoreCoverage
Responsiveness66.3100%
Criticality69.4100%
Governance50.5100%
Rigor32.9100%
Accessibility43.4100%

The measured parameters

Responsiveness

ParameterValueScoreCountWindowSource
Decision Rate (90d)Share of outside pull requests that were merged or closed within 90 days.75.0%93.82410 April to 9 July 2026primaryraw/pr_window/fastapi__sqlmodel.json
PR Ghost Rate (14d)Share of outside pull requests with no maintainer response, merge or close within 14 days.54.5%0.03320 April to 17 October 2026primaryraw/pr_window/fastapi__sqlmodel.json
First-timer Merge RateShare of first-time outside authors' decided pull requests that were merged.18.8%23.432—primaryraw/author_history/fastapi__sqlmodel.json
Time to First ResponseMedian hours from an outside pull request opening to its first substantive human reply.7.2 hours (0.3 days)100.02410 April to 7 October 2026primaryraw/pr_window/fastapi__sqlmodel.json
Time to Merge (p90)Hours within which 90% of merged outside pull requests were merged.91.1 hours (3.8 days)81.86210 April to 7 October 2026primaryraw/pr_window/fastapi__sqlmodel.json

Criticality

ParameterValueScoreCountWindowSource
DependentsPackages in the registry that depend on this project, counted once each.19579.2——primaryraw/dependents/fastapi__sqlmodel.json
Monthly DownloadsDownloads from the package registry in a month.23.9 million downloads a month84.7——primaryraw/downloads/pypi__sqlmodel.json
OpenSSF CriticalityOpenSSF criticality score from 0 to 1, computed from the project's public activity signals.0.472547.3——primaryraw/github_meta/fastapi__sqlmodel.json

Governance

ParameterValueScoreCountWindowSource
Elephant FactorThe fewest organisations that account for half of the last year's commits.125.0128—primaryraw/commits_365d/fastapi__sqlmodel.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/fastapi__sqlmodel.json
Promotion LadderHow openly a contributor can become a maintainer, from closed to verified.No written path to becoming a maintainer40.0——primaryraw/governance/fastapi__sqlmodel.json

Rigor

ParameterValueScoreCountWindowSource
AI Policy PostureWhether the project has a written policy on AI-assisted contributions.No written AI policy40.0——primaryraw/governance/fastapi__sqlmodel.json
Pipeline DefensesHow well the project's build and review pipeline defends against bad changes, 0 to 100.43.157943.2114—proxy:review_ciraw/pr_window/fastapi__sqlmodel.json
Substantive Review RateShare of decided pull requests that received a substantive review.9.8%12.311210 April to 7 October 2026primaryraw/pr_window/fastapi__sqlmodel.json

Accessibility

ParameterValueScoreCountWindowSource
Developer ExperienceDeveloper experience, 0 to 100: half CI run time, half setup signals.8585.018—primaryraw/actions_runs/fastapi__sqlmodel.json
Newcomer ConversionShare of first-time authors whose first pull request merged within 180 days.43.8%87.516—primaryraw/author_history/fastapi__sqlmodel.json
Newcomer Issue SupplyOpen, unassigned, up-to-date issues marked for newcomers.00.0——primaryraw/gfi/fastapi__sqlmodel.json
Newcomer Return RateShare of those merged first-time authors who sent a second pull request within 90 days.0.0%0.07—primaryraw/author_history/fastapi__sqlmodel.json

Persona view

PersonaRankScoreTierStatus
Balanced987 of 3,21955.47BRated
First-timerThis repository does not show a low enough barrier for a first-time contributor.
Career capital442 of 79857.09BRated
Senior systemsFewer than 3 organizations account for most commits (not multi-vendor).
AI-assisted1,785 of 3,69650.58CRated

Integrity

Snapshot
2026-10-17
Raw hash
10e54ec95e5200396338801118c9082a86d9947e19c762801c8b358606b257d9

closed_unread

The full record is in data/2026-10-17/repos/ce.json, under the key fastapi/sqlmodel.

How every number is measured: Porchlamp methodology.

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

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

Similar projects

The ranked projects nearest this one in the same ecosystem.