René's URL Explorer Experiment


Title: fix(file-search): skip base64-dominated files and redact query errors from task failures by waleedlatif1 · Pull Request #8004 · simstudioai/sim · GitHub

Open Graph Title: fix(file-search): skip base64-dominated files and redact query errors from task failures by waleedlatif1 · Pull Request #8004 · simstudioai/sim

X Title: fix(file-search): skip base64-dominated files and redact query errors from task failures by waleedlatif1 · Pull Request #8004 · simstudioai/sim

Description: Summary Skip files whose text is mostly base64 payload (binaries stored as base64 text, SVGs embedding data URIs) as encoded_content before any chunks are written. A run counts only if it is 256+ unbroken base64-alphabet chars mixing upper case, lower case, and digits; the file is skipped when those runs are ≥50% of the text and >32 KiB. Small signatures, lockfile integrity hashes, hex digests, and DNA sequences stay searchable These files yield thousands of distinct rare trigrams per chunk, so their first 128 KiB direct GIN insert hit the 10s statement timeout on every attempt; skipped files also no longer count as failed coverage Task failures from a chunk query now throw failed ([, reason]) via a shared redactDatabaseQueryError helper — Drizzle's message carried the bound chunk text (file contents) into Trigger.dev and alerts Log insert batches that take ≥2s (including the one a timeout cancels) with rows, bytes, and estimated trigram keys, so a key-based batch budget can be sized from real timings. The estimator matches show_trgm exactly under en_US.UTF-8 and only runs for slow batches Encoded-run scan is a single linear pass (~250ms for a 24 MiB worst case vs up to ~6s with a backtracking regex) Type of Change Bug fix Testing Unit: file-search, core errors, and helper consumers (456 tests); verified new tests fail with each fix reverted Integration: chunks.integration.ts + dispatcher.integration.ts pass on PostgreSQL 16 and 17 Validated the skip rule against the content shape of the failing runs, and confirmed ordinary text, JSON, lockfiles, and small configs fall well below it bun run lint, block registry check, check:audits (47), docs-manifest:check, type-check 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 Skip files whose text is mostly base64 payload (binaries stored as base64 text, SVGs embedding data URIs) as encoded_content before any chunks are written. A run counts only if it is 256+ ...

