René's URL Explorer Experiment


Title: release: 1.40.1 by ysamcode · Pull Request #676 · ycode/ycode · GitHub

Open Graph Title: release: 1.40.1 by ysamcode · Pull Request #676 · ycode/ycode

X Title: release: 1.40.1 by ysamcode · Pull Request #676 · ycode/ycode

Description: Summary Release 1.40.1: published pages with CMS collections load far less data from the database. Values are read only for the items that actually render, link targets resolve with slug-only reads, and item values travel through a compressed RPC instead of uncompressed Postgres traffic. Changes Load collection item values only for rendered items; sort, filter and inverse-reference fields are loaded for all items up front (#673) Resolve CMS link targets and sitemap entries with slug-only reads instead of loading every field (#674) Read collection item values through the new get_collection_item_values SQL function over PostgREST, with fallback to the previous query path when the function is missing (#675) Test plan CI checks pass Migration 20261105000001_add_get_collection_item_values_function runs on upgrade A page with a collection list, a filtered list and a dynamic detail page renders identically to 1.40.0 Sitemap lists dynamic page URLs with the correct slugs

Open Graph Description: Summary Release 1.40.1: published pages with CMS collections load far less data from the database. Values are read only for the items that actually render, link targets resolve with slug-only reads...

X Description: Summary Release 1.40.1: published pages with CMS collections load far less data from the database. Values are read only for the items that actually render, link targets resolve with slug-only reads...

Opengraph URL: https://github.com/ycode/ycode/pull/676

X: @github

direct link

Domain: github.com

react-profiling0
react-import-mapreact,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322
route-pattern/:user_id/:repository/pull/:id/files(.:format)
route-controllerpull_requests
route-actionfiles
fetch-noncev2:fe947c56-7470-c509-1417-62f582394070
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idD342:A412F:162ECD:1CE222:6AFE35A8
html-safe-nonced4b96a886d21ac469647b3ebe900e093caf6fb569a518cba977b1884b0dc223f
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJEMzQyOkE0MTJGOjE2MkVDRDoxQ0UyMjI6NkFGRTM1QTgiLCJ2aXNpdG9yX2lkIjoiMTA5NTczMzcyOTA5Mjg0MjkyMCIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmacab4460492c6c56494b0d5de06992de5375d8ccc40b9e898bd4f42d3ce210b816
hovercard-subject-tagpull_request:5173601912
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/ycode/ycode/pull/676/files
twitter:imagehttps://avatars.githubusercontent.com/u/7631193?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/7631193?s=400&v=4
og:image:altSummary Release 1.40.1: published pages with CMS collections load far less data from the database. Values are read only for the items that actually render, link targets resolve with slug-only reads...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None260deedcf4630abb0a6b4aaa02fd2af70eab44d2529712694ceae59ca131b02e
turbo-cache-controlno-preview
diff-viewunified
go-importgithub.com/ycode/ycode git https://github.com/ycode/ycode.git
octolytics-dimension-user_id65892203
octolytics-dimension-user_loginycode
octolytics-dimension-repository_id1165452593
octolytics-dimension-repository_nwoycode/ycode
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id1165452593
octolytics-dimension-repository_network_root_nwoycode/ycode
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
release8b413ea7a9b010f4f2ebbb923b041b0d6091dd94
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/ycode/ycode/pull/676/files#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fycode%2Fycode%2Fpull%2F676%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%2Fycode%2Fycode%2Fpull%2F676%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=ycode%2Fycode
Reloadhttps://github.com/ycode/ycode/pull/676/files
Reloadhttps://github.com/ycode/ycode/pull/676/files
Reloadhttps://github.com/ycode/ycode/pull/676/files
ycodehttps://github.com/ycode
ycodehttps://github.com/ycode/ycode
Codehttps://github.com/ycode/ycode
Issues7 (7)https://github.com/ycode/ycode/issues
Pull requests1 (1)https://github.com/ycode/ycode/pulls
Discussionshttps://github.com/ycode/ycode/discussions
Actionshttps://github.com/ycode/ycode/actions
Projectshttps://github.com/ycode/ycode/projects
Security and quality1 (1)https://github.com/ycode/ycode/security
Insightshttps://github.com/ycode/ycode/insights
Sign up for GitHub https://github.com/signup?return_to=%2Fycode%2Fycode%2Fissues%2Fnew%2Fchoose
terms of servicehttps://docs.github.com/terms
privacy statementhttps://docs.github.com/privacy
Sign inhttps://github.com/login?return_to=%2Fycode%2Fycode%2Fissues%2Fnew%2Fchoose
ysamcodehttps://github.com/ysamcode
mainhttps://github.com/ycode/ycode/tree/main
develophttps://github.com/ycode/ycode/tree/develop
Conversation 0 https://github.com/ycode/ycode/pull/676
Commits 7 https://github.com/ycode/ycode/pull/676/commits
Checks 0 https://github.com/ycode/ycode/pull/676/checks
Files changed https://github.com/ycode/ycode/pull/676/files
Please reload this pagehttps://github.com/ycode/ycode/pull/676/files
release: 1.40.1 https://github.com/ycode/ycode/pull/676/files#top
Show all changes 7 commits https://github.com/ycode/ycode/pull/676/files
153ab3d perf: load CMS values only for rendered collection items ysamcode Nov 5, 2026 https://github.com/ycode/ycode/pull/676/commits/153ab3ddf5f336b53558226eff5b0d385c116ab8
9e3bf75 Merge pull request #673 from ycode/perf/lazy-collection-values ysamcode Nov 5, 2026 https://github.com/ycode/ycode/pull/676/commits/9e3bf755dffaa75e4ce01d3ca042de5ab5b560c2
f07910e perf: read only slugs when resolving CMS link targets ysamcode Nov 5, 2026 https://github.com/ycode/ycode/pull/676/commits/f07910e1713f56bc8ec0adafdbac281ee8e904f5
21e134c Merge pull request #674 from ycode/perf/slug-only-collection-reads ysamcode Nov 5, 2026 https://github.com/ycode/ycode/pull/676/commits/21e134cc5c2fe42243cca4217dea18182acdd57b
4a06c13 perf: read collection item values through a gzipped RPC ysamcode Nov 5, 2026 https://github.com/ycode/ycode/pull/676/commits/4a06c13af83e795c76e280d795e8c9dbcab7ab24
2bff268 Merge pull request #675 from ycode/perf/item-values-rpc ysamcode Nov 5, 2026 https://github.com/ycode/ycode/pull/676/commits/2bff268eaa0766bbc53ad1ab910ba69f90b9b57d
55499b3 chore: bump version to 1.40.1 ysamcode Nov 5, 2026 https://github.com/ycode/ycode/pull/676/commits/55499b32d1d4b142754b52462a8cff39c556c724
Clear filters https://github.com/ycode/ycode/pull/676/files
Please reload this pagehttps://github.com/ycode/ycode/pull/676/files
Please reload this pagehttps://github.com/ycode/ycode/pull/676/files
route.ts https://github.com/ycode/ycode/pull/676/files#diff-91706a7c3324413bff696b8b9cdfc52a313318c84f397404eed6c872b7b94050
PageRenderer.tsx https://github.com/ycode/ycode/pull/676/files#diff-fd744ab1e8621b1ead61c31be2c1ee564e0ec2f132090b9347bf922e9200e583
20261105000001_add_get_collection_item_values_function.ts https://github.com/ycode/ycode/pull/676/files#diff-49ec2a533da65dad426db24769f8a0490838d393f0c49957a19f3bf431d4c5bb
page-fetcher.ts https://github.com/ycode/ycode/pull/676/files#diff-28e0b23fdbe1ae4953b860f3213a935ad8d5a4c9102c3ac6180a859ae29b3f99
collectionItemRepository.ts https://github.com/ycode/ycode/pull/676/files#diff-e1156a27855a2afc9cadcaffa57e96a15a02d9485e232929aa3bd2b35b8fc00b
collectionItemValueRepository.ts https://github.com/ycode/ycode/pull/676/files#diff-c0312f4a8df04e06b9c4a0c0ce1fcd4ae6804e84991063b6f73f36488af4125c
package-lock.json https://github.com/ycode/ycode/pull/676/files#diff-053150b640a7ce75eff69d1a22cae7f0f94ad64ce9a855db544dda0929316519
package.json https://github.com/ycode/ycode/pull/676/files#diff-7ae45ad102eab3b6d7e7896acd08c427a9b25b346470d7bc6507b6481575d519
https://github.com/ycode/ycode/blob/main/.github/CODEOWNERS#L1
app/(site)/sitemap.xml/route.tshttps://github.com/ycode/ycode/pull/676/files#diff-91706a7c3324413bff696b8b9cdfc52a313318c84f397404eed6c872b7b94050
View file https://github.com/ycode/ycode/blob/55499b32d1d4b142754b52462a8cff39c556c724/app/(site)/sitemap.xml/route.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/ycode/ycode/pull/676/{{ revealButtonHref }}
https://github.com/ycode/ycode/pull/676/files#diff-91706a7c3324413bff696b8b9cdfc52a313318c84f397404eed6c872b7b94050
https://github.com/ycode/ycode/pull/676/files#diff-91706a7c3324413bff696b8b9cdfc52a313318c84f397404eed6c872b7b94050
https://github.com/ycode/ycode/blob/main/.github/CODEOWNERS#L1
components/PageRenderer.tsxhttps://github.com/ycode/ycode/pull/676/files#diff-fd744ab1e8621b1ead61c31be2c1ee564e0ec2f132090b9347bf922e9200e583
View file https://github.com/ycode/ycode/blob/55499b32d1d4b142754b52462a8cff39c556c724/components/PageRenderer.tsx
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/ycode/ycode/pull/676/{{ revealButtonHref }}
https://github.com/ycode/ycode/pull/676/files#diff-fd744ab1e8621b1ead61c31be2c1ee564e0ec2f132090b9347bf922e9200e583
https://github.com/ycode/ycode/pull/676/files#diff-fd744ab1e8621b1ead61c31be2c1ee564e0ec2f132090b9347bf922e9200e583
https://github.com/ycode/ycode/pull/676/files#diff-fd744ab1e8621b1ead61c31be2c1ee564e0ec2f132090b9347bf922e9200e583
https://github.com/ycode/ycode/pull/676/files#diff-fd744ab1e8621b1ead61c31be2c1ee564e0ec2f132090b9347bf922e9200e583
https://github.com/ycode/ycode/pull/676/files#diff-fd744ab1e8621b1ead61c31be2c1ee564e0ec2f132090b9347bf922e9200e583
https://github.com/ycode/ycode/blob/main/.github/CODEOWNERS#L1
database/migrations/20261105000001_add_get_collection_item_values_function.tshttps://github.com/ycode/ycode/pull/676/files#diff-49ec2a533da65dad426db24769f8a0490838d393f0c49957a19f3bf431d4c5bb
View file https://github.com/ycode/ycode/blob/55499b32d1d4b142754b52462a8cff39c556c724/database/migrations/20261105000001_add_get_collection_item_values_function.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/ycode/ycode/pull/676/{{ revealButtonHref }}
https://github.com/ycode/ycode/blob/main/.github/CODEOWNERS#L1
lib/page-fetcher.tshttps://github.com/ycode/ycode/pull/676/files#diff-28e0b23fdbe1ae4953b860f3213a935ad8d5a4c9102c3ac6180a859ae29b3f99
View file https://github.com/ycode/ycode/blob/55499b32d1d4b142754b52462a8cff39c556c724/lib/page-fetcher.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/ycode/ycode/pull/676/{{ revealButtonHref }}
https://github.com/ycode/ycode/pull/676/files#diff-28e0b23fdbe1ae4953b860f3213a935ad8d5a4c9102c3ac6180a859ae29b3f99
https://github.com/ycode/ycode/pull/676/files#diff-28e0b23fdbe1ae4953b860f3213a935ad8d5a4c9102c3ac6180a859ae29b3f99
https://github.com/ycode/ycode/pull/676/files#diff-28e0b23fdbe1ae4953b860f3213a935ad8d5a4c9102c3ac6180a859ae29b3f99
https://github.com/ycode/ycode/pull/676/files#diff-28e0b23fdbe1ae4953b860f3213a935ad8d5a4c9102c3ac6180a859ae29b3f99
https://github.com/ycode/ycode/pull/676/files#diff-28e0b23fdbe1ae4953b860f3213a935ad8d5a4c9102c3ac6180a859ae29b3f99
https://github.com/ycode/ycode/pull/676/files#diff-28e0b23fdbe1ae4953b860f3213a935ad8d5a4c9102c3ac6180a859ae29b3f99
https://github.com/ycode/ycode/pull/676/files#diff-28e0b23fdbe1ae4953b860f3213a935ad8d5a4c9102c3ac6180a859ae29b3f99
https://github.com/ycode/ycode/pull/676/files#diff-28e0b23fdbe1ae4953b860f3213a935ad8d5a4c9102c3ac6180a859ae29b3f99
https://github.com/ycode/ycode/pull/676/files#diff-28e0b23fdbe1ae4953b860f3213a935ad8d5a4c9102c3ac6180a859ae29b3f99
https://github.com/ycode/ycode/pull/676/files#diff-28e0b23fdbe1ae4953b860f3213a935ad8d5a4c9102c3ac6180a859ae29b3f99
https://github.com/ycode/ycode/pull/676/files#diff-28e0b23fdbe1ae4953b860f3213a935ad8d5a4c9102c3ac6180a859ae29b3f99
https://github.com/ycode/ycode/pull/676/files#diff-28e0b23fdbe1ae4953b860f3213a935ad8d5a4c9102c3ac6180a859ae29b3f99
https://github.com/ycode/ycode/pull/676/files#diff-28e0b23fdbe1ae4953b860f3213a935ad8d5a4c9102c3ac6180a859ae29b3f99
https://github.com/ycode/ycode/pull/676/files#diff-28e0b23fdbe1ae4953b860f3213a935ad8d5a4c9102c3ac6180a859ae29b3f99
https://github.com/ycode/ycode/pull/676/files#diff-28e0b23fdbe1ae4953b860f3213a935ad8d5a4c9102c3ac6180a859ae29b3f99
https://github.com/ycode/ycode/pull/676/files#diff-28e0b23fdbe1ae4953b860f3213a935ad8d5a4c9102c3ac6180a859ae29b3f99
https://github.com/ycode/ycode/pull/676/files#diff-28e0b23fdbe1ae4953b860f3213a935ad8d5a4c9102c3ac6180a859ae29b3f99
https://github.com/ycode/ycode/pull/676/files#diff-28e0b23fdbe1ae4953b860f3213a935ad8d5a4c9102c3ac6180a859ae29b3f99
https://github.com/ycode/ycode/pull/676/files#diff-28e0b23fdbe1ae4953b860f3213a935ad8d5a4c9102c3ac6180a859ae29b3f99
https://github.com/ycode/ycode/pull/676/files#diff-28e0b23fdbe1ae4953b860f3213a935ad8d5a4c9102c3ac6180a859ae29b3f99
https://github.com/ycode/ycode/pull/676/files#diff-28e0b23fdbe1ae4953b860f3213a935ad8d5a4c9102c3ac6180a859ae29b3f99
https://github.com/ycode/ycode/pull/676/files#diff-28e0b23fdbe1ae4953b860f3213a935ad8d5a4c9102c3ac6180a859ae29b3f99
Please reload this pagehttps://github.com/ycode/ycode/pull/676/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.