Overview Professional

The PostgreSQL DatabaseEngine (PGDBE) can be used by any Xbase++ application to access the PostgreSQL Database Server. The only prerequisite is an installed PostgreSQL server and a network connection using the TCP/IP network protocol. Due to its client/server characteristics, deployment of the server on the same machine the application is running on, as well as deployment on a network (or via the internet at a remote-site), is supported.

As illustrated below, the PostgreSQL DatabaseEngine is a fully contained stand-alone DatabaseEngine. To communicate with the PostgreSQL Server, an extended version of the PostgreSQL client library LIBPQ is used. The PostgreSQL DatabaseEngine supports all PostgreSQL servers, starting with Version 8.2 or higher. The communication with the server is done using TCP/IP socket connections.

Hint: Because the connection to the PostgreSQL DatabaseServer is done using the TCP/IP network protocol it is possible to develop mobile applications which connect to the Server from the outside. If carefully designed, these applications can perform very well, even over an average internet connection.

In contrast to other DatabaseEngines which are divided into different capabilities such as storage management or order management, the PostgreSQL DatabaseEngine implements all of the following capabilities:

It is therefore a fully-contained standalone DatabaseEngine which does not need an explicit DbeBuild() operation. Any DbeBuild() operation with this DBE is rejected by the Xbase++ runtime.