The next generations of the database engine originally developed as Btrieve, PSQL (known as Pervasive.SQL in prior releases) is a collection of products that developers can use to add database functionality to their applications. Individual PSQL configurations are available for Workgroups (small group multi-user access without requiring a dedicated DB server) and Server versions, with implementations targeted to applications for small to mid-sized organizations. Cross platform configuration of the DB is identical, and the Distributed Tuning Interface (DTI, provided as part of the SDK described below) allows developers to build DB management tasks, such as stopping and starting remote services and accessing/monitoring DB settings and usage directly into their applications (when implemented as a 32-bit DLL).

The PSQL family itself focuses primarily on providing a backend data engine for developers to use within their applications. As such, it provides individual tools, collectively known as the PSQL SDK that assist the developer in accessing the engine from their language of choice. DB interface support is provided via JDBC and Java Class Libraries, ActiveX, ODBC, OLE DB, PDAC direct access components for Delphi/C++ Builder environments, and a Btrieve native interface for low-level direct access to the database.

New features in the latest release include:

- Revamped SQL engine and expanded syntax support

- New PSQL Control Center for PSQL management

- SQL outline view to assist in development of large SQL scripts

- 128 GB Table Size, and 8K page size

Additionally the vendor notes as scheduled upcoming enhancements to the DB DDF Builder, and Full Text Search capabilities.

The new release (v9) is available now. Contact Pervasive Software for further information.