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 …
case studies
A temperature sensor on a machine takes one reading a second. When the machine runs hot, the fan has to come on right away, whether or not the plant’s Wi-Fi is …