Overview of PSQL Access Methods
 
Overview of PSQL Access Methods
The following topics introduce and summarize the methods of programming with PSQL:
Overview of PSQL Access Methods
SQL Access in PSQL
Other topics provide details and instructions for developing Microkernel Engine applications, designing databases, using language interfaces, accessing and managing data, and working with client-server environments.
Overview of PSQL Access Methods
The following table lists the 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
SQL Access in PSQL
ODBC is the data access method for SQL databases. It brings several advantages:
Improved performance
Standards-based API
Central to the operation of the PSQL replication product
You do not have to learn the ODBC API to develop PSQL applications. Additional interfaces, such as OLE DB or JDBC, can simplify development.