Sybase IQ ETL technology includes a built-in, general purpose, relational database to be used for temporary data storage and staging. It is based on SQLite, a very fast, widely used, mostly SQL-92 compliant database. SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine.
The features include:
Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures.
Zero configuration - no setup or administration needed.
Implements most of SQL92.
A complete database is stored in a single disk file.
Database files can be freely shared between machines with different byte orders.
Supports databases up to 2 terabytes (241 bytes) in size.
Sizes of strings and BLOBs limited only by available memory.
Small code footprint: less than 30K lines of C code, less than 250KB code space (gcc on i486).
Faster than popular client/server database engines for most common operations.
Easy-to-use API.
TCL bindings included. Bindings for many other languages available separately.
Well-commented source code with over 95% test coverage.
Self-contained: no external dependencies.
Sources are in the public domain and can be used for any purpose.
More information about SQLite can be found www.sqlite.org.
