feat(oracles): require every oracle test to reach a declared part #2278
main fromrefs/pull/2278/head·merged by KyleAMathews(GitHub profile, opens in a new tab) 🎯 Changes#
An oracle file now holds only oracle tests, and a lint rule enforces it. Each oracle file names its check, model, and grammar with declareOracle. The new oracle/no-unit-test rule reports every test in an oracle file that reaches none of them. Such a test compares production with a value that a person wrote down. It is a unit test, so it belongs in an ordinary test file. This is the next step of #2234, after #2237.
Before this PR, a file name was the only sign of oracle coverage. An agent could add pinned examples to an oracle file, and a reader would count them as oracle coverage. The rule makes that shortcut visible at the edit, in the pre-commit hook, and in CI.
The law#
Every test in an oracle file must use a declared part, directly or through a driver. As an alternative, it can run a generated property that states its law inline:
import { declareOracle } from './oracle-declaration'
declareOracle({ check: [checkHistory], model: [modelHistory], grammar: [historyArbitrary] })
// Passes: a fixed regression replays the shared check.
it(`replays the reported history`, () => checkHistory(reportedHistory))
// Reported: the expected value has no independent source.
it(`keeps two rows`, () => {
expect(collection.size).toBe(2)
})
The rule follows bindings through the file and through relative imports of other test modules. It does not follow imports of production src/. A generated property counts as its own check when one arbitrary generates values and its predicate reads its input. A type-level oracle names its model types in typeModel. The rule also reports a call to an imported helper that registers tests of its own, because those tests then appear under the oracle file.
Two maintainer decisions (2026-10-27) set the boundary:
- A finite table of hand-written expected values, chosen by a test's parameters, is not a model. A test that compares with such a table is a unit test.
- A run budget that leaves every tracked oracle file is reported as removed, the same as a lowered budget.
The migration#
Every oracle file now declares its parts. 184 files contain a declaration. Each test that reaches no part moved unchanged to an ordinary sibling file, with the same title and body. The migration compared test titles per package before and after each move, and no title was lost. A file that had no check or model at all took an ordinary name. #2264 tracks each law that now has only fixed tests. The coverage map marks each of them as fixed tests with no oracle owner.
The branch merges origin/main after #2168. The tests that #2168 changed in oracle files carry those changes into the ordinary files that now hold them. The new oracle files from #2168 declare their parts too. For example, source-health-oracle.test.ts keeps 504 tests and moves 97 fixed tests to source-health.test.ts. The 601 titles equal the titles on main.
The branch also merges #2230, which adds Convex collections and their oracles. The Convex companion model modules now declare their models and checks. Tests that compare with written values move to pagination.test.ts, lazy-paging.test.ts, e2e/backend.test.ts, and e2e/backend-startup.test.ts. The 88 test registrations equal the registrations on main.
The tripwires#
The rule is one of four checks that make an oracle shortcut visible:
- Run budgets.
scripts/check-oracle-run-counts.mjsreports each lowered or removed budget. It now follows imported and re-exported constants and campaigns, so a budget that moves into a support module stays attributed to its oracle file. It reads base files of any size, and it fails when it cannot read a file. - Lint scope. The edit hook,
pnpm lint:changed, and the pre-commit hook now lint each oracle file that imports an edited test module. They follow imports transitively and include untracked files. - JavaScript oracle files. The rule, the lint selection, and the run-count script now include
.js,.mjs, and.jsxoracle files. - Replay owners.
oracle-replay.test.tschecks that each manifest owner's command finds its file from its working directory.
🔬 Oracle Coverage#
The tooling has its own generated oracles. Each one follows the oracle-first order in AGENTS.md.
| Owner | Law |
|---|---|
scripts/eslint-plugin-oracle/part-reach-oracle.property.test.js (lint.part-reach) | Every registration in an oracle file reaches a declared part or a generated property, or the rule reports it. Reports are a pure function of the source files. |
scripts/run-budget-oracle.property.test.js (scripts.run-budget) | Every lowered or removed budget that an oracle uses is reported, wherever its count is defined. |
scripts/lint-scope-oracle.property.test.js (scripts.lint-scope) | After an edit, each oracle file whose lint result can change is linted again. |
- Law: the rule header contract in
scripts/eslint-plugin-oracle/rules/no-unit-test.js. Also the oracle rubric section "Name oracle files consistently", AGENTS.md "How oracle work is scored", and the two decisions above. - Reach: the part-reach oracle declares 35 states, and generated histories entered each of them. The rarest are
for-of-mixed-elements(5),member-callee-registration(10), andcaller-body-wrapper-reaches-part(12). The run-budget oracle declares 16 states and the lint-scope oracle declares 15. Generated histories entered each of them. - RED: two xhigh reviews produced 30 findings. The extended oracles reproduced each behavioral finding on unchanged code. The part-reach oracle failed 29 of 37 tests at
66794a918, and 24 tests at6f5510727. The run-budget oracle failed 8 of 8 campaigns, and the lint-scope oracle failed both campaigns. The replay check failed for exactly the twoscripts/owners. - GREEN:
pnpm test:lint-rulespasses 231 rule tests and 10 script-oracle tests.pnpm lint:oraclesreports nothing. - Mutant: 21 rule mutants ran on copies of the plugin, and the oracle rejected each one by assertion. They include a last-argument body,
somein place ofeveryfor afor...ofloop, a default export throughexport *, and an unresolved.jscompanion. The script mutants include a script that crashes at startup, the default 1 MiB buffer, and no removal report. Both script oracles reject each of them. - Limits:
- The part-reach grammar does not generate three forms. They are a
letwith two assignments, afor...ofover a computed array, and a package predicate or arbitrary. - A fixed seed is not unique, so the run-count script cannot attribute a seed that another oracle file already had at base.
- A budget that a helper computes at run time is not tracked. The op-sqlite alias campaigns build theirs in
registerAliasOracle. On main the script counted literaloracleRandomParameters(50, …)calls in a unit test, and that unit test now lives inop-sqlite-driver.test.ts. So the run-count check reportsop-sqlite.write-marker-aliases,op-sqlite.columnar-sql-aliases, and seed 271828 as removed, although both campaigns still run in the oracle file. The coverage map records this limit in its "Oracle tooling" section, with an owner and the witness it needs. - The aggregate select oracle on main can miss one declared reach state on an unlucky random seed. One full run missed it, and 15 reruns reached it. The coverage map records it.
- The part-reach grammar does not generate three forms. They are a
✅ Checklist#
- I have tested this code locally with
pnpm test.
A full run on 15a725e8c passed the build, lint:check (warnings only), typecheck:tests, and the tests of every package except db and TrailBase. Two db tests failed there. The replay manifest named the wrong owner for a moved campaign, which 668194543 fixes. The aggregate select reach miss in the limits above was the other failure. In TrailBase, all 149 tests passed, but the Vitest type check found a missing ListResponse import in a moved test. CI found it too, and 93a698a8e fixes it.
The final head 2d448f75c passes the build, typecheck:tests, test:lint-rules, lint:oracles, and the tests of the packages that later commits changed. That is db (15,472 tests), electric (1,132), browser persistence (552), and offline transactions (301). The OPFS Playwright suite passes 41 tests, the IndexedDB Playwright suite passes 247 tests, and the browser end-to-end suite passes 169 tests.
After the #2230 merge, 209242262 passes the build, typecheck:tests, and lint:oracles. The Convex unit tests (112), the React Convex oracle (4), the transaction-serializer tests (51), and the db replay and campaign tests (46) pass. The Convex end-to-end oracles need a Convex backend, so CI runs them.
🚀 Release Impact#
- This change affects published code, and I have generated a changeset.
- This change is docs/CI/dev-only (no release).
The only src/ changes are in the private db-collection-e2e package. The package manifests change only their test:oracles scripts.
This pull request and its description were written by Isaac.
- 1
Important
Review skipped#
Too many files!
This PR contains 513 files, which is 213 over the limit of 300.
To get a review, reduce the PR to 300 files or fewer by splitting it into smaller PRs or changing its base branch.
Usage-priced reviews support at most 300 files.
Run configuration-
- Source mode: Auto
- Repository: Unavailable
- Branch: Unavailable
- File: No configuration file from this repository applied
- Commit: Unavailable
- Layers: defaults
- Review profile: CHILL
- Plan: Advanced
- Run ID:
10274685-27b5-4703-9ec4-96d842dc65b0
Commits-
Reviewing files that changed from the base of the PR and between db476b8ed9755e0c0b10b833d187354b4c63585c and 93a698a8e45a26cd89de91c5c23926f2e423e45c.
Files selected for processing: 513-
.gitignoreAGENTS.mddocs/contributing/oracle-coverage.mddocs/contributing/oracle-rubric.mdexamples/react/action-enforcement/eslint-rules/no-direct-collection-mutations.test.jslint-staged.config.jspackage.jsonpackages/browser-db-sqlite-persistence/e2e/hydration-commit.opfs.spec.tspackages/browser-db-sqlite-persistence/e2e/install-layout-oracle.e2e.test.tspackages/browser-db-sqlite-persistence/e2e/leader-close-oracle.opfs.spec.tspackages/browser-db-sqlite-persistence/e2e/leader-close-probe.tspackages/browser-db-sqlite-persistence/e2e/leader-close.opfs.spec.tspackages/browser-db-sqlite-persistence/e2e/opfs-request-order-oracle.opfs.spec.tspackages/browser-db-sqlite-persistence/e2e/reload-class-oracle.opfs.spec.tspackages/browser-db-sqlite-persistence/e2e/shared-driver-fairness-oracle.opfs.spec.tspackages/browser-db-sqlite-persistence/playwright.opfs.config.tspackages/browser-db-sqlite-persistence/tests/browser-coordinator-oracle.test.tspackages/browser-db-sqlite-persistence/tests/browser-coordinator-support.tspackages/browser-db-sqlite-persistence/tests/browser-coordinator.test.tspackages/browser-db-sqlite-persistence/tests/opfs-open-outcome-oracle.tspackages/browser-db-sqlite-persistence/tests/opfs-page-lifecycle-harness.tspackages/browser-db-sqlite-persistence/tests/opfs-page-lifecycle-oracle.test.tspackages/browser-db-sqlite-persistence/tests/opfs-page-lifecycle.test.tspackages/browser-db-sqlite-persistence/tests/opfs-request-order-oracle.tspackages/browser-db-sqlite-persistence/tests/opfs-worker-diagnostics-oracle.test.tspackages/browser-db-sqlite-persistence/tests/per-collection-coordinator-oracle.test.tspackages/browser-db-sqlite-persistence/tests/per-collection-coordinator-support.tspackages/browser-db-sqlite-persistence/tests/per-collection-coordinator.test.tspackages/browser-db-sqlite-persistence/tests/shared-driver-fairness-config.tspackages/browser-db-sqlite-persistence/tests/shared-driver-fairness-oracle.test.tspackages/browser-db-sqlite-persistence/tests/shared-driver-fairness-oracle.tspackages/browser-db-sqlite-persistence/tests/shared-driver-fairness.test.tspackages/convex-db-collection/e2e/auth-app-oracle.test.tspackages/convex-db-collection/e2e/backend-oracle.test.tspackages/convex-db-collection/e2e/backend-startup.test.tspackages/convex-db-collection/e2e/backend-support.tspackages/convex-db-collection/e2e/backend.test.tspackages/convex-db-collection/e2e/public-pagination-oracle.test.tspackages/convex-db-collection/tests/lazy-paging-model-oracle.tspackages/convex-db-collection/tests/lazy-paging-oracle.property.test.tspackages/convex-db-collection/tests/lazy-paging-receipt-model.tspackages/convex-db-collection/tests/lazy-paging-version-model-oracle.tspackages/convex-db-collection/tests/lazy-paging-write-model-oracle.tspackages/convex-db-collection/tests/lazy-paging.test.tspackages/convex-db-collection/tests/pagination-oracle.property.test.tspackages/convex-db-collection/tests/pagination-support.tspackages/convex-db-collection/tests/pagination.test.tspackages/db-collection-e2e/src/fixtures/persisted-conformance-manifest.tspackages/db-collection-e2e/src/index.tspackages/db-collection-e2e/src/suites/joins-oracle.suite.tspackages/db-collection-e2e/src/suites/live-updates-oracle.suite.tspackages/db-collection-e2e/src/suites/live-updates.suite.tspackages/db-collection-e2e/src/suites/moves-oracle.suite.tspackages/db-collection-e2e/src/suites/pagination-oracle.suite.tspackages/db-collection-e2e/src/suites/predicates-oracle.suite.tspackages/db-collection-e2e/src/utils/notification-laws-oracle.tspackages/db-ivm/tests/d2-work.test.tspackages/db-ivm/tests/hash-collision-support.tspackages/db-ivm/tests/hash-failure-retry-oracle.property.test.tspackages/db-ivm/tests/hash-failure-retry.test.tspackages/db-ivm/tests/hash-graph-oracle.property.test.tspackages/db-ivm/tests/hash-graph.test.tspackages/db-ivm/tests/hash-identity-oracle.property.test.tspackages/db-ivm/tests/hash-identity.test.tspackages/db-ivm/tests/hash-mixed-graph-oracle.property.test.tspackages/db-ivm/tests/hash-oracle.property.test.tspackages/db-ivm/tests/hash-support.tspackages/db-ivm/tests/hash.test.tspackages/db-ivm/tests/incrementalization-law-oracle.property.test.tspackages/db-ivm/tests/incrementalization-law-oracle.tspackages/db-ivm/tests/index-refinement-oracle.property.test.tspackages/db-ivm/tests/multiset-consolidate-oracle.property.test.tspackages/db-ivm/tests/multiset-consolidate.test.tspackages/db-ivm/tests/multiset-support.tspackages/db-ivm/tests/murmur-stream-oracle.property.test.tspackages/db-ivm/tests/murmur-stream-reference-oracle.tspackages/db-ivm/tests/operators/topKWithFractionalIndex-oracle.test.tspackages/db-ivm/tests/operators/topKWithFractionalIndex.test.tspackages/db-ivm/tests/operators/topk-batch-contract-oracle.test.tspackages/db-ivm/tests/operators/topk-batch.test.tspackages/db-ivm/tests/operators/topk-relation-oracle.test.tspackages/db-ivm/tests/operators/topk-relation-oracle.tspackages/db-ivm/tests/operators/topk-support-window-oracle.test.tspackages/db-ivm/tests/structural-identity-oracle.property.test.tspackages/db-ivm/tests/structural-identity.test.tspackages/db-ivm/tests/temporal-group-key-oracle.test.tspackages/db-ivm/tests/temporal-group-key.test.tspackages/db-sqlite-persistence-core/tests/collection-setup-reopen-oracle.test.tspackages/db-sqlite-persistence-core/tests/contracts/persisted-collection-conformance-contract.tspackages/db-sqlite-persistence-core/tests/contracts/sqlite-core-adapter-contract.tspackages/db-sqlite-persistence-core/tests/ordinary-transaction-work-oracle.tspackages/db-sqlite-persistence-core/tests/ordinary-transaction-work-support.tspackages/db-sqlite-persistence-core/tests/ordinary-transaction-work.test.tspackages/db-sqlite-persistence-core/tests/persisted-cache-claims.test.tspackages/db-sqlite-persistence-core/tests/persisted-cleanup.test.tspackages/db-sqlite-persistence-core/tests/persisted-demand.test.tspackages/db-sqlite-persistence-core/tests/persisted-follower-indexes.test.tspackages/db-sqlite-persistence-core/tests/persisted-hydration-queue.test.tspackages/db-sqlite-persistence-core/tests/persisted-hydration-scope.test.tspackages/db-sqlite-persistence-core/tests/persisted-oracle.test.tspackages/db-sqlite-persistence-core/tests/persisted-readiness-oracle.test.tspackages/db-sqlite-persistence-core/tests/persisted-readiness-support.tspackages/db-sqlite-persistence-core/tests/persisted-readiness.test.tspackages/db-sqlite-persistence-core/tests/persisted-real-adapter-lifecycle.test.tspackages/db-sqlite-persistence-core/tests/persisted-reconciliation.test.tspackages/db-sqlite-persistence-core/tests/persisted-reload-metadata.test.tspackages/db-sqlite-persistence-core/tests/persisted-reload-replacement-oracle.test.tspackages/db-sqlite-persistence-core/tests/persisted-reset-startup.test.tspackages/db-sqlite-persistence-core/tests/persisted-source-receipts.test.tspackages/db-sqlite-persistence-core/tests/persisted-startup.test.tspackages/db-sqlite-persistence-core/tests/persisted-subset.test.tspackages/db-sqlite-persistence-core/tests/persisted-support.tspackages/db-sqlite-persistence-core/tests/persisted-sync-problem-oracle.test.tspackages/db-sqlite-persistence-core/tests/persisted.test.tspackages/db-sqlite-persistence-core/tests/reload-class-oracle.tspackages/db-sqlite-persistence-core/tests/shared-logical-scheduling-oracle.test.tspackages/db-sqlite-persistence-core/tests/shared-logical-scheduling-support.tspackages/db-sqlite-persistence-core/tests/shared-logical-scheduling.test.tspackages/db-sqlite-persistence-core/tests/sqlite-boolean-arity-oracle.test.tspackages/db-sqlite-persistence-core/tests/sqlite-boolean-arity-support.tspackages/db-sqlite-persistence-core/tests/sqlite-boolean-arity.test.tspackages/db-sqlite-persistence-core/tests/sqlite-core-adapter-binding-support.tspackages/db-sqlite-persistence-core/tests/sqlite-core-adapter-binding-units.tspackages/db-sqlite-persistence-core/tests/sqlite-core-adapter-cli-runtime.test.tspackages/db-sqlite-persistence-core/tests/sqlite-core-adapter-contract-suite.tspackages/db-sqlite-persistence-core/tests/sqlite-core-adapter-oracle.test.tspackages/db-sqlite-persistence-core/tests/sqlite-core-adapter-support.tspackages/db-sqlite-persistence-core/tests/sqlite-resume-snapshot-oracle.test.tspackages/db-sqlite-persistence-core/tests/sqlite-resume-snapshot-support.tspackages/db-sqlite-persistence-core/tests/sqlite-resume-snapshot.test.tspackages/db-sqlite-persistence-core/tests/sqlite-temporal-value-oracle.test.tspackages/db-sqlite-persistence-core/tests/sqlite-temporal-value-support.tspackages/db-sqlite-persistence-core/tests/sqlite-temporal-value.test.tspackages/db-sqlite-persistence-core/tests/temporal-value-oracle.tspackages/db/e2e/indexed-db/browser-evidence-oracle.tspackages/db/e2e/indexed-db/coverage-cleanup.tspackages/db/e2e/indexed-db/cross-tab-oracle.spec.tspackages/db/e2e/indexed-db/cross-tab-support.tspackages/db/e2e/indexed-db/cross-tab.spec.tspackages/db/e2e/indexed-db/host-driver.tspackages/db/e2e/indexed-db/host.spec.tspackages/db/e2e/indexed-db/value-oracle.spec.tspackages/db/e2e/indexed-db/value.spec.tspackages/db/package.jsonpackages/db/playwright.indexed-db.config.tspackages/db/tests/SortedMap-oracle.test.tspackages/db/tests/SortedMap.test.tspackages/db/tests/btree-map-oracle.test.tspackages/db/tests/change-event-history-fixture.tspackages/db/tests/change-event-history-oracle.test.tspackages/db/tests/change-event-history.test.tspackages/db/tests/cleanup-queue-oracle.property.test.tspackages/db/tests/collection-cleanup-restart-oracle.test.tspackages/db/tests/collection-cleanup-restart-support.tspackages/db/tests/collection-cleanup-restart.test.tspackages/db/tests/collection-gc-retention-oracle.property.test.tspackages/db/tests/collection-gc-retention-oracle.tspackages/db/tests/collection-gc-retention.test.tspackages/db/tests/collection-index-value-fixture.tspackages/db/tests/collection-index-value-oracle.test.tspackages/db/tests/collection-index-value.test.tspackages/db/tests/collection-metadata-publication-oracle.property.test.tspackages/db/tests/collection-metadata-publication.test.tspackages/db/tests/collection-mutation-startup.test.tspackages/db/tests/collection-row-metadata-composition-oracle.test.tspackages/db/tests/collection-state-retention-fixture.tspackages/db/tests/collection-state-retention-oracle.property.test.tspackages/db/tests/collection-state-retention.test.tspackages/db/tests/collection-subscription-lifecycle-cell-support.tspackages/db/tests/collection-subscription-lifecycle-cells.test.tspackages/db/tests/collection-subscription-lifecycle-grammar-oracle.tspackages/db/tests/collection-subscription-lifecycle-oracle.test.tspackages/db/tests/collection-subscription-lifecycle-publication-oracle.property.test.tspackages/db/tests/collection-subscription-lifecycle-publication-support.tspackages/db/tests/collection-subscription-lifecycle-publication.test.tspackages/db/tests/collection-subscription-lifecycle.test.tspackages/db/tests/collection-subscription-reentrancy-fixture.tspackages/db/tests/collection-subscription-reentrancy-oracle.test.tspackages/db/tests/collection-subscription-reentrancy.test.tspackages/db/tests/collection-subscription-replay-oracle.property.test.tspackages/db/tests/collection-subscription-replay-support.tspackages/db/tests/collection-subscription-replay.test.tspackages/db/tests/collection-sync-reentrancy-oracle.test.tspackages/db/tests/collection-sync-reentrancy-support.tspackages/db/tests/collection-sync-reentrancy.test.tspackages/db/tests/comparison-options.tspackages/db/tests/comparison-oracle.property.test.tspackages/db/tests/comparison.test.tspackages/db/tests/conformance-infinite-calibration.test.tspackages/db/tests/conformance/infinite-suite-cases.tspackages/db/tests/conformance/infinite-suite-harness.tspackages/db/tests/conformance/infinite-suite-oracle.tspackages/db/tests/conformance/page-laws-oracle.tspackages/db/tests/cursor-oracle.property.test.tspackages/db/tests/cursor-order-terms.tspackages/db/tests/cursor.test.tspackages/db/tests/d2-source-reconciliation-oracle.property.test.tspackages/db/tests/d2-source-reconciliation-support.tspackages/db/tests/d2-source-reconciliation.test.tspackages/db/tests/db-client-hydration-authority-oracle.test.tspackages/db/tests/db-client-preload-identity.test.tspackages/db/tests/deep-equals-support.tspackages/db/tests/duration-query-equality-oracle.test.tspackages/db/tests/effect-disposal-oracle.test.tspackages/db/tests/error-sites-oracle.tspackages/db/tests/flat-change-tracking-fixture.tspackages/db/tests/flat-change-tracking-oracle.property.test.tspackages/db/tests/flat-change-tracking.test.tspackages/db/tests/index-suggestion-oracle.test.tspackages/db/tests/index-suggestion.test.tspackages/db/tests/index-update-oracle.property.test.tspackages/db/tests/index-update-support.tspackages/db/tests/index-update.test.tspackages/db/tests/indexed-db/ORACLE.mdpackages/db/tests/indexed-db/compatibility.test.tspackages/db/tests/indexed-db/cross-tab-oracle.tspackages/db/tests/indexed-db/deletion-queue.test.tspackages/db/tests/indexed-db/local-write-order-oracle.test.tspackages/db/tests/indexed-db/local-write-order.test.tspackages/db/tests/indexed-db/local-write-support.tspackages/db/tests/indexed-db/persistence-oracle.test.tspackages/db/tests/indexed-db/persistence.test.tspackages/db/tests/indexed-db/retirement-oracle.test.tspackages/db/tests/indexed-db/retirement-support.tspackages/db/tests/indexed-db/retirement.test.tspackages/db/tests/indexed-db/settlement.test.tspackages/db/tests/indexed-db/structured-clone-oracle.tspackages/db/tests/indexed-db/transport-oracle.test.tspackages/db/tests/indexed-db/transport.test.tspackages/db/tests/indexed-db/wrapper-settlement-oracle.test.tspackages/db/tests/live-query-deferred-acquisition-oracle.test.tspackages/db/tests/live-query-deferred-acquisition-support.tspackages/db/tests/live-query-deferred-acquisition.test.tspackages/db/tests/live-query-observer-history-oracle.property.test.tspackages/db/tests/live-query-observer-history.test.tspackages/db/tests/live-query-observer-hydration-oracle.property.test.tspackages/db/tests/live-query-observer-snapshot-oracle.property.test.tspackages/db/tests/live-query-observer-snapshot.test.tspackages/db/tests/local-only-direct-write-fixture.tspackages/db/tests/local-only-direct-write-oracle.test.tspackages/db/tests/local-only-direct-write.test.tspackages/db/tests/local-storage-fixtures.tspackages/db/tests/local-storage-order-oracle.test.tspackages/db/tests/local-storage-order.test.tspackages/db/tests/local-storage-peer-fixtures.tspackages/db/tests/local-storage-peer-history.test.tspackages/db/tests/local-storage-peer.test.tspackages/db/tests/local-storage-value-fidelity-oracle.property.test.tspackages/db/tests/metadata-publication-worlds.tspackages/db/tests/mutation-handler-type.test-d.tspackages/db/tests/observer-history-cleanup.tspackages/db/tests/optimistic-composition-fixture.tspackages/db/tests/optimistic-composition-oracle.test.tspackages/db/tests/optimistic-composition.test.tspackages/db/tests/optimistic-history-oracle.tspackages/db/tests/optimistic-history-outcomes-oracle.test.tspackages/db/tests/optimistic-history-outcomes.test.tspackages/db/tests/optimistic-transaction-oracle.property.test.tspackages/db/tests/optimistic-transaction-support.tspackages/db/tests/optimistic-transaction.test.tspackages/db/tests/oracle-config.tspackages/db/tests/oracle-declaration.tspackages/db/tests/oracle-replay-manifest.tspackages/db/tests/oracle-replay.test.tspackages/db/tests/paced-mutations-oracle.test.tspackages/db/tests/paced-mutations-scenarios.test.tspackages/db/tests/paced-mutations-support.tspackages/db/tests/production-error-messages-fixture.tspackages/db/tests/production-error-messages-oracle.test.tspackages/db/tests/production-error-messages.test.tspackages/db/tests/proxy-detachment-contract-oracle.test.tspackages/db/tests/proxy-detachment-contract.test.tspackages/db/tests/proxy-detachment-fixture.tspackages/db/tests/proxy-iteration-contract-oracle.test.tspackages/db/tests/proxy-iteration-contract.test.tspackages/db/tests/proxy-iteration-fixture.tspackages/db/tests/proxy-native-methods-fixture.tspackages/db/tests/proxy-native-methods-oracle.property.test.tspackages/db/tests/proxy-native-methods.test.tspackages/db/tests/proxy-native-rows.tspackages/db/tests/proxy-oracle.test.tspackages/db/tests/proxy-revert-oracle.property.test.tspackages/db/tests/proxy-revert.test.tspackages/db/tests/proxy.test.tspackages/db/tests/query/aggregate-select-oracle.property.test.tspackages/db/tests/query/aggregate-select.test.tspackages/db/tests/query/bucket-facade-rollback-oracle.property.test.tspackages/db/tests/query/bucket-facade-rollback-support.tspackages/db/tests/query/bucket-facade-rollback.test.tspackages/db/tests/query/cold-join-reconciliation-oracle.test.tspackages/db/tests/query/cold-join-reconciliation.test.tspackages/db/tests/query/cold-join-support.tspackages/db/tests/query/compiler/evaluators-oracle.test.tspackages/db/tests/query/compiler/evaluators.test.tspackages/db/tests/query/compiler/in-evaluator-oracle.property.test.tspackages/db/tests/query/custom-index-order-selection-oracle.test.tspackages/db/tests/query/derived-delete-reconciliation-oracle.test.tspackages/db/tests/query/derived-delete-reconciliation.test.tspackages/db/tests/query/group-result-key-oracle.property.test.tspackages/db/tests/query/identity-output-shape-oracle.test.tspackages/db/tests/query/identity-output-shape-support.tspackages/db/tests/query/identity-output-shape.test.tspackages/db/tests/query/includes-alias-shadowing-oracle.test.tspackages/db/tests/query/includes-alias-shadowing-support.tspackages/db/tests/query/includes-alias-shadowing.test.tspackages/db/tests/query/includes-collection-driver-oracle.tspackages/db/tests/query/includes-collection-oracle.property.test.tspackages/db/tests/query/includes-collection-support.tspackages/db/tests/query/includes-collection.test.tspackages/db/tests/query/includes-context-transport-helpers.tspackages/db/tests/query/includes-context-transport-oracle.test.tspackages/db/tests/query/includes-context-transport.test.tspackages/db/tests/query/includes-cross-formulation-oracle.property.test.tspackages/db/tests/query/includes-cross-formulation-support.tspackages/db/tests/query/includes-cross-formulation.test.tspackages/db/tests/query/includes-functional-projection-oracle.test.tspackages/db/tests/query/includes-functional-projection-support.tspackages/db/tests/query/includes-functional-projection.test.tspackages/db/tests/query/includes-optimistic-oracle.property.test.tspackages/db/tests/query/includes-optimistic-support.tspackages/db/tests/query/includes-optimistic.test.tspackages/db/tests/query/includes-oracle.property.test.tspackages/db/tests/query/includes-outer-join-route-work-oracle.test.tspackages/db/tests/query/includes-publication-oracle.test.tspackages/db/tests/query/includes-query-shape-oracle.test.tspackages/db/tests/query/includes-query-shape-support.tspackages/db/tests/query/includes-query-shape.test.tspackages/db/tests/query/includes-route-grammar-oracle.tspackages/db/tests/query/includes-scope-identity-oracle.tspackages/db/tests/query/includes-space-helpers.tspackages/db/tests/query/includes-space-oracle.test.tspackages/db/tests/query/includes-space.test.tspackages/db/tests/query/includes-structural-support.tspackages/db/tests/query/includes-temporal-oracle.test.tspackages/db/tests/query/includes-temporal-support.tspackages/db/tests/query/includes-temporal.test.tspackages/db/tests/query/includes-work-counter-oracle.test.tspackages/db/tests/query/includes-work-counter-support.tspackages/db/tests/query/includes-work-counter.test.tspackages/db/tests/query/includes.test.tspackages/db/tests/query/index-path-collision-oracle.test.tspackages/db/tests/query/index-path-collision-support.tspackages/db/tests/query/index-path-collision.test.tspackages/db/tests/query/ir-stable-identity-oracle.test.tspackages/db/tests/query/ir-stable-identity-support.tspackages/db/tests/query/ir-stable-identity.test.tspackages/db/tests/query/join-result-key-oracle.property.test.tspackages/db/tests/query/load-subset-oracle.property.test.tspackages/db/tests/query/load-subset-replay-refinement-oracle.test.tspackages/db/tests/query/load-subset-replay-refinement.test.tspackages/db/tests/query/load-subset-source-readiness-refinement-oracle.test.tspackages/db/tests/query/load-subset-source-readiness-support.tspackages/db/tests/query/load-subset-source-readiness.test.tspackages/db/tests/query/load-subset-support.tspackages/db/tests/query/load-subset-transaction-refinement-oracle.test.tspackages/db/tests/query/load-subset-transaction-refinement.test.tspackages/db/tests/query/load-subset.test.tspackages/db/tests/query/mixed-index-order-oracle.test.tspackages/db/tests/query/optimizer-semantics-oracle.test.tspackages/db/tests/query/optimizer-semantics-support.tspackages/db/tests/query/optimizer-semantics.test.tspackages/db/tests/query/ordered-lifecycle-oracle.property.test.tspackages/db/tests/query/ordered-lifecycle-support.tspackages/db/tests/query/ordered-lifecycle.test.tspackages/db/tests/query/ordered-source-loader-oracle.test.tspackages/db/tests/query/ordered-source-loader-state-oracle.test.tspackages/db/tests/query/ordered-source-loader-state-support.tspackages/db/tests/query/ordered-source-loader-state.test.tspackages/db/tests/query/ordered-source-loader-support.tspackages/db/tests/query/ordered-source-loader.test.tspackages/db/tests/query/ordered-work-oracle.property.test.tspackages/db/tests/query/ordered-work-support.tspackages/db/tests/query/ordered-work.test.tspackages/db/tests/query/pagination-oracle.property.test.tspackages/db/tests/query/pagination-support.tspackages/db/tests/query/pagination.test.tspackages/db/tests/query/pooled-live-query-gc-oracle.test.tspackages/db/tests/query/pooled-live-query-gc-support.tspackages/db/tests/query/pooled-live-query-gc.test.tspackages/db/tests/query/pooled-live-query-oracle.property.test.tspackages/db/tests/query/subquery-user-value-oracle.test.tspackages/db/tests/query/subquery-user-value.test.tspackages/db/tests/query/virtual-row-fields-oracle.test-d.tspackages/db/tests/query/virtual-row-fields-oracle.test.tspackages/db/tests/query/virtual-row-fields-support.tspackages/db/tests/query/virtual-row-fields-type-fixture.tspackages/db/tests/query/virtual-row-fields.test-d.tspackages/db/tests/query/virtual-row-fields.test.tspackages/db/tests/query/where-predicate-publication-oracle.property.test.tspackages/db/tests/query/where-predicate-publication.test.tspackages/db/tests/query/where-predicate-support.tspackages/db/tests/reference-expression-oracle.tspackages/db/tests/reverse-index-oracle.property.test.tspackages/db/tests/reverse-index.test.tspackages/db/tests/sorted-map-support.tspackages/db/tests/source-health-oracle.test.tspackages/db/tests/source-health-support.tspackages/db/tests/source-health.test.tspackages/db/tests/ssr-snapshot-admission-oracle.tspackages/db/tests/temporal-index-order.test.tspackages/db/tests/transaction-ownership-oracle.property.test.tspackages/db/tests/truncate-readiness-oracle.test.tspackages/db/tests/truncate-readiness.test.tspackages/db/tests/utils-oracle.property.test.tspackages/db/tests/utils.test.tspackages/db/vitest.dist.config.tspackages/electric-db-collection/e2e/electric.e2e.test.tspackages/electric-db-collection/e2e/sql-predicate-semantics-oracle.e2e.test.tspackages/electric-db-collection/e2e/sql-predicate-semantics.e2e.test.tspackages/electric-db-collection/package.jsonpackages/electric-db-collection/tests/electric-adapter-support.tspackages/electric-db-collection/tests/electric-adapter.test.tspackages/electric-db-collection/tests/electric-descriptor-fixture.tspackages/electric-db-collection/tests/electric-descriptor-harness.tspackages/electric-db-collection/tests/electric-descriptor-isolation-oracle.test.tspackages/electric-db-collection/tests/electric-descriptor-isolation.test.tspackages/electric-db-collection/tests/electric-lifecycle.test.tspackages/electric-db-collection/tests/electric-oracle.property.test.tspackages/electric-db-collection/tests/electric-persistence-fixture.tspackages/electric-db-collection/tests/electric-recovery-oracle.test.tspackages/electric-db-collection/tests/electric-recovery-support.tspackages/electric-db-collection/tests/electric-recovery.test.tspackages/electric-db-collection/tests/electric-sdk-delivery-oracle.property.test.tspackages/electric-db-collection/tests/electric-sdk-delivery-support.tspackages/electric-db-collection/tests/electric-sdk-delivery.test.tspackages/electric-db-collection/tests/pg-serializer-finite-decoder.tspackages/electric-db-collection/tests/pg-serializer-oracle.property.test.tspackages/electric-db-collection/tests/pg-serializer-property-support.tspackages/electric-db-collection/tests/pg-serializer.test.tspackages/electron-db-sqlite-persistence/tests/electron-ipc-readiness-oracle.test.tspackages/electron-db-sqlite-persistence/tests/reload-class-oracle.electron.e2e.test.tspackages/node-db-sqlite-persistence/tests/expression-index-oracle.test.tspackages/node-db-sqlite-persistence/tests/expression-index-support.tspackages/node-db-sqlite-persistence/tests/expression-index.test.tspackages/offline-transactions/tests/KeyScheduler-lifecycle.test.tspackages/offline-transactions/tests/KeyScheduler-oracle.property.test.tspackages/offline-transactions/tests/connectivity-replay-oracle.test.tspackages/offline-transactions/tests/harness.tspackages/offline-transactions/tests/interruption-settlement-oracle.property.test.tspackages/offline-transactions/tests/key-scheduler-support.tspackages/offline-transactions/tests/leadership-replay-oracle.property.test.tspackages/offline-transactions/tests/leadership-replay-support.tspackages/offline-transactions/tests/leadership-replay.test.tspackages/offline-transactions/tests/transaction-serializer-oracle.property.test.tspackages/offline-transactions/tests/transaction-serializer.test.tspackages/offline-transactions/tests/transaction-settlement-oracle.property.test.tspackages/offline-transactions/tests/transaction-settlement.test.tspackages/powersync-db-collection/package.jsonpackages/powersync-db-collection/tests/correctness.test.tspackages/preact-db/tests/infinite-query-conformance.test.tspackages/query-db-collection/e2e/query.e2e.test.tspackages/query-db-collection/package.jsonpackages/query-db-collection/tests/cursor-pagination-boundary-support.tspackages/query-db-collection/tests/cursor-pagination-integration-fixture.tspackages/query-db-collection/tests/cursor-pagination-oracle.integration.test.tspackages/query-db-collection/tests/cursor-pagination.boundary-oracle.test.tspackages/query-db-collection/tests/cursor-pagination.boundary.test.tspackages/query-db-collection/tests/cursor-pagination.integration.test.tspackages/query-db-collection/tests/cursor-pagination.oracle.test.tspackages/query-db-collection/tests/cursor-pagination.test.tspackages/query-db-collection/tests/cursor-pagination/model-oracle.tspackages/query-db-collection/tests/load-subset-lifecycle.test.tspackages/query-db-collection/tests/optimistic-ordered-refetch-oracle.test.tspackages/query-db-collection/tests/optimistic-ordered-refetch-probe.tspackages/query-db-collection/tests/optimistic-ordered-refetch.test.tspackages/query-db-collection/tests/ownership-lifecycle-support.tspackages/query-db-collection/tests/ownership-lifecycle.oracle.test.tspackages/query-db-collection/tests/ownership-lifecycle.test.tspackages/query-db-collection/tests/persisted-direct-write-support.tspackages/query-db-collection/tests/persisted-direct-write-window.oracle.test.tspackages/query-db-collection/tests/persisted-direct-write.test.tspackages/query-db-collection/tests/refetch-ordered-prefix-oracle.test.tspackages/query-db-collection/tests/refetch-ordered-prefix-support.tspackages/query-db-collection/tests/refetch-ordered-prefix.test.tspackages/query-db-collection/tests/ssr-dehydration-oracle.test.tspackages/react-db/tests/descriptor-query-binding-oracle.test.tsxpackages/react-db/tests/descriptor-query-binding-support.tsxpackages/react-db/tests/descriptor-query-binding.test.tsxpackages/react-db/tests/infinite-query-conformance.test.tsxpackages/react-db/tests/infinite-query-render-cuts-oracle.test.tsxpackages/react-db/tests/infinite-query-render-cuts-support.tsxpackages/react-db/tests/infinite-query-render-cuts.test.tsxpackages/react-db/tests/source-id-reuse-oracle.test.tsxpackages/react-db/tests/source-id-reuse-support.tsxpackages/react-db/tests/source-id-reuse.test.tsxpackages/react-db/tests/ssr-runtime-error-handoff-oracle.test.tsxpackages/react-db/tests/usePacedMutations-render-cuts-oracle.test.tsxpackages/react-native-db-sqlite-persistence/tests/op-sqlite-driver-oracle.test.tspackages/react-native-db-sqlite-persistence/tests/op-sqlite-driver-support.tspackages/react-native-db-sqlite-persistence/tests/op-sqlite-driver.test.tspackages/svelte-db/tests/descriptor-query-release.svelte.test.tspackages/svelte-db/tests/infinite-query-conformance.svelte.test.tspackages/svelte-db/tests/ssr-runtime-error-oracle.svelte.test.tspackages/trailbase-db-collection/e2e/trailbase.e2e.test.tspackages/trailbase-db-collection/tests/ORACLE.mdpackages/trailbase-db-collection/tests/lifecycle-oracle.property.test.tspackages/trailbase-db-collection/tests/lifecycle-support.tspackages/trailbase-db-collection/tests/lifecycle.test.tspackages/vue-db/tests/infinite-query-conformance.test.tspackages/vue-db/tests/useLiveQuery-publication-oracle.test.tsscripts/agent-lint-feedback.mjsscripts/check-oracle-run-counts.mjsscripts/eslint-plugin-oracle/index.jsscripts/eslint-plugin-oracle/no-disabled.test.jsscripts/eslint-plugin-oracle/no-unit-test.test.jsscripts/eslint-plugin-oracle/part-reach-oracle.property.test.jsscripts/eslint-plugin-oracle/registration.jsscripts/eslint-plugin-oracle/rules/no-disabled.jsscripts/eslint-plugin-oracle/rules/no-unit-test.jsscripts/eslint-plugin-oracle/vitest.config.mjsscripts/lint-scope-oracle.property.test.jsscripts/oracle-scripts.vitest.config.mjsscripts/run-budget-oracle.property.test.js
You can disable this status message by setting the
reviews.review_statustofalsein the CodeRabbit configuration file.- Autofix · Keep fixing CodeRabbit findings and required CI, and resolving merge conflicts
Thanks for using CodeRabbit! It's free for OSS, and your support helps us grow. If you like it, consider giving us a shout-out.
Comment `@coderabbitai help` to get the list of available commands.-
Incremental update benchmark#
Comparing
3b35bc2df(this PR) againstdb476b8ed(base). Write times are per-write medians over 100 iterations (20 warmup writes). Cold hydrate is one timed first load of each query.Overall median write time vs base: 0.97× · cold hydrate time: 0.96× (geometric mean of per-case ratios; lower is faster).
Writes: 1 regression(s), 3 improvement(s) (threshold: ±20% and >0.05ms).
Cold hydrate: 1 regression(s), 2 improvement(s) (threshold: ±50% and >5ms).
Per-case flags are noisy on shared runners. Read the geometric means first.Writes#
Query Δ median write time (geomean) Best case Worst case Flags list: newest 50 open -1.3% -55.6% +64.4% 1 🔴 1 🟢 list + author -2.5% -33.3% +9.9% 1 🟢 list + comment count -1.0% -14.8% +14.1% — list + 3 recent comments -3.2% -17.6% +26.7% — issue detail + comments -5.7% -43.8% +14.7% 1 🟢 Cold hydrate#
Query Δ cold hydrate time (geomean) Best case Worst case Flags list: newest 50 open -2.1% -38.4% +75.3% — list + author -11.6% -69.6% +26.9% 1 🟢 list + comment count -4.1% -64.2% +46.2% 1 🟢 list + 3 recent comments -1.6% -27.7% +173.3% 1 🔴 issue detail + comments -5.2% -24.4% +10.1% — Each row aggregates the 14.4 scale/index/write-mode configurations of that query; per-configuration tables below.
100 rows/collection | source indexes: none | synced writes — geomean 0.97×, cold 0.98×
Query Base median PR median Δ median Base p95 PR p95 Δ p95 Base cold PR cold Δ cold list: newest 50 open 0.168ms 0.180ms +6.7% 0.302ms 0.294ms -2.8% 12.505ms 12.607ms +0.8% list: newest 50 open 0.457ms 0.446ms -2.4% 0.744ms 0.793ms +6.6% 3.106ms 2.786ms -10.3% list + author 0.173ms 0.166ms -4.0% 0.298ms 0.295ms -1.0% 8.958ms 9.637ms +7.6% list + comment count 0.347ms 0.313ms -9.9% 0.619ms 0.505ms -18.4% 12.487ms 11.442ms -8.4% list + 3 recent comments 0.211ms 0.196ms -6.8% 0.354ms 0.351ms -0.7% 10.080ms 10.902ms +8.2% issue detail + comments 0.132ms 0.135ms +2.2% 0.218ms 0.272ms +24.5% 1.998ms 1.786ms -10.6% 100 rows/collection | source indexes: none | optimistic writes — geomean 1.05×, cold 0.91×
Query Base median PR median Δ median Base p95 PR p95 Δ p95 Base cold PR cold Δ cold list: newest 50 open 0.112ms 0.110ms -2.2% 0.200ms 0.174ms -12.8% 3.334ms 2.601ms -22.0% list: newest 50 open 0.072ms 0.073ms +1.0% 0.146ms 0.165ms +13.1% 1.620ms 1.866ms +15.2% list + author 0.131ms 0.131ms -0.6% 0.232ms 0.259ms +11.2% 4.859ms 3.435ms -29.3% list + comment count 0.219ms 0.209ms -4.6% 0.383ms 0.377ms -1.5% 4.487ms 5.856ms +30.5% list + 3 recent comments 0.116ms 0.147ms +26.7% 0.234ms 0.245ms +4.6% 9.113ms 6.592ms -27.7% issue detail + comments 0.109ms 0.125ms +14.7% 0.181ms 0.220ms +21.8% 1.087ms 0.998ms -8.2% 100 rows/collection | source indexes: manual | synced writes — geomean 1.00×, cold 1.06×
Query Base median PR median Δ median Base p95 PR p95 Δ p95 Base cold PR cold Δ cold list: newest 50 open 0.110ms 0.096ms -12.3% 0.220ms 0.194ms -11.9% 3.006ms 2.828ms -5.9% list: newest 50 open 0.383ms 0.415ms +8.1% 0.703ms 0.719ms +2.3% 1.291ms 1.411ms +9.3% list + author 0.103ms 0.105ms +2.0% 0.209ms 0.242ms +15.7% 3.025ms 3.839ms +26.9% list + comment count 0.226ms 0.224ms -0.9% 0.459ms 0.404ms -11.9% 3.184ms 3.297ms +3.6% list + 3 recent comments 0.141ms 0.144ms +2.2% 0.218ms 0.289ms +32.8% 4.612ms 4.803ms +4.1% issue detail + comments 0.102ms 0.104ms +2.3% 0.209ms 0.193ms -7.8% 0.597ms 0.588ms -1.6% 100 rows/collection | source indexes: manual | optimistic writes — geomean 1.07×, cold 0.85×
Query Base median PR median Δ median Base p95 PR p95 Δ p95 Base cold PR cold Δ cold list: newest 50 open 0.086ms 0.086ms -0.0% 0.179ms 0.162ms -9.4% 1.655ms 1.193ms -27.9% list: newest 50 open 0.069ms 0.079ms +14.7% 0.165ms 0.146ms -11.9% 1.058ms 0.889ms -15.9% list + author 0.111ms 0.120ms +8.3% 0.166ms 0.226ms +35.7% 2.736ms 2.489ms -9.0% list + comment count 0.178ms 0.194ms +9.0% 0.328ms 0.337ms +2.9% 2.928ms 3.654ms +24.8% list + 3 recent comments 0.110ms 0.107ms -2.6% 0.213ms 0.207ms -3.0% 6.075ms 4.469ms -26.4% issue detail + comments 0.086ms 0.095ms +10.7% 0.131ms 0.244ms +86.6% 0.609ms 0.461ms -24.4% 1,000 rows/collection | source indexes: none | synced writes — geomean 0.96×, cold 1.17×, 1 change(s)
Query Base median PR median Δ median Base p95 PR p95 Δ p95 Base cold PR cold Δ cold list: newest 50 open 0.065ms 0.076ms +16.7% 0.125ms 0.150ms +20.6% 6.707ms 7.713ms +15.0% list: newest 50 open 1.005ms 1.043ms +3.8% 1.998ms 1.708ms -14.5% 6.066ms 10.636ms +75.3% list + author 0.084ms 0.092ms +9.9% 0.107ms 0.195ms +83.1% 17.438ms 19.587ms +12.3% list + comment count 0.183ms 0.197ms +8.1% 0.331ms 0.371ms +12.3% 9.469ms 9.963ms +5.2% list + 3 recent comments 0.170ms 0.163ms -4.6% 0.299ms 0.282ms -5.8% 12.597ms 12.239ms -2.8% issue detail + comments 0.149ms 0.084ms -43.8% 0.200ms 0.147ms -26.6% 🟢 1.241ms 1.366ms +10.1% 1,000 rows/collection | source indexes: none | optimistic writes — geomean 0.84×, cold 1.01×, 1 change(s)
Query Base median PR median Δ median Base p95 PR p95 Δ p95 Base cold PR cold Δ cold list: newest 50 open 0.097ms 0.108ms +11.0% 0.191ms 0.204ms +6.5% 5.849ms 6.475ms +10.7% list: newest 50 open 0.112ms 0.050ms -55.6% 0.169ms 0.086ms -48.7% 🟢 6.187ms 6.998ms +13.1% list + author 0.103ms 0.101ms -1.3% 0.206ms 0.134ms -35.0% 19.495ms 15.888ms -18.5% list + comment count 0.166ms 0.154ms -7.3% 0.211ms 0.177ms -16.1% 8.990ms 11.396ms +26.8% list + 3 recent comments 0.096ms 0.085ms -11.8% 0.133ms 0.106ms -20.5% 9.968ms 9.168ms -8.0% issue detail + comments 0.086ms 0.075ms -12.7% 0.151ms 0.092ms -39.0% 1.426ms 1.265ms -11.3% 1,000 rows/collection | source indexes: manual | synced writes — geomean 0.97×, cold 0.97×
Query Base median PR median Δ median Base p95 PR p95 Δ p95 Base cold PR cold Δ cold list: newest 50 open 0.059ms 0.062ms +4.1% 0.075ms 0.080ms +7.4% 1.156ms 1.055ms -8.8% list: newest 50 open 0.322ms 0.299ms -7.1% 0.568ms 0.565ms -0.6% 0.875ms 0.860ms -1.7% list + author 0.084ms 0.084ms +0.4% 0.110ms 0.104ms -5.5% 1.800ms 1.817ms +1.0% list + comment count 0.203ms 0.193ms -4.9% 0.384ms 0.244ms -36.4% 3.355ms 2.959ms -11.8% list + 3 recent comments 0.128ms 0.125ms -3.1% 0.155ms 0.237ms +53.2% 5.983ms 5.615ms -6.1% issue detail + comments 0.085ms 0.080ms -6.1% 0.104ms 0.106ms +1.5% 0.437ms 0.477ms +9.2% 1,000 rows/collection | source indexes: manual | optimistic writes — geomean 0.99×, cold 0.80×, 1 change(s)
Query Base median PR median Δ median Base p95 PR p95 Δ p95 Base cold PR cold Δ cold list: newest 50 open 0.073ms 0.075ms +2.5% 0.150ms 0.163ms +8.9% 0.817ms 0.828ms +1.4% list: newest 50 open 0.058ms 0.057ms -0.7% 0.091ms 0.089ms -2.3% 0.907ms 0.863ms -4.8% list + author 0.098ms 0.096ms -2.4% 0.147ms 0.116ms -21.1% 1.877ms 1.886ms +0.5% list + comment count 0.178ms 0.204ms +14.1% 0.332ms 0.336ms +1.1% 7.829ms 2.800ms -64.2% 🟢 list + 3 recent comments 0.105ms 0.099ms -6.2% 0.204ms 0.137ms -33.1% 4.699ms 3.931ms -16.4% issue detail + comments 0.087ms 0.079ms -9.3% 0.119ms 0.103ms -13.7% 0.433ms 0.406ms -6.3% 10,000 rows/collection | source indexes: none | synced writes — geomean 0.90×, cold 0.95×, 1 change(s)
Query Base median PR median Δ median Base p95 PR p95 Δ p95 Base cold PR cold Δ cold list: newest 50 open 0.059ms 0.059ms -0.5% 0.080ms 0.075ms -5.5% 71.512ms 65.603ms -8.3% list: newest 50 open 10.343ms 10.349ms +0.1% 11.186ms 11.269ms +0.7% 68.312ms 71.861ms +5.2% list + author 0.159ms 0.106ms -33.3% 0.213ms 0.182ms -14.9% 🟢 198.992ms 212.061ms +6.6% list + comment count 0.175ms 0.182ms +4.2% 0.223ms 0.332ms +49.0% 73.052ms 74.981ms +2.6% list + 3 recent comments 0.132ms 0.109ms -17.6% 0.256ms 0.141ms -44.8% 86.672ms 68.390ms -21.1% issue detail + comments 0.085ms 0.081ms -5.4% 0.125ms 0.103ms -17.7% 5.910ms 5.291ms -10.5% 10,000 rows/collection | source indexes: none | optimistic writes — geomean 0.98×, cold 1.04×
Query Base median PR median Δ median Base p95 PR p95 Δ p95 Base cold PR cold Δ cold list: newest 50 open 0.079ms 0.074ms -6.2% 0.151ms 0.118ms -21.9% 59.096ms 60.721ms +2.7% list: newest 50 open 0.051ms 0.053ms +3.6% 0.103ms 0.108ms +5.0% 59.095ms 59.765ms +1.1% list + author 0.099ms 0.101ms +2.0% 0.154ms 0.191ms +24.3% 197.180ms 186.980ms -5.2% list + comment count 0.205ms 0.201ms -1.9% 0.265ms 0.258ms -2.5% 73.602ms 107.612ms +46.2% list + 3 recent comments 0.101ms 0.096ms -5.4% 0.133ms 0.136ms +2.1% 89.427ms 75.620ms -15.4% issue detail + comments 0.091ms 0.086ms -5.3% 0.120ms 0.115ms -4.2% 5.216ms 5.329ms +2.2% 10,000 rows/collection | source indexes: manual | synced writes — geomean 0.94×, cold 1.07×, 1 change(s)
Query Base median PR median Δ median Base p95 PR p95 Δ p95 Base cold PR cold Δ cold list: newest 50 open 0.070ms 0.063ms -9.9% 0.132ms 0.083ms -37.1% 1.885ms 1.909ms +1.3% list: newest 50 open 0.930ms 0.917ms -1.4% 1.474ms 1.471ms -0.2% 1.865ms 1.810ms -2.9% list + author 0.084ms 0.079ms -5.9% 0.112ms 0.101ms -10.1% 2.774ms 2.542ms -8.4% list + comment count 0.215ms 0.184ms -14.8% 0.265ms 0.222ms -16.3% 6.090ms 3.744ms -38.5% list + 3 recent comments 0.134ms 0.132ms -2.1% 0.190ms 0.224ms +18.0% 5.290ms 14.456ms +173.3% 🔴 issue detail + comments 0.090ms 0.091ms +1.4% 0.149ms 0.133ms -11.2% 0.605ms 0.590ms -2.6% Runner: node v24.8.0, linux 6.17.0-1022-azure, Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz. Timings on shared CI runners are noisy; treat small deltas as indicative only.10,000 rows/collection | source indexes: manual | optimistic writes — geomean 1.05×, cold 0.75×, 2 change(s)
Query Base median PR median Δ median Base p95 PR p95 Δ p95 Base cold PR cold Δ cold list: newest 50 open 0.079ms 0.131ms +64.4% 0.130ms 0.178ms +36.5% 🔴 1.802ms 1.633ms -9.4% list: newest 50 open 0.072ms 0.056ms -22.2% 0.106ms 0.091ms -13.8% 2.687ms 1.654ms -38.4% list + author 0.105ms 0.109ms +3.6% 0.208ms 0.141ms -32.1% 15.625ms 4.744ms -69.6% 🟢 list + comment count 0.221ms 0.223ms +0.9% 0.271ms 0.411ms +51.9% 3.686ms 3.738ms +1.4% list + 3 recent comments 0.111ms 0.110ms -1.0% 0.197ms 0.139ms -29.6% 4.813ms 5.156ms +7.1% issue detail + comments 0.096ms 0.094ms -1.4% 0.132ms 0.119ms -9.5% 0.605ms 0.587ms -3.0% Size Change: 0 B
Total Size: 236 kB
compressed-size-action::db-and-react-package-sizeℹ️ View Unchanged
Filename Size packages/db/dist/esm/client.js5.02 kB packages/db/dist/esm/collection-options-brand.js219 B packages/db/dist/esm/collection-options.js258 B packages/db/dist/esm/collection/change-events.js1.76 kB packages/db/dist/esm/collection/changes.js3.06 kB packages/db/dist/esm/collection/cleanup-queue.js828 B packages/db/dist/esm/collection/config-errors.js547 B packages/db/dist/esm/collection/events.js504 B packages/db/dist/esm/collection/health-tree.js698 B packages/db/dist/esm/collection/index.js6.39 kB packages/db/dist/esm/collection/indexes.js2.3 kB packages/db/dist/esm/collection/lifecycle.js5.59 kB packages/db/dist/esm/collection/mutations.js2.95 kB packages/db/dist/esm/collection/state.js7.27 kB packages/db/dist/esm/collection/subscription.js9.54 kB packages/db/dist/esm/collection/sync.js6.23 kB packages/db/dist/esm/collection/validate-config.js1.17 kB packages/db/dist/esm/deferred.js207 B packages/db/dist/esm/error-message.js642 B packages/db/dist/esm/errors.js7.27 kB packages/db/dist/esm/event-emitter.js1.06 kB packages/db/dist/esm/index.js4.76 kB packages/db/dist/esm/indexed-db-wrapper.js1.91 kB packages/db/dist/esm/indexed-db.js3.81 kB packages/db/dist/esm/indexes/auto-index.js924 B packages/db/dist/esm/indexes/base-index.js1.92 kB packages/db/dist/esm/indexes/basic-index.js1.93 kB packages/db/dist/esm/indexes/btree-index.js1.62 kB packages/db/dist/esm/indexes/index-registry.js916 B packages/db/dist/esm/indexes/reverse-index.js1.01 kB packages/db/dist/esm/live-query-adapter.js845 B packages/db/dist/esm/live-query-observer-client.js2.17 kB packages/db/dist/esm/live-query-observer.js3.3 kB packages/db/dist/esm/live-query-options.js2.02 kB packages/db/dist/esm/live-query-primitives.js406 B packages/db/dist/esm/live-query-window-binding.js1.56 kB packages/db/dist/esm/live-query-window-controller.js4.02 kB packages/db/dist/esm/local-only.js1.02 kB packages/db/dist/esm/local-storage.js4.58 kB packages/db/dist/esm/optimistic-action.js359 B packages/db/dist/esm/paced-mutations.js1.11 kB packages/db/dist/esm/proxy.js3.51 kB packages/db/dist/esm/query/builder/clone-query.js854 B packages/db/dist/esm/query/builder/functions.js1.61 kB packages/db/dist/esm/query/builder/group-keys.js157 B packages/db/dist/esm/query/builder/include-functions.js229 B packages/db/dist/esm/query/builder/index.js7.72 kB packages/db/dist/esm/query/builder/query-ir.js312 B packages/db/dist/esm/query/builder/ref-proxy-identity.js292 B packages/db/dist/esm/query/builder/ref-proxy.js1.67 kB packages/db/dist/esm/query/builder/wrapper-identity.js221 B packages/db/dist/esm/query/compiler/evaluators.js2.51 kB packages/db/dist/esm/query/compiler/expressions.js603 B packages/db/dist/esm/query/compiler/find-aggregate.js328 B packages/db/dist/esm/query/compiler/group-by.js4.42 kB packages/db/dist/esm/query/compiler/grouping.js161 B packages/db/dist/esm/query/compiler/index.js10.4 kB packages/db/dist/esm/query/compiler/joins.js3.42 kB packages/db/dist/esm/query/compiler/lazy-targets.js1.11 kB packages/db/dist/esm/query/compiler/order-by.js2.8 kB packages/db/dist/esm/query/compiler/parent-routes.js319 B packages/db/dist/esm/query/compiler/query-equivalence.js568 B packages/db/dist/esm/query/compiler/route-metadata.js1.24 kB packages/db/dist/esm/query/compiler/select.js1.5 kB packages/db/dist/esm/query/effect.js5.79 kB packages/db/dist/esm/query/equality-conjunct.js486 B packages/db/dist/esm/query/equality-value-identity.js736 B packages/db/dist/esm/query/expression-helpers.js1.61 kB packages/db/dist/esm/query/ir-stable-identity.js4.29 kB packages/db/dist/esm/query/ir.js2.26 kB packages/db/dist/esm/query/join-conditions.js257 B packages/db/dist/esm/query/live-query-collection.js391 B packages/db/dist/esm/query/live/bucket-facade-adapter.js3.17 kB packages/db/dist/esm/query/live/collection-config-builder.js8.24 kB packages/db/dist/esm/query/live/collection-registry.js264 B packages/db/dist/esm/query/live/collection-subscriber.js2.64 kB packages/db/dist/esm/query/live/graph-scheduler.js305 B packages/db/dist/esm/query/live/includes-runtime.js212 B packages/db/dist/esm/query/live/internal.js145 B packages/db/dist/esm/query/live/materialized-pipeline.js1.94 kB packages/db/dist/esm/query/live/ordered-source-loader.js6.47 kB packages/db/dist/esm/query/live/public-key-reduction.js970 B packages/db/dist/esm/query/live/subset-demand-controller.js2.44 kB packages/db/dist/esm/query/live/utils.js1.35 kB packages/db/dist/esm/query/optimizer.js2.95 kB packages/db/dist/esm/query/pooled-live-query.js5.14 kB packages/db/dist/esm/query/pooled-source.js219 B packages/db/dist/esm/query/query-once.js359 B packages/db/dist/esm/query/runtime-reference-identity.js630 B packages/db/dist/esm/query/subset-dedupe.js493 B packages/db/dist/esm/scheduler.js1.23 kB packages/db/dist/esm/SortedMap.js1.77 kB packages/db/dist/esm/strategies/commit-completion.js156 B packages/db/dist/esm/strategies/debounceStrategy.js658 B packages/db/dist/esm/strategies/queueStrategy.js523 B packages/db/dist/esm/strategies/serial-pacer.js486 B packages/db/dist/esm/strategies/throttleStrategy.js738 B packages/db/dist/esm/sync-persistence.js626 B packages/db/dist/esm/sync-receipt.js211 B packages/db/dist/esm/transaction-commit-work.js351 B packages/db/dist/esm/transactions.js4.57 kB packages/db/dist/esm/utils.js1.77 kB packages/db/dist/esm/utils/array-utils.js270 B packages/db/dist/esm/utils/browser-polyfills.js304 B packages/db/dist/esm/utils/btree.js3.02 kB packages/db/dist/esm/utils/callbacks.js219 B packages/db/dist/esm/utils/comparison.js1.95 kB packages/db/dist/esm/utils/cursor.js753 B packages/db/dist/esm/utils/error.js262 B packages/db/dist/esm/utils/get-or-create.js155 B packages/db/dist/esm/utils/index-optimization.js2.58 kB packages/db/dist/esm/utils/source-record.js140 B packages/db/dist/esm/utils/type-guards.js230 B packages/db/dist/esm/utils/uuid.js530 B packages/db/dist/esm/virtual-props.js413 B packages/react-db/dist/esm/DbProvider.js317 B packages/react-db/dist/esm/development.js190 B packages/react-db/dist/esm/HydrationBoundary.js263 B packages/react-db/dist/esm/index.js330 B packages/react-db/dist/esm/live-query-internals.js282 B packages/react-db/dist/esm/source-id-bindings.js339 B packages/react-db/dist/esm/useLiveInfiniteQuery.js1.52 kB packages/react-db/dist/esm/useLiveQuery.js3.41 kB packages/react-db/dist/esm/useLiveQueryEffect.js504 B packages/react-db/dist/esm/useLiveSuspenseQuery.js1.37 kB packages/react-db/dist/esm/usePacedMutations.js429 B More templates
- todos
- offline-first-electron
- @tanstack/db-example-react-action-enforcement
- @tanstack/db-example-react-next-ssr-e2e
- tanstack-start-example-basic
- @tanstack/db-example-paced-mutations-demo
- tanstack-start-db-projects-example
- @tanstack/db-example-react-start-ssr-e2e
- @tanstack/db-example-react-todo
- offline-transactions-react-native
- shopping-list-react-native
- @tanstack/db-example-solid-todo
@tanstack/angular-db
npm i https://pkg.pr.new/TanStack/db/@tanstack/angular-db@2278@tanstack/browser-db-sqlite-persistence
npm i https://pkg.pr.new/TanStack/db/@tanstack/browser-db-sqlite-persistence@2278@tanstack/capacitor-db-sqlite-persistence
npm i https://pkg.pr.new/TanStack/db/@tanstack/capacitor-db-sqlite-persistence@2278@tanstack/cloudflare-durable-objects-db-sqlite-persistence
npm i https://pkg.pr.new/TanStack/db/@tanstack/cloudflare-durable-objects-db-sqlite-persistence@2278@tanstack/convex-db-collection
npm i https://pkg.pr.new/TanStack/db/@tanstack/convex-db-collection@2278@tanstack/db
npm i https://pkg.pr.new/TanStack/db/@tanstack/db@2278@tanstack/db-ivm
npm i https://pkg.pr.new/TanStack/db/@tanstack/db-ivm@2278@tanstack/db-sqlite-persistence-core
npm i https://pkg.pr.new/TanStack/db/@tanstack/db-sqlite-persistence-core@2278@tanstack/electric-db-collection
npm i https://pkg.pr.new/TanStack/db/@tanstack/electric-db-collection@2278@tanstack/electron-db-sqlite-persistence
npm i https://pkg.pr.new/TanStack/db/@tanstack/electron-db-sqlite-persistence@2278@tanstack/expo-db-sqlite-persistence
npm i https://pkg.pr.new/TanStack/db/@tanstack/expo-db-sqlite-persistence@2278@tanstack/node-db-sqlite-persistence
npm i https://pkg.pr.new/TanStack/db/@tanstack/node-db-sqlite-persistence@2278@tanstack/offline-transactions
npm i https://pkg.pr.new/TanStack/db/@tanstack/offline-transactions@2278@tanstack/powersync-db-collection
npm i https://pkg.pr.new/TanStack/db/@tanstack/powersync-db-collection@2278@tanstack/preact-db
npm i https://pkg.pr.new/TanStack/db/@tanstack/preact-db@2278@tanstack/query-db-collection
npm i https://pkg.pr.new/TanStack/db/@tanstack/query-db-collection@2278@tanstack/react-db
npm i https://pkg.pr.new/TanStack/db/@tanstack/react-db@2278@tanstack/react-native-db-sqlite-persistence
npm i https://pkg.pr.new/TanStack/db/@tanstack/react-native-db-sqlite-persistence@2278@tanstack/react-router-with-db
npm i https://pkg.pr.new/TanStack/db/@tanstack/react-router-with-db@2278@tanstack/rxdb-db-collection
npm i https://pkg.pr.new/TanStack/db/@tanstack/rxdb-db-collection@2278@tanstack/solid-db
npm i https://pkg.pr.new/TanStack/db/@tanstack/solid-db@2278@tanstack/svelte-db
npm i https://pkg.pr.new/TanStack/db/@tanstack/svelte-db@2278@tanstack/tauri-db-sqlite-persistence
npm i https://pkg.pr.new/TanStack/db/@tanstack/tauri-db-sqlite-persistence@2278@tanstack/trailbase-db-collection
npm i https://pkg.pr.new/TanStack/db/@tanstack/trailbase-db-collection@2278@tanstack/vue-db
npm i https://pkg.pr.new/TanStack/db/@tanstack/vue-db@2278commit:
93a698aKyleAMathews(GitHub profile, opens in a new tab) closed this
Sign in to join this conversation.
⚠️ No Changeset found#
Latest commit: 93a698a8e45a26cd89de91c5c23926f2e423e45c
Merging this PR will not cause a version bump for any packages. If these changes should not result in a new version, you're good to go. If these changes should result in a version bump, you need to add a changeset.
This PR includes no changesets
When changesets are added to this PR, you'll see the packages that this PR includes changesets for and the associated semver types
Click here to learn what changesets are, and how to add one.
Click here if you're a maintainer who wants to add a changeset to this PR