ITTIA announces a new release of ITTIA DB SQL, version 5.4, available on Windows, Linux, Android, QNX, ThreadX, VxWorks and environments with no operating system. This latest release provides the capability for embedded and mobile applications to distribute data with Oracle, SQL Server, or any other desired back-end enterprise databases, and includes many new features, such as clustered indexes, scrollable SQL cursors, a Python scripting API, and Unicode SQL query strings.
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.
ITTIA provides high-performance embedded RDBMS technology for developers of applications for mobile devices and other embedded systems, and continues this trend with its latest release of ITTIA DB SQL.
Try ITTIA DB SQL New Release
A free copy of ITTIA DB SQL, version 5.4, is available for evaluation at:
Free Video to Learn About ITTIA DB SQL
A free video offers for you to learn about the ITTIA DB SQL database architecture in few minutes:
ITTIA offers database solutions for platforms where limited memory, storage, and processing power makes software development challenging. ITTIA develops fast, high performance database products and tools with the goal of providing excellent data management software for embedded systems and devices. ITTIA products are designed to be suitable for application development and deployment at a significantly reduced cost. ITTIA customers include GlaxoSmithKline, VNU, Boeing, Moodys, Sandia National Laboratory, Puget Sound Energy and others. You can obtain more information about ITTIA at: www.ittia.com.