Host-neutral help (deployment-specific facts removed), registered with
HelpBundles, gated by HelpBundleAssertions. QQQ 4.1.0-RC.7.
Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
The foreign key on lab_report.run_id rejects develop's placeholder run 999999,
so the 40-day-old report now belongs to an inserted FAILED run.
Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
A join's child column is on the side whose field is not the primary key,
so a many-to-one join (child -> parent) is checked on the child too.
Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
Changesets 12-26 add a foreign key for each possible-value reference between
the QBit's tables, named fk_<child table>_<column>:
- lab_finding.run_id, lab_report.run_id -> lab_run: CASCADE (owned detail)
- comparison.change_event_id -> change_event: CASCADE (computed for the change)
- regression.cause_change_event_id, lab_run.change_event_id -> change_event,
regression.first_run_id / checkpoint_run_id -> lab_run: SET NULL (pointers)
- lab_run / lab_finding / regression / comparison .target_id -> target and
regression.budget_id -> budget: RESTRICT (history is kept, D8; pages and
budgets are disabled, not deleted; the QBit never deletes either)
Each changeset first records parent-less rows in qqq_fk_quarantine and nulls
them (or, for the NOT NULL run_id columns, copies the row as JSON and deletes
it, PostgreSQL only), and is marked ran when the constraint already exists.
Changeset 12 indexes the foreign key columns that had no leading index.
WebPerfForeignKeyTest runs the changelog with Liquibase on PostgreSQL
(Testcontainers), checks the orphan path and re-run idempotency, and fails
when a table reference in the meta-data has no constraint.
Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
The regression, budget, change event and comparison tables had list
screens but nothing wrote them; the open regression count was a
hard-coded 0 and budgets were never evaluated.
- Change events: new build ids from the DeployProbe and ChangeEventSource
events become durable, idempotent change_event rows (event_key);
lab runs record the deployment (change event) and CDN stage.
- Budgets are evaluated after lab runs and field imports; breaches open
or refresh regressions.
- Regression detection compares new results with the baseline per page,
strategy and metric as the design describes, links the likely change,
confirms before opening, and resolves on recovery. The open regression
count is real.
- Before/after comparisons are written per change event.
- Dismiss and Mark resolved are standard record actions on regressions.
- Optional alerts through core QAlerts (logging sink without the Alerts
qbit). QQQ BOM moves to the released 4.1.0-RC.6 for core alerts.
- Changeset 11 adds the progress and identity columns.
Refs #8
Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
Tier, scope, source, strategy, metric, comparator and severity were free
text, so a typo such as "key" for KEY silently dropped a page from the
daily key-page tests. Each now uses an enum possible value source with
plain labels and the stored values the code already compares against
(no data migration).
Tested Pages offered Insert while URL was not editable but required, so
a manual insert could never succeed. URL is now editable and validated
(absolute https, no credentials or fragment) by TargetCustomizer, which
also fills path, site, source MANUAL and inSitemap false.
Refs #8
Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
Permission base webPerformance -> web_performance (read, write, test,
admin, view). Process and widget names stay webPerformance*.
Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
Owner rule (2026-10-12): table names are lowercase snake_case and every
qbit prefixes its tables with its full name, no abbreviations.
- table prefix webperf_ -> web_performance_ (tables, backend names,
possible-value sources)
- Liquibase property webperf.tablePrefix -> web_performance.tablePrefix,
changelog webperf.changelog.sql -> web_performance.changelog.sql
- name prefix and permission base webperf -> webPerformance (processes,
widgets, process fields, permissions)
Java package and class names unchanged.
Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
- PsiLabRunner (PageSpeed Insights v5, every category, key never in errors)
and LabResultParser (Lighthouse 13 scores, metrics, LCP element, findings
keyed by audit id and Lighthouse version, PSI field data)
- CruxClient (CrUX queryRecord; 404 is NO_DATA, stored as such)
- WebPerfService: sitemap sync (nothing deleted), queue with merge and
daily cap (SKIPPED_QUOTA), worker with conditional claim, retry with
backoff, findings, gzipped full report, latest page results; CrUX upsert
- standard streamed ETL actions: Test page speed (pages and content
records), Run site audit, Sync pages from sitemap, Retry, Refresh Google
field data; hidden scheduled worker, daily key pages, weekly audit,
daily sync and CrUX
- Performance home widgets (Site Scores, Trend, Slowest Pages, Top
Opportunities, Google Field Data, Recent Runs) and the record
Performance panel; readable at every width, real data only
- tests on H2 with the real changelog and a real Lighthouse 13 result of
www.kof22.com, Google stood in by a local HTTP server
Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
Local skeleton of the web performance QBit designed in QRun-IO/qqq
docs/specs/2026-10-12-web-performance-design.md (PR #1088; owner decisions
D1-D13 accepted 2026-10-12, D9 amended: alerts via the Alerts qbit).
- WebPerfQBitProducer and WebPerfQBitConfig (validation, namespace prefix,
duplicate-install guard, Google API key optional and redacted)
- nine visible webperf_ tables, lookups and the Performance app; machine
tables read-only and unaudited, people-edited tables field-audited
- host-included prefix-parameterized changelog with the seeded budgets
- SPIs: UrlSource, ContentResolver, LabRunner, DeployProbe, RumSource,
ChangeEventSource
- SitemapUrlSource (XXE-safe, sitemap index) and HttpBuildIdProbe
(Website-Frontend /api/build)
No PSI/CrUX runner yet: that waits for the Google API key.
Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
