October 17, 2011 — Bellevue, WA — ITTIA, a global leader in data management software, provides database comparison facts about ITTIA DB SQL 4.1.1 and SQLite 3.7.8 for application developers of intelligent devices, embedded systems and mobile devices, with exceptional results for ITTIA DB SQL.
News Highlights
Performance
ITTIA DB SQL significantly outperforms SQLite in write throughput, boasting insert and update performance that is, respectively, ten and fifty times faster on flash media. Even for databases stored on hard disk, ITTIA DB SQL write performance is at least 200% faster than SQLite. Read access for the same data is competitive with SQLite. ITTIA provides public access to this feature comparison and benchmark results.
Concurrency
Unlike SQLite, ITTIA DB SQL is built and designed for multi-threaded, multi-user application development. Applications embedded with ITTIA DB SQL can run transactions in parallel, allowing long-running tasks such as synchronization to run without blocking normal operations. Both multi-threaded and client/server concurrency are supported.
High Availability
Applications can protect mission-critical data with ITTIA DB SQL replication, which automatically distributes data so that failure of one component does not threaten the entire system. While SQLite provides no built-in replication, ITTIA DB SQL offers the choice of recording changes in a replication log to be exchanged asynchronously, or applying updates immediately with two-phase commit.
Synchronization
ITTIA DB Synch extends data distribution to enterprise RDBMS products, so that devices embedded with ITTIA DB SQL can efficiently share data with a back-end server. Applications can access this data replication environment to greatly improve availability, reliability, modularity, mobility, and interoperability by synchronizing device data with a back-end RDBMS.
Comparison of ITTIA DB and SQLite White Paper
A white paper that compares the performance and feature set of ITTIA DB SQL to SQLite is available at:
http://www.ittia.com/resources/white-paper-comparison-ittia-db-and-sqlite
About ITTIA
ITTIA provides software and services for data management, offering standards, ease of use, and flexibility to our customers. Benefits of selecting ITTIA's technologies include leading-edge software, comprehensive documentation, scalability, efficiency, exceptional performance, and low total cost of ownership. Learn how customers such as Freescale Semiconductor, Panasonic, Puget Sound Energy, Fresenius, Boeing, and others have valued from ITTIA by visiting: http://www.ittia.com
