Python is a high-level interpreted programming language with a friendly syntax and elegant design. Python scripts are easy to read, often resembling pseudo code. ITTIA DB SQL now supports Python with a new API for Dynamic Scripting Languages.
Application developers have a new option to organize tables in an ITTIA DB SQL database: clustered indexes reduce the file size for many common table definitions. Storing full rows in the clustering index also improves the performance of data retrieval operations on database tables. This unique method allows embedded and mobile developers to save disk space while benefiting from the flexibility of relational data modeling.
Version 5.4 also adds core improvements to the ITTIA DB SQL query engine. Applications can reposition a scrollable cursor anywhere in a result set, and then navigate forward and backward. All statements support static cursors, for which the result set remains consistent during each execution. Dynamic cursors expose changes to the result set for supported statements.
Support for Unicode in SQL query strings is another core improvement. ITTIA DB SQL has always supported Unicode types and parameter bindings, in addition to the default encoding of the target system. Now Unicode string literals can also be included directly in SQL queries using UTF-8, UTF-16, or UTF-32 encoding.
Client/server is an optional feature of ITTIA DB SQL that enables multiprocess and remote network access to database files. With this new release, client/server has been optimized for low latency connections, improving performance by several magnitudes. Whether client/server is used to centralize database resources or to support data distribution, ITTIA DB SQL applications will benefit greatly from this optimization.
Data distribution is an important challenge for embedded and mobile systems, and developers often search for a feature to allow them share and communicate data bidirectionally between a device and a back-end enterprise RDBMS. This release includes full support for synchronization to both send and receive data in a back-end enterprise database. In addition, the ITTIA DB synchronization framework can detect and resolve conflicts according to rules defined by the application.