Embedded database improves QNX performance

 ITTIA DB SQL allows database file sharing between QNX processes, and efficient table synchronisation between QNX devices and back-end RDBMS products. A notable introduction to the database is the new graphics and user interface features for applications to intuitively display data, visualize queries, and store user input. With support for the Qt framework, applications can directly query ITTIA DB SQL tables into the user interface and manipulate data interactively.

Increasing efficiency and safety of data storage, the Power-Safe filesystem now uses the TRIM command to accelerate NAND flash media devices, which can greatly improve transaction throughput in an ITTIA DB SQL database. OpenSSL has also been upgraded, which improves the security of database replication and sharing over the network.

Additional key improvements include:

•    Significant performance in write throughput, boasting high insert and update performance both on flash media and hard disk;
•    Concurrency allowing long-running tasks such as synchronization to run without blocking normal operations;
•    Replication used to share information between redundant resources to improve reliability, fault-tolerance, or accessibility;
•    High availability, minimizing the various kinds of downtime that can affect an embedded system;
•    Distribution to sync with the cloud, using built-in change tracking and ITTIA DB Sync to efficiently send and receive data stored in a back-end RDBMS.

A free evaluation of ITTIA DB SQL for QNX is available at the ITTIA DB Evaluation Center. The evaluation kit contains a complete embedded database library, optional server, support for both on-disk and in-memory data management and SQL tools.