Embedded Linux SQL database adds Java, C# bindings

Click here to learn
about this Sponsor:

Home | News | Articles | Polls | Forum

Keywords: Match:

May 07, 2008

ITTIA has released a new version of its lightweight SQL R-DBMS (relational database management system) for embedded systems and mobile devices. Version 2.5 of the Linux-compatible DB-SQL R-DBMS adds language bindings for Java and C#, as well as VxWorks support, says ITTIA.

In December, ITTIA announced the first SQL version of its low-footprint DB database. Like DB, which was called "Fuel" when first launched, DB-SQL boasts a runtime footprint measurable in kilobytes. In addition to matching DB's support for C/C++, it supports ANSI SQL-89 and "much of SQL 99 and SQL 2003," ITTIA says.

Version 2.5 extends the embedded database to support Java programmers and developers who work with the similar C# ("C Sharp"), 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).

The Java API is fully integrated with the Java type system, says ITTIA, easing file-sharing between Java applications and C/C++ software. Unicode strings are converted automatically, says the company, and binary large object (BLOB) fields are available to store arbitrarily-large byte arrays. The same API (slightly modified) supports C# and other .Net languages via the P/Invoke interface.

DB-SQL in standalone (left) and client-server (right) modes
As with DB, the SQL version is available as a set of library files that can be embedded within applications so no external server is required. Alternatively, DB-SQL can be built up into separate client and server components that run as separate processes (see diagram above). DB-SQL can be configured to use its own platform-independent file format for database files, enabling users to transfer their DB-SQL applications between different systems as a simple file-copy, says ITTIA.

The database provides transaction completion modes, such as group commit, to minimize I/O, says the company, and it provides dynamic schema alteration for streamlining software upgrades. In addition, applications can be upgraded to support shared access over a network, with row-level locking based on isolation levels. DB-SQL supports SQL features including alter table statements, conditional expressions, sequence generators, table set operations (union, except, and intersect), and complex table joins, says the company. It is also said to support any combination of inner, outer, and full outer joins, as well as multiple syntaxes, including the "USING" keyword.

Availability

DB-SQL 2.5 is available now, at an undisclosed price. ITTIA, a database consulting, products, and services company based in the Pacific Northwest, also maintains the classic, open-source db.* database.

Related Stories:

(Click here for further information)

7 Advantages of D2D Backup
For decades, tape has been the backup medium of choice. But, now, disk-to-disk (D2D) backup is gaining in favor. Learn why you should make the move in this whitepaper.

4 Legal Reasons to Control Internet Access
The Internet is obviously a valuable resource for many organizations. However, many are exposed to legal liability concerns because they fail to control Internet access. Learn if you're safe in this white paper.

Rapidly Resolve J2EE Application Problems
Whether you are in the process of building J2EE applications or have J2EE applications already running in production, you must ensure that they deliver the expected ROI. Learn how in this white paper.

Load Testing 2.0 for Web 2.0
There are many unknowns in stress testing Web 2.0 applications. Find out how to test the performance of Web 2.0 in this white paper.

Build Better Games Online
For the game infrastructure providers, life is complex. Making money from games has become more complicated. Why? Find out in this white paper.

Building a Virtual Infrastructure from Servers to Storage
This white paper discusses the virtual storage solutions that reduce cost, increase storage utilization, and address the challenges of backing up and restoring Server environments.

Gaining Faster Wireless Connections with WiMAX
Welcome to what is quickly becoming the hyperconnected world where anything that would benefit from being connected to the network will be connected. Learn more in this white paper.

Is Your Desktop a Security Threat?
The new wave of sophisticated crimeware not only targets specific companies, but also targets desktops and laptops as backdoor entryways into those business’ operations and resources. Learn how to stay safe in this white paper.

Increasing SAN Reliability by 100 Percent
Storage area networks (SAN) are a strong part of storage plans. Learn how to increase your reliability and uptime by 100 percent in this case study.

Got a HOT tip? please tell us!

Click here for a profile of each sponsor:

