ESSQL is an acronym for Embedded System System Query Libary. It features the following:
- Proprietary protocol over TCP/IP which permits both synchronous and asynchronous event processing.
- Supports synchronizing embedded system data to SQL tables.
- Provides API for SQL to embedded system both by top-level SQL engine interface, e.g., "SELECT, INSERT, UPDATE" as well as a "C" interface for users' extensions.
- Eliminates embedded system's need to implement a full client connection protocol.
- Provides data exchange in embedded systems native form to eliminate parsing and conversion to and from ASCII.
- Provides for "transaction rollback" to eliminate database corruption caused by failures.
- Monitors TCP/IP connection via heartbeat when idle to detect loss of connectivity.
- Runs on most variants of Linux as a daemon.
- Support for several SQL servers - PostgreSQL, MySQL and Oracle.
- Support libraries for a number of embedded processors and modules including Rabbit.
- Look at a typical application.