René's URL Explorer Experiment


Title: perf(db): cut hot-path database work and close copilot cleanup gaps by waleedlatif1 · Pull Request #9419 · simstudioai/sim · GitHub

Open Graph Title: perf(db): cut hot-path database work and close copilot cleanup gaps by waleedlatif1 · Pull Request #9419 · simstudioai/sim

X Title: perf(db): cut hot-path database work and close copilot cleanup gaps by waleedlatif1 · Pull Request #9419 · simstudioai/sim

Description: Summary Cuts Sim's heaviest database work and closes cleanup gaps. Each change was checked against production query statistics and plans first; reads return the same results as before. Billing New usage_log_billing_entity_period_cost_idx (migration 0441) leads with both period stamps and carries the summed columns, so the billing-period sums and weekly refresh become index-only; it replaces two indexes (the old covering index lost to the slim one on column order and a misestimate) Member removal revoked sessions (an organization row write) before locking the org's workspaces, the reverse of the storage writers' workspace-then-organization order, which deadlocked; revocation now runs after the handoff holds the workspace rows Hot reads The deployed-state read withholds the state blob when this process already caches that version (one round trip either way) Audit-log lists read each scope branch through its keyset index and merge, instead of an OR the planner could only seq-scan; the cursor is a row comparison Table-row mutations fetch only their workspace's table triggers instead of every workspace's Files and knowledge Workspace list invalidation broadcasts coalesce per tab while a refetch is in flight, so an upload burst no longer refetches the full list once per upload per viewer The file-search backfill locks only the files it seeds, not every row it walks (its owner trigger was locking each one) Completed-listing reconciliation counts window by window under the lease, so a large connector's count can't hit the statement timeout Cleanup Hard-deleting a copilot chat records its copilot backend and stored-file purge in the same transaction as the delete (outbox event, retried until it succeeds) Account removal records the same purge for the chats it cascades away inside its transaction; admin user removal queues it, delayed, before the delete and refuses the removal if it can't Outbox retention prunes completed checkpoint-expiry, file, memory and chat cleanup events; events read back by id are kept Idempotency cleanup drops four full-table stat scans and resumes each batch where the last ended instead of rewalking from the oldest key Schema (migration 0440) Drops 32 indexes that a valid, unpredicated b-tree leads with the same columns (never unique or constraint-backing); checked against index usage on the primary and both replicas Vacuums embedding, workspace_files and copilot_async_tool_calls at 2% dead/inserted instead of 20% Type of Change Bug fix Other: performance Testing Unit: 20 apps/sim files (333 tests) plus packages/audit rollup tests Integration: 43 files (661 pass, 2 skipped) against a freshly migrated database (0440 and 0441 applied) and a private Redis, including new suites for the lock order, deployed-state reads, audit-log scope paging, table triggers, chat backend cleanup, outbox retention, idempotency cleanup, file-search backfill and windowed counts; each new regression test fails on the pre-fix code 0441 replay verified: a valid index is kept, an invalid one is moved aside and rebuilt, an unexpected valid recovery index refuses bun run check:migrations origin/staging, drizzle-kit generate (no changes), schema mock, Phase A generators (no changes), bun run lint, block registry, bun run check:audits (61), bun run type-check The full bun run test runs in CI Checklist Code follows project style guidelines Self-reviewed my changes Tests added/updated and passing (new tests pass the test-audit authoring gate) 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 Cuts Sim's heaviest database work and closes cleanup gaps. Each change was checked against production query statistics and plans first; reads return the same results as before. Billing ...