PLATINUM SPONSORS
<a href="http://ad.doubleclick.net/jump/entzd.linuxdevices/desktop;kw=timesys;pos=top;dcopt=ist;zdid=a221772;tile=1;sz=150x30;ord=<script=JavaScript>document.write(Math.round(Math.random()10000000000));</script>?"" style="border-width:0px;height:150px;width:30px;"><img src="http://ad.doubleclick.net/ad/entzd.linuxdevices/desktop;kw=timesys;pos=top;dcopt=ist;zdid=a221772;tile=1;sz=150x30;ord=<script=JavaScript>document.write(Math.round(Math.random()10000000000));</script>?" style="border:0; height: 150; width:30;" /></a>		<a href="http://ad.doubleclick.net/jump/entzd.linuxdevices/desktop;kw=windriver;pos=top;dcopt=ist;zdid=a221772;tile=1;sz=150x30;ord=<script=JavaScript>document.write(Math.round(Math.random()10000000000));</script>?"" style="border-width:0px;height:150px;width:30px;"><img src="http://ad.doubleclick.net/ad/entzd.linuxdevices/desktop;kw=windriver;pos=top;dcopt=ist;zdid=a221772;tile=1;sz=150x30;ord=<script=JavaScript>document.write(Math.round(Math.random()10000000000));</script>?" style="border:0; height: 150; width:30;" /></a>

<a href="http://ad.doubleclick.net/jump/entzd.linuxdevices/desktop;kw=versalogic;pos=top;dcopt=ist;zdid=a221772;tile=1;sz=150x30;ord=<script=JavaScript>document.write(Math.round(Math.random()10000000000));</script>?"" style="border-width:0px;height:150px;width:30px;"><img src="http://ad.doubleclick.net/ad/entzd.linuxdevices/desktop;kw=versalogic;pos=top;dcopt=ist;zdid=a221772;tile=1;sz=150x30;ord=<script=JavaScript>document.write(Math.round(Math.random()10000000000));</script>?" style="border:0; height: 150; width:30;" /></a>		<a href="http://ad.doubleclick.net/jump/entzd.linuxdevices/desktop;kw=winsystems;pos=top;dcopt=ist;zdid=a221772;tile=1;sz=150x30;ord=<script=JavaScript>document.write(Math.round(Math.random()10000000000));</script>?"" style="border-width:0px;height:150px;width:30px;"><img src="http://ad.doubleclick.net/ad/entzd.linuxdevices/desktop;kw=winsystems;pos=top;dcopt=ist;zdid=a221772;tile=1;sz=150x30;ord=<script=JavaScript>document.write(Math.round(Math.random()10000000000));</script>?" style="border:0; height: 150; width:30;" /></a>

<a href="http://ad.doubleclick.net/jump/entzd.linuxdevices/desktop;kw=virtuallogix;pos=top;dcopt=ist;zdid=a221772;tile=1;sz=150x30;ord=<script=JavaScript>document.write(Math.round(Math.random()10000000000));</script>?"" style="border-width:0px;height:150px;width:30px;"><img src="http://ad.doubleclick.net/ad/entzd.linuxdevices/desktop;kw=virtuallogix;pos=top;dcopt=ist;zdid=a221772;tile=1;sz=150x30;ord=<script=JavaScript>document.write(Math.round(Math.random()10000000000));</script>?" style="border:0; height: 150; width:30;" /></a>		<a href="http://ad.doubleclick.net/jump/entzd.linuxdevices/desktop;kw=trolltech;pos=top;dcopt=ist;zdid=a221772;tile=1;sz=150x30;ord=<script=JavaScript>document.write(Math.round(Math.random()10000000000));</script>?"" style="border-width:0px;height:150px;width:30px;"><img src="http://ad.doubleclick.net/ad/entzd.linuxdevices/desktop;kw=trolltech;pos=top;dcopt=ist;zdid=a221772;tile=1;sz=150x30;ord=<script=JavaScript>document.write(Math.round(Math.random()10000000000));</script>?" style="border:0; height: 150; width:30;" /></a>

<a href="http://ad.doubleclick.net/jump/entzd.linuxdevices/desktop;kw=montavista;pos=top;dcopt=ist;zdid=a221772;tile=1;sz=150x30;ord=<script=JavaScript>document.write(Math.round(Math.random()10000000000));</script>?"" style="border-width:0px;height:150px;width:30px;"><img src="http://ad.doubleclick.net/ad/entzd.linuxdevices/desktop;kw=montavista;pos=top;dcopt=ist;zdid=a221772;tile=1;sz=150x30;ord=<script=JavaScript>document.write(Math.round(Math.random()10000000000));</script>?" style="border:0; height: 150; width:30;" /></a>		<a href="http://ad.doubleclick.net/jump/entzd.linuxdevices/desktop;kw=calaosystems;pos=top;dcopt=ist;zdid=a221772;tile=1;sz=150x30;ord=<script=JavaScript>document.write(Math.round(Math.random()10000000000));</script>?"" style="border-width:0px;height:150px;width:30px;"><img src="http://ad.doubleclick.net/ad/entzd.linuxdevices/desktop;kw=calaosystems;pos=top;dcopt=ist;zdid=a221772;tile=1;sz=150x30;ord=<script=JavaScript>document.write(Math.round(Math.random()10000000000));</script>?" style="border:0; height: 150; width:30;" /></a>

