AltSql Mesh Live Demo

A sheep farm with no mobile coverage and no gateway. Three utes, four quad bikes and five people on foot carry a device each. They read the water troughs, open and close gates, add jobs and clear them, and count sheep, all into one shared table. Whenever two come within radio range they sync, over a link that loses messages. Stop the writing and watch every device end up with the same table.

Simulated farm, real engines. The farm, the people and the radio are simulated. Twelve copies of AltSql Core and AltSql Mesh run in this page, compiled to WebAssembly, one per device.

How to Run It

1. Half an hour of work. Everyone drives and walks, writes what they see, and syncs on the way.
2. Stop writing. Watch the differences shrink to zero: the same table everywhere.
3. Ask two devices. The same SQL on device 0 and device 9: the same answer.
4. Pull the plug. The power goes on a device in the middle of a write.

On a wide screen the demo has more room: open it full screen.

About AltSql Mesh

AltSql Mesh lets the devices of a fleet share one table with no gateway or server. Each device writes to its own copy, and whenever two come within radio range they bring each other up to date. In the tests, fleets of 2 to 32 devices meeting at random over links that lost up to 30% of their messages all ended with the same table, and a meeting with nothing new cost 484 bytes in a fleet of 12.

AltSql Mesh is a prototype, all rights reserved. It works and is tested in simulation on a PC, and it has not yet run on a microcontroller or over a real radio: that is the Beta. Its Alpha report sets out how it was built and tested, and how each figure was measured or computed. Device makers and investors can ask for it through the contact page.

More: all live demos and the engines.