demo_products
product_id · name · categoryNames and categories can change in the same source transaction as a sale.
LIVE COMMERCE / TWO MAINTAINED SQL VIEWS
What’s selling now.
Sales land. Refunds happen. The leaderboard moves.
Watch a real SQL join turn changing data into a live top ten.
The live ten 10
Next bulk order~5s
A real result table determines every position.
Connecting to the maintained leaderboard…
Ranked by net revenue, descending. Product ID breaks ties. Awaiting the first committed snapshot.
UNDER THE HOOD
Two inputs. Two views.
Continuously maintained.
The product catalog supplies names and categories. Order lines carry signed quantities and their own historical unit price. A refund has negative quantity; a canceled line is deleted. These are line items, not order counts.
demo_order_lines
line_id · product_id · quantity
unit_price_centsNet revenue = SUM(quantity × unit_price_cents). Catalog edits never reprice historical lines.
Aggregate the facts. Join the catalog.
Awaiting durable progress
Maintain the ranking and its cutoff.
Awaiting durable progress
All maintained product totals
THE SECOND RESULT VIEW · NOT DERIVED FROM THE TOP TEN| Product | Category | Line items | Net units | Net revenue |
|---|
Each query has its own worker, source slot, state and committed result. Snapshots can represent different source transactions. Browser notifications trigger authoritative refetches.
THE ENGINE ROOM
Both queries.
Nothing hidden.
Independent process measurements and server history for the all-products query and the top-ten query. Sample ages and missing values stay explicit.
Process counters reset on worker restart. Latency distributions cover the preceding 60 seconds; browser delivery is excluded. Commit observers follow each query’s durable progress even if no result row changes. CPU and PUT-only request counts are not collected.
All-products query · server history
One point per minute. Missing intervals stay blank.
Loading measurements…
Top-ten query · server history
One point per minute. Missing intervals stay blank.
Loading measurements…