AltSql is one small engine and one set of records. Get/put goes straight to a record, SQL asks questions of the same records, and nothing is translated between the device and the gateway. Devices keep working and deciding when the link drops.
About 15 KB
The key-value side on a sensor, with time-series and sync. Compiled for a Cortex-M4, not yet run on one
5 times
Reads by key on the gateway, against SQLite answering the same read through SQL
400,000
Simulated power cuts in one run, with nothing saved lost
100,000
Random SQL statements on the gateway, with the same answers as SQLite
Measured on a PC in the Alphas, with chips, links and files simulated. The Beta measures every number again on real hardware.
technology
AltSql is a native hybrid of key-value and SQL, in the engine and in the database: one small engine and one set of records, from the sensor to the gateway, with nothing …
open source
For now the project focuses on two products: the engine, AltSql Core, and the database, AltSql DB. Both are open source under the Apache License 2.0. The code is on …
technology
A connected product usually handles its data on two computers. The device is a microcontroller with kilobytes of RAM, flash that wears with every erase, and power that …
database
AltSql DB 0.3 adds the two things a gateway database needs once it holds real data. Tables get secondary indexes, so a question about a column other than the key no …
technology
The idea. A native hybrid of key-value and SQL: a very small database on the device that reads the sensors, keeping its data so that the gateway’s database can use …
database
AltSql DB 0.2 makes the two ways into the database follow the same rules, and it makes sync cope with batches that arrive out of order. It also comes with a shell of its …
modules
AltSql Core keeps a device’s readings and settings in its own flash and copies the same records to its gateway, byte for byte. A gateway that serves a whole fleet …
modules
AltSql Core is the base module, the one the project started with. It keeps key-value data and time-series readings on a device, answers SQL on a gateway, and copies the …
modules
An engineer wants to know which machines ran hot last night. The usual way is to pull every machine’s readings to a server first and ask there. That moves every raw …
Device makers who want to see AltSql on their own board, with their own data, can start planning a pilot now. The pilot page says who it suits, what to bring and how it would run.