Overview of PSQL Access Methods
The following is a summary of PSQL access methods and APIs.
Access Method
Description
Used For
Btrieve (MicroKernel Engine)
Original Btrieve API
Creating Btrieve database applications
ADO (Microsoft IDEs)
High-level visual or code-based programming
Visual programming of transactional or relational (SQL) applications. This is the recommended programming interface for Microsoft development environments.
PDAC (Embarcadero IDEs)
PSQL Direct Access Components for Delphi and C++ Builder
Replaces functionality of Embarcadero data-aware components and eliminates need for Embarcadero Database Engine.
ODBC (relational)
Microsoft’s Open Database Connectivity
Creating SQL-based applications
Java Class Library
Java Class Library for MicroKernel Engine data access.
Creating Java-based applications that connect to the MicroKernel Engine
JDBC
Implementation of Sun’s Java Database Connectivity
Creating JDBC-based SQL applications using an industry-standard API.
Distributed Tuning Interface (DTI)
PSQL’s API for monitoring and administration
Performing administrative and utility functions from applications, creating and maintaining Data Dictionary Files from applications
Distributed Tuning Objects (DTO)
PSQL’s object-oriented programming interface for monitoring and administration
Performing administrative and utility functions from applications, creating and maintaining Data Dictionary Files from applications