ITTIA, provider of lightweight database software based in Pacific Northwest, has released a new version of its lightweight SQL R-DBMS relational database management system for embedded systems and mobile devices.
According to the company DB-SQL 2.5 is available at an undisclosed price and new features of version 2.5 of the Linux-compatible DB-SQL R-DBMS include language bindings for Java and C#, as well as VxWorks support. It extends the embedded database to support Java programmers and developers who work with the similar C# which is used in Microsoft's .Net environment. Java applications can now execute SQL queries, or access tables directly with indexed search, via a JNI (Java native interface).
With this release, more mobile and embedded products will benefit from the robust data management facilities of ITTIA DB-SQL to improve stability and scalability without increasing the cost of hardware.
ITTIA DB includes a lightweight SQL engine that would be easy for developers to learn. SQL queries are executed dynamically at run-time, providing great flexibility to developers. ITTIA DB-SQL implements a rich selection of SQL features, including alter table statements, conditional expressions, sequence generators, table set operations, and complex table joins.
Any combination of inner, outer, and full outer joins is possible, and multiple syntaxes are supported, including the USING keyword that is utilized by certain enterprise databases. ITTIA DB truly brings the power of SQL to mobile devices and embedded systems.
ITTIA adds the reliability and scalability of database technology to Wind River's offering. Wind River VxWorks is a family of software development platforms, including a commercial-grade real-time operating system (RTOS), for small-footprint devices.
A new API for ITTIA DB provides Java applications direct access to ITTIA DB database files through the standard JNI interface. Java applications can execute SQL queries, or access tables directly with indexed search. The ITTIA DB-SQL Java API is fully integrated with the Java type system, making it easy to share database files between Java applications and C/C++ software. Unicode strings are converted to the correct format automatically and binary large object (BLOB) fields enable storage of arbitrarily-large byte arrays.
Support for C# and other .NET languages has also been added using the P/Invoke interface. The same ITTIA DB-SQL API is used in .NET as in Java, with minor changes to accommodate the .NET type system and syntax.
According to Sasan Montaseri, ITTIA President, “the increase in customer awareness and adoption for embedded databases is a evidence to our commitment to embedded developers building the next generation of embedded and mobile applications.”
“Our goal is to offer developers the option of selecting quality embedded database software at a very reasonable cost. We continue to innovate and position our ITTIA DB product, so that our customers can avoid the cost, time and risk of building database software themselves.”
Related Links
linuxdevices