When an edge device needs to store and query sensor data, high performance and scalability need to be achieved with minimum footprint. An embeddable database library offers developers a convenient interface to store time series data on various types of flash media.
SQLite is a database engine written in the C programming language that software developers embed in their apps. As such, it belongs to the family of embedded databases. ITTIA DB is a commercial embeddable database written in the C and C++ programming languages. It is ideal for sensors and IoT devices to stream, understand, and store real-time data acquired from sensors and other IoT nodes.
This white paper compares the two technologies on Intel and Arm architectures, with Linux, and shares critical findings.