DeviceSQL upgrade enhances performance, efficiency, and developer control - Embedded.com

DeviceSQL upgrade enhances performance, efficiency, and developer control

Burlingame, Calif. — Encirq Corp. has released DeviceSQL 4.0, a major upgrade to its software development kit (SDK) for building embedded databases and data manipulation code for embedded device applications. The upgrade offers numerous features and enhancements for increased performance, efficiency and developer control.

New features and enhancements include:

  • Compression adapters that can reduce data storage requirements by 50%, allowing applications to make more efficient use of available storage capacity.
  • Two new indexing services: MPHash Lite and MPAVL. MPHash Lite increases the performance of applications that store large amounts of data by enabling the creation of efficient in-memory hash indexes against tables that might otherwise have exceeded available memory space. MPAVL indexing allows applications to perform efficient range scans of paged table data, boosting performance for applications that store data in flash memory or disk.
  • Index open/close functionality for dynamically opening and closing indexes as needed by the application to optimize performance and memory usage.
  • Lite storage service for performing fast writes for paged data, improving DeviceSQL for data logging applications or any other applications where the data can be re-broadcast.
  • In-place update capability that improves performance by allowing an UPDATE to replace an existing row of data rather than perform a DELETE and then an INSERT.
  • Iterative search results for faster, more memory-efficient queries.
  • Database handle service to allow an application to access multiple, discrete DeviceSQL databases within the same application.
  • Data encryption for encrypting table and index data for enhanced security.
  • Recovery callback functionality that allows for a developer-defined function to execute when a data file needs recovery. This function can determine whether to continue with recovery (open the database) or halt the application (close the database), enhancing developer control.
  • Compact row headers that reduce persistent file sizes by 4 bytes per row, significantly reducing the file size for tables that contain a large number of rows.
  • A new fixed-size paged storage service that reduces persistent file sizes by 2 bytes per row and can eliminate fragmentation.
  • File size usage threshold limits that enable developers to restrict the size of a paged data file to ensure that hardware and/or application constraints are not exceeded.

DeviceSQL 4.0 also features a number of new tools and capabilities for probing DeviceSQL databases and the effect of transactions. These include the SQL Probe Tool that allows developers to access data in a DeviceSQL data file by enabling reading and writing directly from the file without the need for a separate application. It also allows tables to be loaded from, or saved to, a .CSV file.

The upgrade has also added a remote DB query tool that allows for remote updates and queries on DeviceSQL data files, and a new “view number of rows affected” function that allows developers to determine the number of rows affected after an UPDATE or DELETE operation.

Another major new capability available with DeviceSQL 4.0 is operation as a “stand-alone” embedded database. For the first time, a DeviceSQL database can be started, accessed, manipulated and closed exclusively with DeviceSQL's Dynamic C or Interpreted SQL interfaces. This new capability allows developers to embed a compact, high-performance embedded database into their applications without requiring any compiled DeviceSQL language code.

Product information: DeviceSQL

Encirq Corp. , www.encirq.com

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.