<a href="http://ad.doubleclick.net/jump/entzd.linuxdevices/desktop;kw=technologicsystems;pos=top;dcopt=ist;zdid=a221772;tile=1;sz=150x30;ord=<script=JavaScript>document.write(Math.round(Math.random()10000000000));</script>?"" style="border-width:0px;height:150px;width:30px;"><img src="http://ad.doubleclick.net/ad/entzd.linuxdevices/desktop;kw=technologicsystems;pos=top;dcopt=ist;zdid=a221772;tile=1;sz=150x30;ord=<script=JavaScript>document.write(Math.round(Math.random()10000000000));</script>?" style="border:0; height: 150; width:30;" /></a>		<a href="http://ad.doubleclick.net/jump/entzd.linuxdevices/desktop;kw=technicalsolutions;pos=top;dcopt=ist;zdid=a221772;tile=1;sz=150x30;ord=<script=JavaScript>document.write(Math.round(Math.random()10000000000));</script>?"" style="border-width:0px;height:150px;width:30px;"><img src="http://ad.doubleclick.net/ad/entzd.linuxdevices/desktop;kw=technicalsolutions;pos=top;dcopt=ist;zdid=a221772;tile=1;sz=150x30;ord=<script=JavaScript>document.write(Math.round(Math.random()10000000000));</script>?" style="border:0; height: 150; width:30;" /></a>

GOLD SPONSORS
<a href="http://ad.doubleclick.net/jump/entzd.linuxdevices/desktop;kw=ultimate;pos=top;dcopt=ist;zdid=a221772;tile=1;sz=150x30;ord=<script=JavaScript>document.write(Math.round(Math.random()10000000000));</script>?"" style="border-width:0px;height:150px;width:30px;"><img src="http://ad.doubleclick.net/ad/entzd.linuxdevices/desktop;kw=ultimate;pos=top;dcopt=ist;zdid=a221772;tile=1;sz=150x30;ord=<script=JavaScript>document.write(Math.round(Math.random()10000000000));</script>?" style="border:0; height: 150; width:30;" /></a>		(Become a sponsor)

ADVERTISEMENT
(Advertise here)

Check out the latest Linux powered...

mobile phones!

other cool
gadgets

HOWTOs: from DevShed & IBM DeveloperWorks:

BREAKING NEWS

• Push email gains ad-friendly Web 2.0 app integration
• Hats off to Fedora 9
• Lightweight browser ported to Linux-friendly DSP
• Web-based app server ported to tiny ARM9 CPU module
• Linux-ready SDIO controller supports multiple memory cards
• Linux-based touchpanel targets elderly homecare
• Balanced XIP and the AXFS filesystem
• ARM-based controller has StackableUSB expansion
• Intel multi-core threading library supports Sun Studio
• Multi-protocol wireless mesh gateway runs Debian
• Embedded Linux is doomed. DOOOMED!
• Article explores Linux hot-patching utility
• Sun demo's RIA tools on Android
• Panel PCs support PoE, Linux
• New Palms on horizon?

Linux-Watch headlines:
• Hats off to Fedora 9
• Running a small business on desktop Linux
• Sun launches OpenSolaris
• Via tiptoes toward openness
• Linux certification comes to Italy
• Installing Ubuntu Hardy Heron as a web hosting server
• Black Duck Buys Koders
• Open source conference co-locates with Ubuntu show
• Ubuntu 8.04 ready to challenge Windows
• KDE Linux reaches 52 million Brazilian kids

Also visit our sister site:

Sign up for LinuxDevices.com's...

news feed

Use of this site is governed by our Terms of Service and Privacy Policy. Except where otherwise specified, the contents of this site are copyright © 1999-2008 Ziff Davis Enterprise Holdings Inc. All Rights Reserved. Reproduction in whole or in part in any form or medium without express written permission of Ziff Davis Enterprise is prohibited. Linux is a registered trademark of Linus Torvalds. All other marks are the property of their respective owners.