X Description: Summary Cuts Sim's heaviest database work and closes cleanup gaps. Each change was checked against production query statistics and plans first; reads return the same results as before. Bill...

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

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:f2bd44f8-bb30-e156-cd2f-2f816f88abc1
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idB0B6:20420B:B70EF:10C377:6AFB0C09
html-safe-nonce3c8f52aa1277a5af87ee5c69fb79253aa7301acb66c4a0eb53bdf7cec05d79d1
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCMEI2OjIwNDIwQjpCNzBFRjoxMEMzNzc6NkFGQjBDMDkiLCJ2aXNpdG9yX2lkIjoiNDUzMTQwMzQ0Nzg0ODM0MDQ4OSIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmac17f2ce7104d6e424a833ffd801c0d2bb8bb1e81e79a8565fc93c39b80b91c0cd
hovercard-subject-tagpull_request:5057563490
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/9419/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 Cuts Sim's heaviest database work and closes cleanup gaps. Each change was checked against production query statistics and plans first; reads return the same results as before. Billing ...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None4275ec98d19a530a209480d02854be81de24ad5a05b648333242fc516bfb573c
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
releaseba13208acc32a4e7a4a3b54cb2f0dea6001ba5f8
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/simstudioai/sim/pull/9419/files#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F9419%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%2F9419%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/9419/files
Reloadhttps://github.com/simstudioai/sim/pull/9419/files
Reloadhttps://github.com/simstudioai/sim/pull/9419/files
simstudioaihttps://github.com/simstudioai
simhttps://github.com/simstudioai/sim
Codehttps://github.com/simstudioai/sim
Issues129 (129)https://github.com/simstudioai/sim/issues
Pull requests198 (198)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
perf/db-hot-pathshttps://github.com/simstudioai/sim/tree/perf/db-hot-paths
Conversation 45 https://github.com/simstudioai/sim/pull/9419
Commits 24 https://github.com/simstudioai/sim/pull/9419/commits
Checks 67 https://github.com/simstudioai/sim/pull/9419/checks
Files changed https://github.com/simstudioai/sim/pull/9419/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/9419/files
perf(db): cut hot-path database work and close copilot cleanup gaps https://github.com/simstudioai/sim/pull/9419/files#top
Show all changes 24 commits https://github.com/simstudioai/sim/pull/9419/files
5c99b5b fix(billing): revoke a removed member's sessions after the workspace … waleedlatif1 Oct 28, 2026 https://github.com/simstudioai/sim/pull/9419/commits/5c99b5bc120a37480006dce98a243cf4995665c5
c921209 perf(billing): admit wand and chat-title model calls through the usag… waleedlatif1 Oct 28, 2026 https://github.com/simstudioai/sim/pull/9419/commits/c9212090d62349ff1458cbf812760ee3f7abd869
265cace perf(workflows): withhold the deployed state blob when this process a… waleedlatif1 Oct 28, 2026 https://github.com/simstudioai/sim/pull/9419/commits/265cacef4269c7a480f5cd61c8d8778f2ff71b68
152f5b8 perf(audit-logs): read each scope branch through its keyset index waleedlatif1 Oct 28, 2026 https://github.com/simstudioai/sim/pull/9419/commits/152f5b824f03953c5a61eb428a88a51113169f08
f3f57b9 perf(tables): fetch only the mutated workspace's table triggers waleedlatif1 Oct 28, 2026 https://github.com/simstudioai/sim/pull/9419/commits/f3f57b990b6e0a9b7d9d3f5307b8bc65dd0e1b45
03ca9c5 perf(audit): hold a run's rollups for a minute instead of two seconds waleedlatif1 Oct 28, 2026 https://github.com/simstudioai/sim/pull/9419/commits/03ca9c53f00c9cf00bd801d243e64443ca051441
c25eab5 perf(file-search): lock only the files a backfill page actually seeds waleedlatif1 Oct 28, 2026 https://github.com/simstudioai/sim/pull/9419/commits/c25eab556c58eede70bb8591a6b8671f2d39f2a3
0fe0140 perf(knowledge): count a completed listing window by window waleedlatif1 Oct 28, 2026 https://github.com/simstudioai/sim/pull/9419/commits/0fe01409d2d4e958d425c58b0306470158cfdfd4
120b887 perf(files): coalesce workspace list invalidation broadcasts per tab waleedlatif1 Oct 28, 2026 https://github.com/simstudioai/sim/pull/9419/commits/120b88703c572c81d33536f66df7c8a801c5845b
ca8dd7e fix(copilot): purge the copilot backend and stored files when a chat … waleedlatif1 Oct 28, 2026 https://github.com/simstudioai/sim/pull/9419/commits/ca8dd7e7642c47be40d827702faafcbabdf2f8a6
f40a58e fix(copilot): queue copilot backend cleanup for chats an account remo… waleedlatif1 Oct 28, 2026 https://github.com/simstudioai/sim/pull/9419/commits/f40a58e94930e43dd6f06da87eb4c94e2fedc4c0
ab4448f improvement(outbox): prune completed checkpoint expiry, file, memory … waleedlatif1 Oct 28, 2026 https://github.com/simstudioai/sim/pull/9419/commits/ab4448f3e0b464b87ded6e8b6e638d4072d11d4f
81c750d perf(idempotency): drop the full-table stat scans and resume each cle… waleedlatif1 Oct 28, 2026 https://github.com/simstudioai/sim/pull/9419/commits/81c750d01686cba3b36f2f3c765c062a664d41c0
f35d8ce perf(db): drop prefix-covered indexes and vacuum churn-heavy tables s… waleedlatif1 Oct 28, 2026 https://github.com/simstudioai/sim/pull/9419/commits/f35d8ce70e207c081cd8252255e2ee7f828a0d87
2d4a0dd perf(db): cover usage_log period sums with one index led by both peri… waleedlatif1 Oct 28, 2026 https://github.com/simstudioai/sim/pull/9419/commits/2d4a0dd6a27bfae1a0f4288ac4cea1e046985000
da014cb chore(outbox): read the retention suite's database through a typed ha… waleedlatif1 Oct 28, 2026 https://github.com/simstudioai/sim/pull/9419/commits/da014cbc761f9e93a1d51943061c748b5346c162
405d5f6 improvement(files): drop the unobserved folder-tree room callback mem… waleedlatif1 Oct 28, 2026 https://github.com/simstudioai/sim/pull/9419/commits/405d5f622cde6998764bd97c21cbd80e26b72a23
0c59866 revert(billing): read the usage gate fresh for wand and chat-title mo… waleedlatif1 Oct 28, 2026 https://github.com/simstudioai/sim/pull/9419/commits/0c598668e3bd3c65ad2879aa6ef476b659b1ee6e
bde298c fix(copilot): record a deleted chat's backend and file purge durably … waleedlatif1 Oct 28, 2026 https://github.com/simstudioai/sim/pull/9419/commits/bde298c237133127c1eb37855823478211ca18f3
7118509 docs(knowledge): say what the windowed reconciliation counts do and d… waleedlatif1 Oct 28, 2026 https://github.com/simstudioai/sim/pull/9419/commits/71185092e486e2e0daf51934c7d13e635dd072ad
99c0777 chore(copilot): prove the cleanup rollback tests fail on the fixture … waleedlatif1 Oct 28, 2026 https://github.com/simstudioai/sim/pull/9419/commits/99c077748c6b2813ae2eb131ac286632bf004bd8
6e714dc docs(auth): state what the admin removal cleanup hook cannot cover waleedlatif1 Oct 28, 2026 https://github.com/simstudioai/sim/pull/9419/commits/6e714dc94619d1bb903d9da4f543462de0482759
d299e7b revert(audit): keep a run's rollup window at two seconds waleedlatif1 Oct 28, 2026 https://github.com/simstudioai/sim/pull/9419/commits/d299e7b08b8d9a89fb2a7d8ca3b738f19a07147b
aa7dc4e perf(billing): bound cycle close's previous-period lookup below the e… waleedlatif1 Oct 28, 2026 https://github.com/simstudioai/sim/pull/9419/commits/aa7dc4ebd723bf9ca534b807c8fdde29efed3a07
Clear filters https://github.com/simstudioai/sim/pull/9419/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/9419/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/9419/files
route.ts https://github.com/simstudioai/sim/pull/9419/files#diff-84bad28ae7d475877f9a7c6f1b58d0455aea329b1502b87285d4966b73b406f5
route.ts https://github.com/simstudioai/sim/pull/9419/files#diff-0f0112e42bccf0f471c8692ed2ad13b101297d42dac545370bd28371b0c8d04c
use-workspace-files-room.ts https://github.com/simstudioai/sim/pull/9419/files#diff-141bf4f4babf802e435a0b949cd4187dc1d64cd3c6ebc6fc845d49fc98cf8faf
use-workspace-invalidation-room.test.tsx https://github.com/simstudioai/sim/pull/9419/files#diff-997df809130965439a3ac53e312520ed3e217519163e0ae0e8eda7eacb62c595
use-workspace-invalidation-room.ts https://github.com/simstudioai/sim/pull/9419/files#diff-43dfa92b9c4c98254a9a5ae64e63426d7b07cdaab271a1248ffadb2c7a3e4eca
use-resource-folders.ts https://github.com/simstudioai/sim/pull/9419/files#diff-477337b8bb94cc618cb3627f18bce4b689d1eac35d71ca25ee62a38e64d1399e
cleanup-soft-deletes.test.ts https://github.com/simstudioai/sim/pull/9419/files#diff-7e22c35b1e0f894a4804c728a349279bf85c81dc84d790ce61e3fa8af30c66ea
cleanup-tasks.test.ts https://github.com/simstudioai/sim/pull/9419/files#diff-18b439b6c40a67976e3f3ff8efcc058357cdc5f3fd9c500b63a74dd8dcaeb603
workspace-file-folders.ts https://github.com/simstudioai/sim/pull/9419/files#diff-7f919b42006635de731f24e6cc0cbff144fc0d0dd583db6010e20006d742099b
export-audit-logs.ts https://github.com/simstudioai/sim/pull/9419/files#diff-c2223cc8d1d51821d060888c652c271bc077741e79d8eafbb1e9d375abc3e531
list-audit-logs.ts https://github.com/simstudioai/sim/pull/9419/files#diff-dc4565161762474880ce323e137bca3a2302cf4312756c865f2224a71b0a0d87
list-scope.integration.ts https://github.com/simstudioai/sim/pull/9419/files#diff-7bdfdfcda5afd5cb85ffcec8ee6ec19df358afdbcdb3157df6efb690cd99736f
query.integration.ts https://github.com/simstudioai/sim/pull/9419/files#diff-17a8dec1990eed9078d3b4d6c9f37de98f6726c5e8a1b03658c1f274345062a4
query.ts https://github.com/simstudioai/sim/pull/9419/files#diff-aaa2119362c512970c462bfb742bb07aede57d4c2a54911fc17fa26ed4f82800
admin-removal-chat-cleanup.ts https://github.com/simstudioai/sim/pull/9419/files#diff-f1a985db97fd34145421f3a71b4a95dadc1d888e874534e4e31d72a334fcd75b
auth.ts https://github.com/simstudioai/sim/pull/9419/files#diff-1196450729bfda994f3823921eacd28e3200408dbb562d8481108db9abe4a0e2
cycle-close.ts https://github.com/simstudioai/sim/pull/9419/files#diff-1573d069352d91221b13ba135abb1eb1cb348fe2c573cd534338339f452ed27b
membership-removal-lock-order.integration.ts https://github.com/simstudioai/sim/pull/9419/files#diff-172ee76969af4e4c7bfb9ac7e1c0c0cd01d7f6f64d6d84a50b09d341a3fe133a
membership.ts https://github.com/simstudioai/sim/pull/9419/files#diff-35d231c60e4149571281467f303ecee4907da4dd3f21df2f5d39bdf687fdd9e6
chat-backend-cleanup-event.ts https://github.com/simstudioai/sim/pull/9419/files#diff-cdb9a8b124154654cf0d34cd27071878eb605e8c42e6215b6132845933a7c7c3
chat-backend-cleanup-outbox.ts https://github.com/simstudioai/sim/pull/9419/files#diff-36f71b7d44162205ab00b2fc1111e08cf046fccae869f085a93bc4165b63cbe5
chat-backend-cleanup.integration.ts https://github.com/simstudioai/sim/pull/9419/files#diff-80919c2f0e0420bf0165090a88845ac4b350898167f879d9723dfdb8d496e7b5
chat-backend-cleanup.ts https://github.com/simstudioai/sim/pull/9419/files#diff-449a8e9d340342c421b9b1a5d41229a5e7d54e3493259facf96d1349e01985d1
chat-cleanup.integration.ts https://github.com/simstudioai/sim/pull/9419/files#diff-8ef3c119bdf703fcc0ad8c06ad21aca279abc4d19de7c63272340ddbe1193fe6
chat-cleanup.ts https://github.com/simstudioai/sim/pull/9419/files#diff-5f80865555d40f6c376c0d53f72944d721b340b03cf01b8f43a0d41fb28640e3
chat-files.ts https://github.com/simstudioai/sim/pull/9419/files#diff-6b3ff918d7fe2c5f1892a0b76b0738bbb914f036b36ff9b2b3449d6782b846aa
cleanup.integration.ts https://github.com/simstudioai/sim/pull/9419/files#diff-942cd144e2f42008dc28db00b47d31ff843e37457a37c571e5dc0e29800eddc5
cleanup.ts https://github.com/simstudioai/sim/pull/9419/files#diff-489c0e426c5f93b91d119e470268d9cc2abd20bcd9f353746c319951d6d03136
handlers.ts https://github.com/simstudioai/sim/pull/9419/files#diff-61deec24805d0e76abf8b08fc79ea963d8150e03c963cedf7d7e74fe675053fe
retention.integration.ts https://github.com/simstudioai/sim/pull/9419/files#diff-7fe62c4d9902e8682974fa0a8549bd61d72ef2a1b16150703434d14b57dc4c63
retention.ts https://github.com/simstudioai/sim/pull/9419/files#diff-219895d477156c3abd1a7c8521715724e5f3aeffa28ebe8608168700a9014502
listing-continuation.integration.ts https://github.com/simstudioai/sim/pull/9419/files#diff-e0cfe9e757a63c3c668fa797a9a26e31db2e1773cbbedf4f4ee7066714447105
member-sync-engine-content-credential.test.ts https://github.com/simstudioai/sim/pull/9419/files#diff-40f1876e4f1f511d3de4d450ad9f97ffb6d2b500a4017fab27b899af27484d57
reconciliation-window.test-helpers.ts https://github.com/simstudioai/sim/pull/9419/files#diff-282d1098b5c70b8070973c142c45337e07a924f7968c290f485228dba6fbbf8c
reconciliation-window.test.ts https://github.com/simstudioai/sim/pull/9419/files#diff-9ab666c3026278a7667792073aadc9403cf860f94e4c70eb95fd67e3b348d45d
reconciliation-window.ts https://github.com/simstudioai/sim/pull/9419/files#diff-a397298150e20079f419649d2cd5491b535ffde39ab744149eea033f5e8455e4
sync-content-pass.test.ts https://github.com/simstudioai/sim/pull/9419/files#diff-8d35d55800e2821b9e7cd19c76e2db80b43c20e2e53ab4485115f2abfd24d5d7
sync-content-pass.ts https://github.com/simstudioai/sim/pull/9419/files#diff-b6bd8cd1ab36d6b8e1b29f63847ffc4e4ee912f70e19de773896d753cc73d866
sync-engine.test.ts https://github.com/simstudioai/sim/pull/9419/files#diff-021afebf7e100833ecdc940e307263436964ce85ef3dfd40fc90307a1d115534
deletion.ts https://github.com/simstudioai/sim/pull/9419/files#diff-cce3d23da67a40c18396d133e3a96ab5466c47dc391cc642d537e47ef8ba6e8f
resource-cleanup.test.ts https://github.com/simstudioai/sim/pull/9419/files#diff-0e890e04ef8397968539a9e0c1ed0a2b6d4369097ad3d26d851a82d101d45951
trigger.ts https://github.com/simstudioai/sim/pull/9419/files#diff-9f55fbdc1a1fc17cdf6207d6edb8cc18712ba68b6a3f1530ea0be00c91a4c711
account-deletion.ts https://github.com/simstudioai/sim/pull/9419/files#diff-0ad7b582145ede5bc28a9b4d0fdc670303e35dfff9f0be64a9750358c65b509b
active-webhooks.integration.ts https://github.com/simstudioai/sim/pull/9419/files#diff-464a4fc8207241ec61871f7a06c01b140c3cc4ebbda81798d0467fc2811cd037
utils.ts https://github.com/simstudioai/sim/pull/9419/files#diff-97a976801cb3ed8cd1194f5c2bb13175dcd1aaf629f9d5f6ff9f978ccf3303b8
deployed-state-read.integration.ts https://github.com/simstudioai/sim/pull/9419/files#diff-064639463125f88a400e8d84c1dc8b7c5c4d0503ed56de2ac671b1ddbba77495
utils.ts https://github.com/simstudioai/sim/pull/9419/files#diff-b723bb650a6d3c96289fdf891fc363d5311c841ed15ffa4aa4ef963d1fa52227
README.md https://github.com/simstudioai/sim/pull/9419/files#diff-625b017042a1d9a671673d8b7077f6f7e4513b30970b08b008bf9fb670f641c4
dispatcher.integration.ts https://github.com/simstudioai/sim/pull/9419/files#diff-5f580fffd39ddd529ae710b571e855f28636a56713b8d9f1889d03127d070e02
dispatcher.ts https://github.com/simstudioai/sim/pull/9419/files#diff-6683656d968a1a183bf327531c469e9b0b8eea626f303f8482a0504340be2d1d
0440_drop_redundant_indexes_vacuum_tuning.sql https://github.com/simstudioai/sim/pull/9419/files#diff-3d79f101538b56418708703f19d151bafc144c067c10d50df2a895668815967f
0441_usage_log_billing_entity_period_cost_idx.sql https://github.com/simstudioai/sim/pull/9419/files#diff-475610460f2a5bd4d185894b134b92f51c4e4391bc08e102e824e5ab08fd5246
0440_snapshot.json https://github.com/simstudioai/sim/pull/9419/files#diff-543c7bfa3e22b9a99e92b80c6069642c8dfa18ecafddb35c8f3a1f0037f36c19
0441_snapshot.json https://github.com/simstudioai/sim/pull/9419/files#diff-98384716e22e13649227a29fab7bc7161b17cba185a52e3e1c4d9ce9545064be
_journal.json https://github.com/simstudioai/sim/pull/9419/files#diff-37150cc65ad16ee6fbc5fa318fc096be7730e16d63eaf863e3df5521b7030649
schema.ts https://github.com/simstudioai/sim/pull/9419/files#diff-9a959e2ce3cb4c86957bbae021d06eae364f7b0cb18964f5873bab53220af928
chat-cleanup.mock.ts https://github.com/simstudioai/sim/pull/9419/files#diff-d886ef8547a846bbe3814d845c135a0d18c15484275ed242d066e81bd80296a4
check-explicit-any.baseline.json https://github.com/simstudioai/sim/pull/9419/files#diff-780d04116ec981737479435cdb0364b49047711f2dfb93b671a9be50a1b0bb27
check-tool-registry-boundary.baseline.json https://github.com/simstudioai/sim/pull/9419/files#diff-e7b820ce86615ed78dd6fbaf0b57b20a2ac350d700c3dc0fc6b71207a656e4b7
apps/sim/app/api/v1/audit-logs/route.tshttps://github.com/simstudioai/sim/pull/9419/files#diff-84bad28ae7d475877f9a7c6f1b58d0455aea329b1502b87285d4966b73b406f5
View file https://github.com/simstudioai/sim/blob/aa7dc4ebd723bf9ca534b807c8fdde29efed3a07/apps/sim/app/api/v1/audit-logs/route.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/9419/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/9419/files#diff-84bad28ae7d475877f9a7c6f1b58d0455aea329b1502b87285d4966b73b406f5
https://github.com/simstudioai/sim/pull/9419/files#diff-84bad28ae7d475877f9a7c6f1b58d0455aea329b1502b87285d4966b73b406f5
https://github.com/simstudioai/sim/pull/9419/files#diff-84bad28ae7d475877f9a7c6f1b58d0455aea329b1502b87285d4966b73b406f5
https://github.com/simstudioai/sim/pull/9419/files#diff-84bad28ae7d475877f9a7c6f1b58d0455aea329b1502b87285d4966b73b406f5
https://github.com/simstudioai/sim/pull/9419/files#diff-84bad28ae7d475877f9a7c6f1b58d0455aea329b1502b87285d4966b73b406f5
apps/sim/app/api/webhooks/cleanup/idempotency/route.tshttps://github.com/simstudioai/sim/pull/9419/files#diff-0f0112e42bccf0f471c8692ed2ad13b101297d42dac545370bd28371b0c8d04c
View file https://github.com/simstudioai/sim/blob/aa7dc4ebd723bf9ca534b807c8fdde29efed3a07/apps/sim/app/api/webhooks/cleanup/idempotency/route.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/9419/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/9419/files#diff-0f0112e42bccf0f471c8692ed2ad13b101297d42dac545370bd28371b0c8d04c
https://github.com/simstudioai/sim/pull/9419/files#diff-0f0112e42bccf0f471c8692ed2ad13b101297d42dac545370bd28371b0c8d04c
https://github.com/simstudioai/sim/pull/9419/files#diff-0f0112e42bccf0f471c8692ed2ad13b101297d42dac545370bd28371b0c8d04c
apps/sim/app/workspace/[workspaceId]/files/hooks/use-workspace-files-room.tshttps://github.com/simstudioai/sim/pull/9419/files#diff-141bf4f4babf802e435a0b949cd4187dc1d64cd3c6ebc6fc845d49fc98cf8faf
View file https://github.com/simstudioai/sim/blob/aa7dc4ebd723bf9ca534b807c8fdde29efed3a07/apps/sim/app/workspace/%5BworkspaceId%5D/files/hooks/use-workspace-files-room.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/9419/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/9419/files#diff-141bf4f4babf802e435a0b949cd4187dc1d64cd3c6ebc6fc845d49fc98cf8faf
apps/sim/app/workspace/[workspaceId]/hooks/use-workspace-invalidation-room.test.tsxhttps://github.com/simstudioai/sim/pull/9419/files#diff-997df809130965439a3ac53e312520ed3e217519163e0ae0e8eda7eacb62c595
View file https://github.com/simstudioai/sim/blob/aa7dc4ebd723bf9ca534b807c8fdde29efed3a07/apps/sim/app/workspace/%5BworkspaceId%5D/hooks/use-workspace-invalidation-room.test.tsx
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/9419/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/9419/files#diff-997df809130965439a3ac53e312520ed3e217519163e0ae0e8eda7eacb62c595
https://github.com/simstudioai/sim/pull/9419/files#diff-997df809130965439a3ac53e312520ed3e217519163e0ae0e8eda7eacb62c595
https://github.com/simstudioai/sim/pull/9419/files#diff-997df809130965439a3ac53e312520ed3e217519163e0ae0e8eda7eacb62c595
https://github.com/simstudioai/sim/pull/9419/files#diff-997df809130965439a3ac53e312520ed3e217519163e0ae0e8eda7eacb62c595
https://github.com/simstudioai/sim/pull/9419/files#diff-997df809130965439a3ac53e312520ed3e217519163e0ae0e8eda7eacb62c595
apps/sim/app/workspace/[workspaceId]/hooks/use-workspace-invalidation-room.tshttps://github.com/simstudioai/sim/pull/9419/files#diff-43dfa92b9c4c98254a9a5ae64e63426d7b07cdaab271a1248ffadb2c7a3e4eca
View file https://github.com/simstudioai/sim/blob/aa7dc4ebd723bf9ca534b807c8fdde29efed3a07/apps/sim/app/workspace/%5BworkspaceId%5D/hooks/use-workspace-invalidation-room.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/9419/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/9419/files#diff-43dfa92b9c4c98254a9a5ae64e63426d7b07cdaab271a1248ffadb2c7a3e4eca
https://github.com/simstudioai/sim/pull/9419/files#diff-43dfa92b9c4c98254a9a5ae64e63426d7b07cdaab271a1248ffadb2c7a3e4eca
https://github.com/simstudioai/sim/pull/9419/files#diff-43dfa92b9c4c98254a9a5ae64e63426d7b07cdaab271a1248ffadb2c7a3e4eca
https://github.com/simstudioai/sim/pull/9419/files#diff-43dfa92b9c4c98254a9a5ae64e63426d7b07cdaab271a1248ffadb2c7a3e4eca
https://github.com/simstudioai/sim/pull/9419/files#diff-43dfa92b9c4c98254a9a5ae64e63426d7b07cdaab271a1248ffadb2c7a3e4eca
https://github.com/simstudioai/sim/pull/9419/files#diff-43dfa92b9c4c98254a9a5ae64e63426d7b07cdaab271a1248ffadb2c7a3e4eca
https://github.com/simstudioai/sim/pull/9419/files#diff-43dfa92b9c4c98254a9a5ae64e63426d7b07cdaab271a1248ffadb2c7a3e4eca
https://github.com/simstudioai/sim/pull/9419/files#diff-43dfa92b9c4c98254a9a5ae64e63426d7b07cdaab271a1248ffadb2c7a3e4eca
...Id]/components/panel/components/editor/components/sub-block/hooks/use-resource-folders.tshttps://github.com/simstudioai/sim/pull/9419/files#diff-477337b8bb94cc618cb3627f18bce4b689d1eac35d71ca25ee62a38e64d1399e
View file https://github.com/simstudioai/sim/blob/aa7dc4ebd723bf9ca534b807c8fdde29efed3a07/apps/sim/app/workspace/%5BworkspaceId%5D/w/%5BworkflowId%5D/components/panel/components/editor/components/sub-block/hooks/use-resource-folders.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/9419/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/9419/files#diff-477337b8bb94cc618cb3627f18bce4b689d1eac35d71ca25ee62a38e64d1399e
https://github.com/simstudioai/sim/pull/9419/files#diff-477337b8bb94cc618cb3627f18bce4b689d1eac35d71ca25ee62a38e64d1399e
https://github.com/simstudioai/sim/pull/9419/files#diff-477337b8bb94cc618cb3627f18bce4b689d1eac35d71ca25ee62a38e64d1399e
apps/sim/background/cleanup-soft-deletes.test.tshttps://github.com/simstudioai/sim/pull/9419/files#diff-7e22c35b1e0f894a4804c728a349279bf85c81dc84d790ce61e3fa8af30c66ea
View file https://github.com/simstudioai/sim/blob/aa7dc4ebd723bf9ca534b807c8fdde29efed3a07/apps/sim/background/cleanup-soft-deletes.test.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/9419/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/9419/files#diff-7e22c35b1e0f894a4804c728a349279bf85c81dc84d790ce61e3fa8af30c66ea
https://github.com/simstudioai/sim/pull/9419/files#diff-7e22c35b1e0f894a4804c728a349279bf85c81dc84d790ce61e3fa8af30c66ea
https://github.com/simstudioai/sim/pull/9419/files#diff-7e22c35b1e0f894a4804c728a349279bf85c81dc84d790ce61e3fa8af30c66ea
https://github.com/simstudioai/sim/pull/9419/files#diff-7e22c35b1e0f894a4804c728a349279bf85c81dc84d790ce61e3fa8af30c66ea
https://github.com/simstudioai/sim/pull/9419/files#diff-7e22c35b1e0f894a4804c728a349279bf85c81dc84d790ce61e3fa8af30c66ea
https://github.com/simstudioai/sim/pull/9419/files#diff-7e22c35b1e0f894a4804c728a349279bf85c81dc84d790ce61e3fa8af30c66ea
Please reload this pagehttps://github.com/simstudioai/sim/pull/9419/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/9419/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.