Proxy Service

iAuxSQL offers unique feature to serve as client-server proxy for a database operations. Proxy is a special secure communication layer which abstracts communication with native database clients. Proxy server communicates with native database client while proxy client just communicates with proxy server. Proxy service allows to make a networking even file-based database, such as SQLite.

Server

Proxy server is an access point for all proxy clients. It is driven by own or user thread and communicates with databases native clients. Proxy server is capable of communicating with a database being hosted on a different machine somewhere on the network.

Client

Proxy client behaives as if it is works directly with native database client. In this case application which is communicating with database does not feel any difference between working directly with database or through communication layer of proxy connection. Proxy client supports all types of database queries: execute, query with full result, query with partial (use) result, transactions.

Secure Communication Layer

Proxy service provides extremely strong encryption for communication process between proxy server and proxy client. Encryption is done by strong algorithms: TwoFish, BlowFish, GOST 28147-89 or ARC4, which are operating in OFB or CFB streaming modes. Encryption covers data passed during communication, as well as packet headers with additional CRC7 check sum. Moreover, the data communication directions (send/receive) can have different passwords and IV vectors.

IP Shield

Proxy server operates as IP Shield and it is possible to set a list of allowed client addresses and passwords for more enhanced security. It is also possible to simplify operations by switching off IP shiled or setting some global password for all connections.

Schematically Proxy service looks like that: