We designed the PostgreSQL DatabaseEngine with a single goal in mind: we wanted to provide an easy and automated migration path for existing ISAM-based applications to the PostgreSQL DBMS without major code changes in business logic.
We knew we needed to design and implement two different technologies for that. First and foremost, a technology that emulates ISAM behavior with the minimum of compromises possible while at the same time beating existing performance in multi-user scenarios. And second, there is also the requirement to have transparent SQL access to that data. From within the Xbase++ application and outside - meaning other programming languages and tools.
The PostgreSQL DBE is for your existing ISAM code and your existing ISAM knowledge. It is our promise to protect your existing investments. If you are experienced with SQL and writing new code, we encourage you to use the parametrized SQL statements via DacSqlStatement(). Specifically, query processing becomes a snap.