The Pervasive PSQL Relational Interface
Pervasive PSQL’s relational interface, built on the SQL Relational Database Engine (SRDE), offers easy installation, uncomplicated maintenance, and high levels of performance and reliability.
Benefits of the Relational Interface
Many relational database application developers choose Pervasive PSQL because it provides scalability, maintenance-free operation, and a small memory footprint:
•
Standard Interface. SQL and ODBC provide a well-known and standardized foundation upon which to build useful applications.
•
Speed. Pervasive PSQL offers direct ODBC access to the database engine. Many competitive products use a translation layer to translate ODBC calls to proprietary “native” relational API calls that then access the database engine. In contrast, the Pervasive PSQL ODBC driver calls the database engine directly, without translating ODBC calls to a proprietary relational API.
•
Scalability. Pervasive PSQL allows you to scale applications from single-user to large client/server environments without changing the application or the database.
•
Maintenance-free Operation. Pervasive PSQL is simple to install and use. It requires no extensive performance setup or ongoing tuning by a database administrator.
•
Small Memory Footprint. Pervasive PSQL has a small footprint, requiring only a small amount of memory.
Relational Features
The Pervasive PSQL relational interface provides a flexible architecture that helps you easily scale your database applications from large client/server systems to single-user environments without additional coding. Pervasive PSQL offers easy installation, uncomplicated maintenance, high levels of performance and reliability, and a smooth migration path for data. In addition, bundling Pervasive PSQL with your application is easy with the Pervasive PSQL distribution component, which provides multi-user and single-user run-time support.
Pervasive PSQL has a comprehensive relational database management system interface that offers many features, including the following:
•
Application scalability from standalone to client/server.
•
Fully functional Workgroup and client/server engines.
•
Declarative Referential Integrity.
•
Bi-directional, updateable, and scrollable cursors.
•
Named database support providing location transparency for applications.
•
Comprehensive, industry standard data type support.
•
Programming extensions such as triggers and stored procedures.
•
Cost-based optimization from statistical analysis and enhanced fetch algorithms.
•
Transaction processing enhancements such as full transactional logging.
•
Standards enhancements, including ODBC support.
•
Other features include additional Windows utilities, large file support (up to 256 GB), and additional data type variables such as TIMESTAMP, UNSIGNED, and CURRENCY.