PSQL SDK
The PSQL SDK includes many features to ease the burden of application development. These include:
•
Low-level APIs. Direct programming to the Btrieve API gives you the fastest possible data access and the most control over the way in which your application reads and writes data. If these considerations are important to you and you are willing to develop the code that incorporates your business rules, you may find direct API programming highly useful. For relational access to data, you may also code directly to the Microsoft ODBC API.
•
ODBC. PSQL offers a native ODBC driver.
•
PSQL ADO.NET data provider. The data provider provides support for the Microsoft .NET Framework, and is an ADO.NET managed data provider, built with 100% managed code.
•
Java. The Java Interface gives you the option of developing Btrieve applications in an object-oriented, platform-independent manner. It includes support for true null and Unicode values as well as for Binary Large Objects (BLOBs).
•
Distributed Tuning Interface and Objects. These two related interfaces allow applications to tune and manage the database engine itself, including configuration parameters and aspects of security.
•
OLE-DB. The OLE-DB provider offers access to both the relational and transaction interfaces.
•
The ActiveX Interface. The ActiveX Interface allows you to leverage the power and speed of the PSQL engine with a minimum of manual coding. These controls are designed for easy use with third-party grid controls as well.
•
Complete sample application. PSQL SDK includes a complete sample application designed to run a video rental store. Full sample code in Visual Basic, Delphi, Java, and C/C++ is supplied. Examples using ODBC, ActiveX RDO, third party controls, and direct API calls are shown.
•
The PSQL website is an online resource that gives you access to the latest component downloads and code samples.
Development Environment
PSQL provides an open interface that allows you to develop many front-end applications, all of which can share a common, transactional, or relational database. You can use popular programming languages and environments such as Java, Delphi, BASIC, Visual BASIC, .NET, C, C++, COBOL, Pascal, ODBC, PowerBuilder (through ODBC), and FoxPro (through ODBC). In addition, bundling a PSQL engine with your application is easy with a Derivative Software License.