René's URL Explorer Experiment


Title: improvement(ci): scan CodeQL PRs at the promotion boundary, refresh main daily by waleedlatif1 · Pull Request #7213 · simstudioai/sim · GitHub

Open Graph Title: improvement(ci): scan CodeQL PRs at the promotion boundary, refresh main daily by waleedlatif1 · Pull Request #7213 · simstudioai/sim

X Title: improvement(ci): scan CodeQL PRs at the promotion boundary, refresh main daily by waleedlatif1 · Pull Request #7213 · simstudioai/sim

Description: Summary CodeQL runs ~3,090 times a month and costs ~$382/mo across both languages. 90 of the last 100 PRs target staging, and every one of those is scanned again — against the exact tree being promoted — when the staging→main PR opens. PR scans restricted to main. This defers the signal to the promotion boundary rather than dropping it. Verified safe: no ruleset or branch protection requires a CodeQL status check (all four rulesets carry only pull_request/deletion/non_fast_forward), and the code-scanning alert view is fed by the push-to-main and scheduled analyses — PR analyses upload against refs/pull/N/merge and only ever surface as PR annotations. Deliberately a branch cut, not an activity-type cut. Dropping synchronize would have cut a similar share, but it scans a PR's first commit and never its final state — backwards, since review fixups land in later pushes. Scheduled scan weekly → daily. Pushes to main are rare, so with PR scans limited to main the alert view leans on the cron more than before. It also reseeds the overlay-base database (see below). Costs a few dollars a month. Documented a trap in codeql-config.yml: adding queries:/packs:/query-filters: trips OverlayDisabledReason.NonDefaultQueries and permanently disables overlay analysis — trading a documented up-to-10x win for a few percent. Follow-up, not fixed here The scan is slow for a reason unrelated to scope: the overlay-base database uploads on every push to main and never restores on a PR run. Observed 4/4 misses against a byte-identical cache key: Looking in Actions cache for overlay-base database with restore key codeql-overlay-base-database-1--javascript-- No overlay-base database found in Actions cache ...49 minutes after a run logged Successfully uploaded overlay-base database with a key matching that prefix exactly. Phase timings show extraction is 118s of a 221s run (53%) — precisely what overlay skips. GitHub's cache API holds zero overlay entries, so the multi-GB base is going into the runner provider's transparent cache rather than GitHub's. Fixing that restore is worth roughly half of every PR scan and is tracked separately. Type of Change Improvement Testing actionlint clean. Verified the parsed triggers (pull_request.branches: [main], unchanged types, push: [main], daily cron) and that both matrix languages still expand. bun run lint and all 38 check:audits pass. Checklist Code follows project style guidelines Self-reviewed my changes Tests added/updated and passing No new warnings introduced I confirm that I have read and agree to the terms outlined in the Contributor License Agreement (CLA)

Open Graph Description: Summary CodeQL runs ~3,090 times a month and costs ~$382/mo across both languages. 90 of the last 100 PRs target staging, and every one of those is scanned again — against the exact tree being prom...

X Description: Summary CodeQL runs ~3,090 times a month and costs ~$382/mo across both languages. 90 of the last 100 PRs target staging, and every one of those is scanned again — against the exact tree being prom...

Opengraph URL: https://github.com/simstudioai/sim/pull/7213

X: @github

direct link

Domain: github.com

