Manufacturing
A production line emits events that must never be lost or overwritten, alongside quality and supply records that change. UltraFabric gives the events append-only semantics and the records transactions.
Workload shape
| Writes | Append-only events plus record updates |
|---|---|
| Reads | Shift reports, traceability queries |
| Tenancy | Plants, lines, suppliers |
| Guarantee | No silent replacement |
How the data lands
Design fit, not a customer claim: which parts of UltraFabric carry which parts of this workload.
- Line events as columnar collections where an existing key is an error, never an overwrite
- Quality, batch and supplier records as rows under snapshot isolation
- Per-plant or per-supplier tenants with plant-wide analytics
What it looks like
Append-only is a property of the collection, not a convention the application must remember.
CREATE TABLE line_events (id bigint PRIMARY KEY, line text NOT NULL,
at timestamp, station text, result text) WITH (storage = columnar);
INSERT INTO line_events VALUES (184201, 'L3', '2026-10-23 08:12:04', 'S7', 'pass');
-- a second insert of id 184201 fails: duplicate key (23505)Built today, coming next
Everything in the first column is in the repository and tested; the second column is the roadmap in order.
Built today
- SQL INSERT into a columnar collection fails with 23505 on an existing key
- Compaction moves rows into groups atomically; a snapshot sees each row once
- Idempotent writes with client keys for retried batches
Next
- Updates and deletes on columnar collections
- Automatic background compaction
- Streaming ingestion
Other use cases
Airports & Aviation
An airport runs many organisations on one estate: the operator, airlines, ground handlers, security and government agencies.
Smart Cities
A city platform collects from traffic, lighting, water, waste and safety systems, each owned by a different department, often with different vendors.
Power & Utilities
Grid operators keep two kinds of data that rarely live well together: dense measurement streams and slow-changing asset records.
Public Sector
Government platforms host many departments on shared infrastructure, each with statutory limits on who may see what.
Tell us about yours.
Early access starts with a conversation about the workload you would move first.