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