Print E-mail

iAuxSQL_small

iAuxSQL is a high-performance and cross-platform C++ SQL database API library which provides unified interface to the popular SQL database engines, such as: MySQL, PostgreSQL, Oracle, SQLite. Along with just unified database operations via unified interface iAuxSQL library provides many additional unique features which could be very useful for any application.

 

Scalable

iAuxSQL database library is capable to operate with extremely high load or serve for some trivial data management tasks being always fault-free and highly productive.

  

Unification

One of the main goals for iAuxSQL is to unify specifics of every supported database native client API. Whether this is MySQL, or PostgreSQL, or Oracle, or even file-based SQLite - a programming interface of iAuxSQL must have no differences depending on chosen database type. Such unified interface provides ability to switch from one database type to another even during a run-time of the application.

  

Transactions

iAuxSQL provides unified mechanism to issue a transactions with queries to a databases. iAuxSQL supports native transactions and also implements own transaction core that allows to have transactions with databases which do not even support them. Transactions are fully asynchronous for the application and are executed in own processing thread of iAuxSQL.

 

Proxy

iAuxSQL offers world unique feature of database communication abstraction known as Proxy service. It is a server-client model that allows to communicate with any supported database through iAuxSQL highly-secure network protocol. This feature makes it possible to communicate with database from any environment where native client libraries do not exist. iAuxSQL proxy can be used to increase security of database communication process to a highest possible level.

 

Mobile Platform

iAuxSQL support popular mobile platforms -Windows Mobile 6 and iPhone. Its built-in SQLite core allows to make a phone or any other portable device - a database storage. Proxy service allows to access any supported database. iAuxSQL loads dynamically database native client libraries and is ready to operate with them if those are ported to mobile platform as well.

 

Features

  • Supports databases: MySQL (4.1, 5.0, 5.1, 5.4, +), PostgreSQL (8.2+), Oracle (10.2+), SQLite (built-in: latest), with single unified interface.
  • Supports transactions with additional internal implementation.
  • Proxy service - database communication abstraction layer.
  • Asynchronous core with separate queries executor.
  • Searialization of binary data into following formats:
    • Base 16;
    • Base 32;
    • Base 64;
    • Zip + Base 64 (inflates/deflates data on the fly).
  • Cryptographic services:
    • Block ciphers: TwoFish, BlowFish, GOST 28147-89;
    • Stream ciphers: OFB mode for block ciphers, CFB mode for block ciphers, ARC4 (for Proxy only).
  • User-friendly C++ interface and rich in-line documentation.
  • OS: Windows XP/Vista/7 (32/64 bit), Windows Mobile 6 (ARMV4I), Linux (32/64 bit), MacOSX 10.5.4+ (32/64 bit), iPhone (Device/Simulator).
    •