X Description: Summary Skip files whose text is mostly base64 payload (binaries stored as base64 text, SVGs embedding data URIs) as encoded_content before any chunks are written. A run counts only if it is 256+ ...

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

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:43d555c7-599b-abbc-8edd-90fc2b4ccdc6
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idAB46:327CBE:D5D09B:12CF0A3:6AFB632C
html-safe-nonceeb88df9fda353ac5446c6be2f2c828398fce7c5c4097c7f2c166a4c22535541a
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBQjQ2OjMyN0NCRTpENUQwOUI6MTJDRjBBMzo2QUZCNjMyQyIsInZpc2l0b3JfaWQiOiI1NTk0MDkxMDY4Njc5MzgwOTIiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmac3cd183cc6eea7912dff9aa5fe7f0cb0adc17c4d7a46847c6f3503bb88b6af3fd
hovercard-subject-tagpull_request:4576068082
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/8004/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 Skip files whose text is mostly base64 payload (binaries stored as base64 text, SVGs embedding data URIs) as encoded_content before any chunks are written. A run counts only if it is 256+ ...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
Noneea33d13c96d0ff66bd8fa906b193d2213536b78cb06b0c50a4632c58b1418f94
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
release59ef97164c52cf59bd10558ddec9c4f482763988
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/simstudioai/sim/pull/8004/files#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F8004%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%2F8004%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/8004/files
Reloadhttps://github.com/simstudioai/sim/pull/8004/files
Reloadhttps://github.com/simstudioai/sim/pull/8004/files
simstudioaihttps://github.com/simstudioai
simhttps://github.com/simstudioai/sim
Codehttps://github.com/simstudioai/sim
Issues129 (129)https://github.com/simstudioai/sim/issues
Pull requests197 (197)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
fix/file-search-encoded-contenthttps://github.com/simstudioai/sim/tree/fix/file-search-encoded-content
Conversation 10 https://github.com/simstudioai/sim/pull/8004
Commits 2 https://github.com/simstudioai/sim/pull/8004/commits
Checks 33 https://github.com/simstudioai/sim/pull/8004/checks
Files changed https://github.com/simstudioai/sim/pull/8004/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/8004/files
fix(file-search): skip base64-dominated files and redact query errors from task failures https://github.com/simstudioai/sim/pull/8004/files#top
Show all changes 2 commits https://github.com/simstudioai/sim/pull/8004/files
8730368 fix(file-search): skip base64-dominated files and redact query errors… waleedlatif1 Sep 19, 2026 https://github.com/simstudioai/sim/pull/8004/commits/873036854d28726dc3fb4ea0266daa619e6f2ad4
0197fa4 fix(file-search): count wrapped base64 blocks and verify trigram esti… waleedlatif1 Sep 19, 2026 https://github.com/simstudioai/sim/pull/8004/commits/0197fa4cc4d1ed723df2446b1810d62f8f7e081c
Clear filters https://github.com/simstudioai/sim/pull/8004/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/8004/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/8004/files
test-build.yml https://github.com/simstudioai/sim/pull/8004/files#diff-a583f7935a5f3192471a2999cbf059eadc857228b5be2c7247f481b799949f8d
database-query-error.test.ts https://github.com/simstudioai/sim/pull/8004/files#diff-397ae91790e2485207cfac9bda78b8a7843884bf41c6ba927a61105dce61a7e4
database-query-error.ts https://github.com/simstudioai/sim/pull/8004/files#diff-cf6e94b59b4aee4f1da25a44f05ef7761fb17ce8ef29652f7d40941a1f51db20
README.md https://github.com/simstudioai/sim/pull/8004/files#diff-625b017042a1d9a671673d8b7077f6f7e4513b30970b08b008bf9fb670f641c4
constants.ts https://github.com/simstudioai/sim/pull/8004/files#diff-25abdafbc319ad195e37055eeebf63e23f0a8d6294ed87fbb6726afb3496a9eb
index-plan.integration.ts https://github.com/simstudioai/sim/pull/8004/files#diff-fb6927925929b7eeef1ba81d651d4047b35a35400a5a7c5d5205cadfebb212f9
index-plan.test.ts https://github.com/simstudioai/sim/pull/8004/files#diff-2920ce69cfbd2de0cb8b1dfbdf1d69cd587ee529fed7c514da8e775e25b3c88e
index-plan.ts https://github.com/simstudioai/sim/pull/8004/files#diff-7c97d743bbd496b0acf18e031c370f868e9b4754c1688753403888effda75135
indexing.test.ts https://github.com/simstudioai/sim/pull/8004/files#diff-c249013d04ffb4863b1d681bc0fe515b63b44d6e86e16132c190da22d25aef42
indexing.ts https://github.com/simstudioai/sim/pull/8004/files#diff-73f6acb47b67368aff1036891dee7569337b858f789f18a8d98a59eea79154f1
.github/workflows/test-build.ymlhttps://github.com/simstudioai/sim/pull/8004/files#diff-a583f7935a5f3192471a2999cbf059eadc857228b5be2c7247f481b799949f8d
View file https://github.com/simstudioai/sim/blob/0197fa4cc4d1ed723df2446b1810d62f8f7e081c/.github/workflows/test-build.yml
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/8004/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/8004/files#diff-a583f7935a5f3192471a2999cbf059eadc857228b5be2c7247f481b799949f8d
https://github.com/simstudioai/sim/pull/8004/files#diff-a583f7935a5f3192471a2999cbf059eadc857228b5be2c7247f481b799949f8d
apps/sim/lib/core/errors/database-query-error.test.tshttps://github.com/simstudioai/sim/pull/8004/files#diff-397ae91790e2485207cfac9bda78b8a7843884bf41c6ba927a61105dce61a7e4
View file https://github.com/simstudioai/sim/blob/0197fa4cc4d1ed723df2446b1810d62f8f7e081c/apps/sim/lib/core/errors/database-query-error.test.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/8004/{{ revealButtonHref }}
apps/sim/lib/core/errors/database-query-error.tshttps://github.com/simstudioai/sim/pull/8004/files#diff-cf6e94b59b4aee4f1da25a44f05ef7761fb17ce8ef29652f7d40941a1f51db20
View file https://github.com/simstudioai/sim/blob/0197fa4cc4d1ed723df2446b1810d62f8f7e081c/apps/sim/lib/core/errors/database-query-error.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/8004/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/8004/files#diff-cf6e94b59b4aee4f1da25a44f05ef7761fb17ce8ef29652f7d40941a1f51db20
apps/sim/lib/workspace-files/search/README.mdhttps://github.com/simstudioai/sim/pull/8004/files#diff-625b017042a1d9a671673d8b7077f6f7e4513b30970b08b008bf9fb670f641c4
View file https://github.com/simstudioai/sim/blob/0197fa4cc4d1ed723df2446b1810d62f8f7e081c/apps/sim/lib/workspace-files/search/README.md
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/8004/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/8004/files#diff-625b017042a1d9a671673d8b7077f6f7e4513b30970b08b008bf9fb670f641c4
https://github.com/simstudioai/sim/pull/8004/files#diff-625b017042a1d9a671673d8b7077f6f7e4513b30970b08b008bf9fb670f641c4
apps/sim/lib/workspace-files/search/constants.tshttps://github.com/simstudioai/sim/pull/8004/files#diff-25abdafbc319ad195e37055eeebf63e23f0a8d6294ed87fbb6726afb3496a9eb
View file https://github.com/simstudioai/sim/blob/0197fa4cc4d1ed723df2446b1810d62f8f7e081c/apps/sim/lib/workspace-files/search/constants.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/8004/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/8004/files#diff-25abdafbc319ad195e37055eeebf63e23f0a8d6294ed87fbb6726afb3496a9eb
https://github.com/simstudioai/sim/pull/8004/files#diff-25abdafbc319ad195e37055eeebf63e23f0a8d6294ed87fbb6726afb3496a9eb
https://github.com/simstudioai/sim/pull/8004/files#diff-25abdafbc319ad195e37055eeebf63e23f0a8d6294ed87fbb6726afb3496a9eb
https://github.com/simstudioai/sim/pull/8004/files#diff-25abdafbc319ad195e37055eeebf63e23f0a8d6294ed87fbb6726afb3496a9eb
apps/sim/lib/workspace-files/search/index-plan.integration.tshttps://github.com/simstudioai/sim/pull/8004/files#diff-fb6927925929b7eeef1ba81d651d4047b35a35400a5a7c5d5205cadfebb212f9
View file https://github.com/simstudioai/sim/blob/0197fa4cc4d1ed723df2446b1810d62f8f7e081c/apps/sim/lib/workspace-files/search/index-plan.integration.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/8004/{{ revealButtonHref }}
apps/sim/lib/workspace-files/search/index-plan.test.tshttps://github.com/simstudioai/sim/pull/8004/files#diff-2920ce69cfbd2de0cb8b1dfbdf1d69cd587ee529fed7c514da8e775e25b3c88e
View file https://github.com/simstudioai/sim/blob/0197fa4cc4d1ed723df2446b1810d62f8f7e081c/apps/sim/lib/workspace-files/search/index-plan.test.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/8004/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/8004/files#diff-2920ce69cfbd2de0cb8b1dfbdf1d69cd587ee529fed7c514da8e775e25b3c88e
https://github.com/simstudioai/sim/pull/8004/files#diff-2920ce69cfbd2de0cb8b1dfbdf1d69cd587ee529fed7c514da8e775e25b3c88e
Please reload this pagehttps://github.com/simstudioai/sim/pull/8004/files
https://github.com/simstudioai/sim/pull/8004/files#diff-2920ce69cfbd2de0cb8b1dfbdf1d69cd587ee529fed7c514da8e775e25b3c88e
apps/sim/lib/workspace-files/search/index-plan.tshttps://github.com/simstudioai/sim/pull/8004/files#diff-7c97d743bbd496b0acf18e031c370f868e9b4754c1688753403888effda75135
View file https://github.com/simstudioai/sim/blob/0197fa4cc4d1ed723df2446b1810d62f8f7e081c/apps/sim/lib/workspace-files/search/index-plan.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/8004/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/8004/files#diff-7c97d743bbd496b0acf18e031c370f868e9b4754c1688753403888effda75135
Please reload this pagehttps://github.com/simstudioai/sim/pull/8004/files
https://github.com/simstudioai/sim/pull/8004/files#diff-7c97d743bbd496b0acf18e031c370f868e9b4754c1688753403888effda75135
https://github.com/simstudioai/sim/pull/8004/files#diff-7c97d743bbd496b0acf18e031c370f868e9b4754c1688753403888effda75135
Please reload this pagehttps://github.com/simstudioai/sim/pull/8004/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/8004/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.