react-profiling0
react-import-mapreact,react-dom,react-dom/client,react-dom/profiling,react-is,react-reconciler,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@d5750093facf
route-pattern/:user_id/:repository/pull/:id/files(.:format)
route-controllerpull_requests
route-actionfiles
fetch-noncev2:f8556dd6-1018-b08c-f623-176019cae370
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idE43A:2BF3D1:95F484:D312D7:6AFB72CD
html-safe-nonce3e44a36b817dacf5dc6f72512ad909e09ee74a69fde5eb0a8acfacc0e8ea6a1f
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJFNDNBOjJCRjNEMTo5NUY0ODQ6RDMxMkQ3OjZBRkI3MkNEIiwidmlzaXRvcl9pZCI6Ijc0NDcyMzExNjg1NzI1MTkxMTciLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmac63f37b186a3b5b88ed827289bc0499de59b87d54c30353e9e73213031f576320
hovercard-subject-tagpull_request:4383335123
github-keyboard-shortcutsrepository,pull-request-list,pull-request-conversation,pull-request-files-changed,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///pull_requests/show/files
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/simstudioai/sim/pull/7213/files
twitter:imagehttps://avatars.githubusercontent.com/u/40672544?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/40672544?s=400&v=4
og:image:altSummary CodeQL runs ~3,090 times a month and costs ~$382/mo across both languages. 90 of the last 100 PRs target staging, and every one of those is scanned again — against the exact tree being prom...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None0e29e7974fdda2feeaf5c891efd4b23b0734b23480232b62c7bdef13f40b5b48
turbo-cache-controlno-preview
diff-viewunified
go-importgithub.com/simstudioai/sim git https://github.com/simstudioai/sim.git
octolytics-dimension-user_id199344406
octolytics-dimension-user_loginsimstudioai
octolytics-dimension-repository_id912559512
octolytics-dimension-repository_nwosimstudioai/sim
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id912559512
octolytics-dimension-repository_network_root_nwosimstudioai/sim
turbo-body-classeslogged-out env-production page-responsive full-width
disable-turbotrue
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release2e8872b770cc4d5d0cc1f2026afab747a268e2ce
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/simstudioai/sim/pull/7213/files#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F7213%2Ffiles
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://github.com/security/advanced-security
Copilot for businessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F7213%2Ffiles
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fpull_requests%2Fshow%2Ffiles&source=header-repo&source_repo=simstudioai%2Fsim
Reloadhttps://github.com/simstudioai/sim/pull/7213/files
Reloadhttps://github.com/simstudioai/sim/pull/7213/files
Reloadhttps://github.com/simstudioai/sim/pull/7213/files
simstudioaihttps://github.com/simstudioai
simhttps://github.com/simstudioai/sim
Codehttps://github.com/simstudioai/sim
Issues129 (129)https://github.com/simstudioai/sim/issues
Pull requests199 (199)https://github.com/simstudioai/sim/pulls
Actionshttps://github.com/simstudioai/sim/actions
Projectshttps://github.com/simstudioai/sim/projects
Security and qualityhttps://github.com/simstudioai/sim/security
Insightshttps://github.com/simstudioai/sim/pulse
Sign up for GitHub https://github.com/signup?return_to=%2Fsimstudioai%2Fsim%2Fissues%2Fnew%2Fchoose
terms of servicehttps://docs.github.com/terms
privacy statementhttps://docs.github.com/privacy
Sign inhttps://github.com/login?return_to=%2Fsimstudioai%2Fsim%2Fissues%2Fnew%2Fchoose
waleedlatif1https://github.com/waleedlatif1
staginghttps://github.com/simstudioai/sim/tree/staging
ci/codeql-main-only-and-fresher-overlay-basehttps://github.com/simstudioai/sim/tree/ci/codeql-main-only-and-fresher-overlay-base
Conversation 4 https://github.com/simstudioai/sim/pull/7213
Commits 1 https://github.com/simstudioai/sim/pull/7213/commits
Checks 27 https://github.com/simstudioai/sim/pull/7213/checks
Files changed https://github.com/simstudioai/sim/pull/7213/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/7213/files
improvement(ci): scan CodeQL PRs at the promotion boundary, refresh main daily https://github.com/simstudioai/sim/pull/7213/files#top
Show all changes 1 commit https://github.com/simstudioai/sim/pull/7213/files
e38d287 improvement(ci): scan CodeQL PRs at the promotion boundary, refresh m… waleedlatif1 Aug 28, 2026 https://github.com/simstudioai/sim/pull/7213/commits/e38d287f8fa22fc3a8d3469a21114dd0f48c77c0
Clear filters https://github.com/simstudioai/sim/pull/7213/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/7213/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/7213/files
codeql-config.yml https://github.com/simstudioai/sim/pull/7213/files#diff-3c168dbb160e6a97e58e9babfc08dcd60f89cf2c81ff592398940c29e576b870
codeql.yml https://github.com/simstudioai/sim/pull/7213/files#diff-12783128521e452af0cfac94b99b8d250413c516ec71fe6d97dbea666ff7ba27
.github/codeql/codeql-config.ymlhttps://github.com/simstudioai/sim/pull/7213/files#diff-3c168dbb160e6a97e58e9babfc08dcd60f89cf2c81ff592398940c29e576b870
View file https://github.com/simstudioai/sim/blob/e38d287f8fa22fc3a8d3469a21114dd0f48c77c0/.github/codeql/codeql-config.yml
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/7213/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/7213/files#diff-3c168dbb160e6a97e58e9babfc08dcd60f89cf2c81ff592398940c29e576b870
.github/workflows/codeql.ymlhttps://github.com/simstudioai/sim/pull/7213/files#diff-12783128521e452af0cfac94b99b8d250413c516ec71fe6d97dbea666ff7ba27
View file https://github.com/simstudioai/sim/blob/e38d287f8fa22fc3a8d3469a21114dd0f48c77c0/.github/workflows/codeql.yml
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/7213/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/7213/files#diff-12783128521e452af0cfac94b99b8d250413c516ec71fe6d97dbea666ff7ba27
https://github.com/simstudioai/sim/pull/7213/files#diff-12783128521e452af0cfac94b99b8d250413c516ec71fe6d97dbea666ff7ba27
Please reload this pagehttps://github.com/simstudioai/sim/pull/7213/files
https://github.com/simstudioai/sim/pull/7213/files#diff-12783128521e452af0cfac94b99b8d250413c516ec71fe6d97dbea666ff7ba27
Please reload this pagehttps://github.com/simstudioai/sim/pull/7213/files
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.