The Vita Voom pgExpress © PostgreSQL dbExpress Driver is a Borland Kylix/Delphi 6+ Driver that directly accesses PostgreSQL 7.1+ databases. No ODBC layer is needed. This the first dbExpress driver in the world to access a third-party/SQL server, and, as far as we know, the first developed using Borland Delphi.

The pgExpress PostgreSQL dbExpress driver can access PostgreSQL databases, use all its field types, and is compliant to the Borland specifications of dbExpress drivers. The pgExpress Driver also includes support for stored procedures, through use of PostgreSQL functions.

Arrays are mapped as strings and ADT (custom fields) support will be fully supported only by the pgExpress Suite. It has support for all the most commonly used PostgreSQL field types: int2, int4, int8, serial, char, varchar, text, date, datetime, time, timestamp, timestamp with time zone, BLOB (large objects; read only), float, real, numeric and others).

Highlights of the pgExpress Driver:

• 100% VCL/CLX implementation - unlike other drivers which are coded in C language, our driver is 100% coded using Borland Delphi itself (and Borland Kylix). This automatically makes it portable to any platform where Delphi/Kylix/C++ Builder are available.


• Portability: Delphi, Kylix and C++ Builder are supported.


• dbExpress protocol 3.0 support; pgExpress is the first driver to implement it outside Borland.


• FAST: The pgExpress Driver is highly optimized, and designed to minimize the traffic to the server as much as possible.


• Low Cost: pgExpress has NO RUNTIME FEES and does not need to be licensed in a per machine basis. PostgreSQL itself has the most unobstrusive license in the market - BSD (totally free).


• Exclusive features: the Vita Voom Software pgExpress Driver has much more features than the Borland's Kylix PostgreSQL driver, is available also for Delphi and has features not found on any other driver. Some of the exclusive pgExpress features (over Borland's PostgreSQL driver) are:
  
  • Delphi 6/7/8/2005/2006 support.
  
  
  • Borland C++ Builder support.
  
  
  • Kylix 1/2/3 support.
  
  
  • Supported databases:
    • PostgreSQLv.7.1 to 8.1 or the latest
    
    
    • EnterpriseDB support.
    
    
    • PostgreSQL - Red Hat Edition Project
  
  
  • Extensive documentation
  
  
  • Full types support - all regular types from PostgreSQL are supported
  
  
  • Automatic support for locale/decimal separator settings
  
  
  • Multibyte support
  
  
  • Connection timeout Support
  
  
  • Several custom settings that modify the way the driver works.
  
  
  • Stored Procedures Support (emulated through functions)
  
  
  • Automatic Fetch Cursors
  
  
  • Native support for LargeInt/Int8/Int64 types
  
  
  • Support for unknown types
  
  
  • Ability to work with quoted object names
  
  
  • Schema support (for PostgreSQLv7.3+)
  
  
  • Custom, elucidating error messages
  
  
  • Asynchronous connections, with option to cancel them (exclusive among all Delphi interfaces).
  
  
  • UNICODE (TWideString) support.
  
  
  • Localization. You can easily have driver messages in your own language; check the languages already implemented, or implement yours.
  
  
  • Support - Vita Voom Software primes for its custumers. We have a real great and responsive support system for ensuring our customers have the best and fastest possible support.
  
  

• Reability - Since the driver is based on dbExpress implementation, it minimizes the possibility of bugs on database applications, because many of the code that actually access the databases from Delphi it is proven technology written by Borland.


• Database independence - you can switch to another database, just by replacing the driver for another one. This is a main advantage of the dbExpress technology itself.


• Small - The pgExpress Driver is around 100Kb (non-Multilanguage version).